PDA

View Full Version : Excel Miscellaneous


Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 [60] 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270

  1. CAE macro for green screen updates with Excel data
  2. Cell Selection by Content
  3. Anyone have an Excel template for Skeet /Trap Scores?
  4. Live Scrolling/Real-Time /Smooth Scrolling doesn't work for me in Excel, even 2007 beta
  5. Cursor not behaving
  6. Sorting - cells containing numbers, numbers and letters
  7. separating text from cells
  8. When I open a an existing excel worksheet, it duplicates itself a.
  9. Number sequence
  10. Having trouble with number series
  11. Auto Updates by moving columns
  12. Run time Error
  13. prepares to re- install Office and I get error message 1312
  14. Saving Text File
  15. How do I create a backup copy of my software?
  16. Counting Text Strings With Conditions
  17. Match two row numric
  18. How to change character to lower case except the first letter?
  19. Delete Row Containing "x" in ColumnA in 2 Worksheets
  20. Updating Shared Workbook
  21. Why I get gray area in sheet tab of page setup? can't resize area.
  22. Excel falls over loading...
  23. Comma Deliminated File Format
  24. Updating Cells with new info
  25. Updating Cells with new info
  26. Updating Cells with new info
  27. Updating Cells with new info
  28. Updating Cells with new info
  29. Updating Cells with new info
  30. SUMPRODUCT/HLOOKUP Query
  31. Is it possible to do it by a single-line formula(without using VBA)?
  32. Strugling IF Formula
  33. EXCEL workbook is off-white, goes white in edit mode
  34. Orif
  35. It is possible?
  36. hyperlinked
  37. A few simple functions
  38. Sum data between 2 dates ie 01Jun-30Jun
  39. Search for 2 true arguments and return true or false
  40. autofilter - how many in a group
  41. autofilter on many columns
  42. Pivot Table
  43. Sorting Problem
  44. How to copy from Adobe with tables to Excel with columns intact
  45. Help, help, help.
  46. Missing list and option boxes
  47. Changing Where Data Validation List Boxes Open in Mac Excel 2004
  48. Chart Titles not showing in excel chart Window
  49. I need help with a formula or a sorting action
  50. Percentage calculations from an unsorted two column list
  51. defined object
  52. External reference to spreadsheet names (tabs) help needed.
  53. Formula help
  54. how 2 convert (exel macro's >> mysql) ??
  55. Excel Addition Error
  56. Button Confusion
  57. Pivot Table: Remove old field cell value
  58. Using Hyphens in a cell
  59. Should be easy...Auto Date Fill
  60. Macro Question
  61. a formula which calculates empty cells
  62. print images in excel 2007
  63. Stopping conversion to an elipse character
  64. make cell color change if requirements are met?
  65. Printing spreadsheet to a plotter.
  66. How do you keep Headings from work sheet to worksheet in a Book?
  67. Trouble opening large size Excel file 155Mb in Excel 2007
  68. external reference to file in the same folder
  69. Excel View
  70. Error suddenly started occuring
  71. Color tabs?
  72. Trend line change
  73. for and if statement within another for/if statement
  74. Average
  75. How to set-up a field that displays the last updated date
  76. Protected Hyperlinks
  77. Excel Filter Data
  78. Auto format quarter start date
  79. why does excel return a : when I put in a .
  80. Copy Alpha value into another cell.
  81. Filename in a formula generated automatically?
  82. Auto sort in asending order
  83. The vertical gridlines have suddenly disappeared from all my w/s.
  84. Matching month part of date only
  85. Calculate average based on date and other criteria
  86. Is there a way to begin printing a footer on page two in Excel?
  87. How do I calculate profit as a % of Sales price
  88. Greater than dates
  89. sumif range to end of data
  90. Creating a summary sheet from data across multiple worksheets
  91. HOW TO i HAVE OTHER CELLS GENERATE CONSECTUIVE MONTHS
  92. How do I put a Month into a cell and have the cells below change
  93. I WANT EVEN NUMBERS; NO DECIMALS - ROUND
  94. PivotTable Question
  95. This has been asked, but not answered...
  96. Print only selected data from ComboBox?
  97. Getting Labels...
  98. Removing custom toolbar from Excel 2003
  99. Can the author of an .XLS be found and retrieved ?
  100. How does one disable Auto-Formatting of dates?
  101. Extracting Data for .Txt Files By Unique Field Data
  102. Customizing Auto Filter
  103. Macro to create PDF's question
  104. Combo box
  105. Form Letter and Embeded Word Object
  106. Convert numbers to text
  107. Linking Master Workbook & subordinate workbook
  108. Extra comma at the end of a function
  109. Creating a timetable
  110. Inserting a chart of data into Word
  111. type 56092036 (C), ~, the (C) changes to a small c with a circle
  112. what symbol should i put in the formula to make a cell constant?
  113. varying column width by row
  114. How do I find out why it won't save?
  115. Sharing - Automatic Updates
  116. How do I resolve unsuccessful security downloads for excel?
  117. Easy one I hope
  118. How do I add the funktion for customize colors i Excel?
  119. Formula for the Following Day
  120. How to add a normal distribution to a histogram
  121. data verification
  122. Online resources to learn to use formulas
  123. Formula Help
  124. How to make Primary axis and Secondary X-axis have the same scale
  125. Subtotals to separate sheets?
  126. [$-F800] in the number format string
  127. Extracting data from a cell
  128. Select the entire row
  129. copy and paste after filtering
  130. carry over data to other sheet - help needed
  131. blank cell formulae do nothing
  132. Checkbox re-aligns after print or print preview
  133. Conditional Formatting in Macro
  134. Adding a line to a PivotChart
  135. How to found changed cells?
  136. Writing to Excel through Response object
  137. can i create normal distribution curves in excel?
  138. Scrollarea
  139. further if problem
  140. seperate data from one cell into many....
  141. File/custom Property fields
  142. if problem
  143. Inputbox calculations and "outputbox"
  144. Indirect Reference
  145. Losing count on bottom left hand side when filtering - HELP!!!
  146. Unprotect Worksheet.
  147. Apparent Locked Cursor
  148. Can Excel 2003 cell link carry with it the source cell format?
  149. how to set excel at the default setting for the enter key?
  150. #value! on spreadsheet when formula palette gets correct result
  151. How to auto populate an invoice from data in an existing worksheet
  152. spelling errors in excel
  153. Too many nested "IF"'s: a work around needed for this example...
  154. Visual Basic Help - Pivot table, formatting colors
  155. Help on filling empty cells with string + row()
  156. RE: New case of Month Formulas
  157. Allow custom update button to work while sheet is protected
  158. How do I subtract in Excel xp
  159. New case of Month Formulas
  160. Sum or subtotal at a specified amount
  161. Pivot Table Grouping or Calculated Field
  162. menu / toobar item for open file by name
  163. separate scroll bars for each area of split screen
  164. Delete a row with a certain phrase?
  165. How do I date each page when printing a schedule book?
  166. what shortcut key do I use for the + symbol over the - symbol
  167. How to automate this task
  168. SumIf function
  169. A Macro that Copies from Excel & Pastes into a webpage
  170. can I fix 1 column & scroll across others?
  171. working with funcions in filtered lists
  172. Vlookup to Return a Range of Data
  173. Importing email into excel
  174. Vertical line in a histogram (vertical bar chart)
  175. How do I set up a spreadsheet with 3 different variables
  176. lookup function on a merged cell
  177. Conditional Formatting In a Range
  178. lookup returning several cells
  179. Identifying records with Zero in the data section
  180. Why can't I name a cell "c" in Excel?
  181. select last cell in a dynamic list using a macro
  182. Can I have a cell with more than one formula that pulls different.
  183. excel should highlight current line (row)-easier for large spread
  184. Excel Count Weekdays Formula
  185. Column Width
  186. Replacing an ERROR message with "NA"
  187. HELP WITH GRAPHS
  188. Place all subtotals at bottom of pivot table?
  189. Clipboard
  190. How do I get a Pivot Table to repeat the values in the columns?
  191. Password Recovery
  192. Formatting Question
  193. Prompt for protection password when not trying to access VBA
  194. Making a Graph
  195. Data Connection - Active Directory
  196. Confusing Problem
  197. Setup
  198. Large spreadsheet-multiple users-password protected-filtered
  199. Loosing comments in a shared workbook
  200. Naming Tabs
  201. Creating a drop down list that will fill in mutilple cells....
  202. VBA for increased conditional formatting choices
  203. IF FORMULAS
  204. calculate based on color
  205. wrtie a macro to delete certain rows
  206. How do I consoldiate a List of numbers to show each number once ?
  207. Shared Excel File Question
  208. copying info from on cell to several other cells several thousand
  209. screen view doesn't match what's in the cell
  210. "0's"in a cell
  211. efficiency: database functions vs. math functions vs. array formula
  212. Currency format not working
  213. How can I create up a stock control system in Excel?
  214. formula
  215. sorting multiple rows
  216. I have arrowheads in upper left of some cells. How can I remove?
  217. Limit the amount of digits displayed in a field in Excel or Access
  218. Formula auditing unavailable
  219. blank cell as zero
  220. find more than one cell
  221. with a drop down list in excel how do I select multiple values
  222. Can you change the font on sheet tabs?
  223. Size of Workbook(columns/rows/data)
  224. Problem renaming a worksheet tab
  225. Excel Help Needed
  226. How do I get a cell value based on different criteria?
  227. msn stock updates quit working & no internet connection in excel
  228. Change the row and column indicators
  229. INDIRECT Follow On
  230. Is there a way to unhide multiple sheets at one time?
  231. Re: Conditional Formatting - Getting pass the 3 condition limit
  232. Scanned files into Excel?
  233. Merging
  234. get folder syntax
  235. Conditional Formatting with NETWORKDAYS function
  236. Using A Cell In Excel as Criteria for a Query
  237. Drop down lists
  238. IF statement problem
  239. Locking columns and not protecting whole sheet
  240. Indirect Reference to Other files
  241. Remove Decimals
  242. How can I count min bt 100ths
  243. Dates on Charts
  244. New Excel
  245. how do I match data from two separate files in excel
  246. Eliminating the quote "This document was sent to the printer"
  247. Password-Protected Workbook not showing "in use by another user"
  248. Accounts Receivable Aging Report
  249. One to get you thinking.
  250. Hide Formula