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. saving a file based on a value in predertermined cell to a specifi
  2. how do i get my orginal excel file back after saving over it
  3. constraints for the trend function
  4. referencing a name from a cell value
  5. protect a sort range
  6. Auto adjust rows to size of contents
  7. Chart legends question
  8. putting symbols front and
  9. How do I supress printing of text in certain cells of Excel 2003?
  10. excel can no longer recognise format
  11. graph problem - urgent help needed.
  12. Dropdown fields
  13. Sales Sheet
  14. quick sum display
  15. Sumif Query
  16. adding another document
  17. Macro to jump to today's date
  18. shared file want same view
  19. How do i multiply an hourly rate by hours in Excel?
  20. Excel 2007: More control over graphs wanted
  21. How can I change the label of the total fields in a pivot table?
  22. Need multiple users advice
  23. protecting certain cells
  24. formula too long!
  25. Row height using autofit, with no merged cells
  26. Specifying number of decimals in a number
  27. HOW DO I PRINT EVERY OTHER PAGE OF A DOCUMENT?
  28. Aligning numbers to the centre of the cell
  29. Aligning decimal numers to the centre of the cell and aligning dec
  30. loan payments - Interest only?
  31. Creating charts in Excel...
  32. Textbox changes position on a copied excel-sheet
  33. Can't see/use folders on home network signed on as administrator
  34. IF and AND
  35. How to show the drive letter in the path on the title bar?
  36. changing pictures according to cell value
  37. Concatenate an array
  38. Lookup
  39. Dynamic range
  40. How do I get rid of the " read only" on a file I want to make chan
  41. How do I recover data that somebody pasted over on the wrong page
  42. Some type of header
  43. Auto-increment data source cell references when copying charts
  44. End of run 'clean up" . . .
  45. Countif to always get a positive number
  46. fill series that runs along opposite axis?
  47. Area under the curve calculation
  48. don't calculate if no date is entered
  49. Finding the most recent month's (or whatever) data
  50. macro to change multiple values in a column
  51. Decimal when itīs necessary
  52. month formulas
  53. loop thru column and highlight the rows
  54. Work Days Formula
  55. Using Multiple Tests and Sounds With Worksheet Macros
  56. find and highlight
  57. Formula for named range
  58. formula wanted please, I have a list of data
  59. RE COUNTIF: use < before a cell
  60. List control
  61. Default Excel opening blank spreadsheet name
  62. How do I make an IF statement have multiple TRUE answers?
  63. My chart no longer responds to data change, why?
  64. I have a read only xl file, I need it to be read and write
  65. calculating total in a range of numbers
  66. hyperlink question
  67. Comments box, kinda.
  68. Multiple data in stack column chart
  69. Excel Open Error
  70. VIEW a hyperlinked docs in a emails workbook?
  71. Help with Look Up Table Please?
  72. Inverting worksheet (not graph) axises
  73. NACHA FILE CREATOR
  74. I nedd help setting up a database on my customers
  75. Pivot Tables
  76. Multiple Criteria pulled from Drop Down Lists
  77. Finding an asterisk in a cell
  78. Unhide a workbook?
  79. 3 ?s. RE: Drop downs and comments
  80. Rows and Columns per Page
  81. Search & delete ANY text in select columns
  82. How to add hot-key to .xla file in VBA Editor
  83. Pasting into a column
  84. Dynamically changing the size of a list
  85. print box opens in right screen of dual screen setup why
  86. Consolidate Pivot Tables
  87. 3 variable find and replace
  88. How do I e-mail one Excel sheet to arrive NOT in HTML
  89. This should be simple
  90. Sum multiple cells with different numbers and text.
  91. Re: Not all of the text is visible.... (Attn: Dave Peterson)
  92. Populating Last Saved Date in Cell AND also update that same cell in Header
  93. Is there a limit to the number of rows in a excel spread sheet ?
  94. HELP with *** formula
  95. Problem with control tag and populating speadsheet
  96. Tranferring names defined in one excel workbook to another workboo
  97. Time rounding help
  98. Formatting a list of data into a row in Excel
  99. Divide by zero error
  100. Pivot table based on a .cub file?
  101. Worksheet_Change help
  102. Convert hours to minuets
  103. Custom Format - show as decimal
  104. pivot table single choice
  105. Pop-up Calendar
  106. Drag Formula Until ( )
  107. Protecting cells
  108. More IF Statement questions
  109. Why can't I autofill the alphabet?
  110. Excel crashes every few minutes
  111. Where are Macros stored?
  112. formula copying data and lay out
  113. St automatically changes to So
  114. Excel 2000 Help File - What keyword
  115. How do I import a CSV file to excel
  116. How do I keep zeros in front of other numbers (like a zip code)?
  117. Change text on one cell based on text in another
  118. How do I create an automatic date entry?
  119. Merging Worksheets - Fields Of Same Data In Different Location
  120. Does Anybody Know What This Is
  121. Formula returning the worksheet name
  122. monthly ppmt calculated in 1 cell for year
  123. How to find the correct program to download an .xls attachment
  124. MACRO Run Time Error 1004
  125. Sorting a Range
  126. Sending email to addresses in a column
  127. Pivot Table Questions
  128. Can you change the font color of a file name?
  129. Macro Error
  130. HELP linking to PDF files from Excel sheet on CD
  131. Dates in Excel (XP)
  132. workbook-Help
  133. extracting comma seperated from a single cell and auto populating in selected cells o
  134. Search multiple columns and display corresponding cells in a list?!?
  135. Can you enter a new line in an individual cell within Excel
  136. columns appear as numbers not letters
  137. Why is "History" a "reserved name" while naming Excel worksheets?
  138. Extracting Data
  139. The increase number of rows in Excel
  140. Excel printing "additional" blank pages?
  141. I need some help with userforms
  142. league table without macros
  143. Exctracting comma seperated data from a single cell
  144. Range limit for auto filter function
  145. want the corresponding Row & column to be highlighted tranparent
  146. Reporting multiple values within a cell
  147. How do I copy & paste only the unhidden data on a worksheet ?
  148. I'm unable to type in any new data in an Excel file.
  149. How to sort or aphabetize worksheets in Excel?
  150. Formula
  151. Multiple Formulas in One
  152. I cannot select more than 1 picture to insert. Why?
  153. where can i get a payslip template for excel?
  154. typing addresses & when I hit enter need to be on next line cel B
  155. sum a range after multiple criteria
  156. how do I change the font size in a combo box from the forms toolba
  157. command button
  158. Linking to a file
  159. 'Text to Columns'
  160. Can you join multiple databases using a pivot table?
  161. looking for camping trip planner template excel
  162. How can you add a blank row, per every other row, on an entire
  163. What function do I use to return a certain value for specific text
  164. Copy the value of a cell, no format, into several cells.
  165. vlookup subtotals value
  166. using a number to select cell location
  167. Standby in Excel
  168. Search for a number in a table and return data of a specific cell
  169. Lines in converting Excel docs from older to new
  170. Analysis Toolpak 2007
  171. Can I use "In" in an "If" statement?
  172. #NAME when using NETWORKDAYS
  173. Date Drop Down Menu
  174. Error formula
  175. using a dummy cell to reference a range into a formula
  176. intersection naming transport between files
  177. Excel 2000 Chart Y-Axis Scale break
  178. subtotals value can be vlookup by another worksheet
  179. Pivot Table Calculations
  180. Seperating text
  181. Reviewing Toolbar Default to Off
  182. How do I preserve cell content when saving an excel file in csv
  183. Turn off calculate event
  184. How do I lighten the word "Page" (and number) in Page Break View?
  185. My excel sheet is slow to changes.
  186. Counting dates in a spreadsheet....
  187. Extract from a file
  188. copy subtotal value only - also can be lookup from other worksheet
  189. Data Validation message popu-up
  190. Updating external data
  191. Data Validation (2 lists)
  192. Exporting from Quickbooks
  193. How to edit column data so that all but left most character remain
  194. adding times together
  195. Sort/Filter/Lookup
  196. Blinking cell
  197. What causes column headings in Excel to change from A, B, to 1,2?
  198. chi squares
  199. Auto filter is greyed out
  200. how do i open excel as an xls document from a web link instead of.
  201. How to use the $ to do global func> =ave($1:$1) more details?
  202. email
  203. 2007 calendar on one worksheet
  204. Dragging range (array)
  205. Pivot Table issue in Excel 2007
  206. Excel - PIvot Query
  207. User Choosing Which Columns to View
  208. Merge text in sequential order
  209. Looking and matching vaules to return another vaule
  210. Personal.xls macros not available when opening email attachment
  211. Extracting source data that I want
  212. How to 'copy' a drop down box selection?
  213. typing inside a pasted chart (jpg)??
  214. AGAIN: Page Borders (Seems like nobody knows...:))
  215. Adjusting the distance between data points on the x-axis
  216. Adding drop-down list to spreadsheet
  217. Removing Page Break Preview from all spreadsheets
  218. Calculation of monthly installments
  219. Checking if 2 of 3 conditions are met...
  220. Grid Lines
  221. How?Create master worksheet xls that will update previous records
  222. Text not wrapping within a cell
  223. why does edit query button not open query
  224. If Statements
  225. Page Breaks Won't stay put
  226. Translation from english to another language
  227. Navigating between cells
  228. Paste Special Dialog Not Correct
  229. Refresh MSQuery w/ Access datasource issue
  230. Creating a databse from several Excel files
  231. How to save a custom made header&footer
  232. Make chart title based on a cell?
  233. Worksheet/General Procedure problem
  234. problems trying to combine two sheets
  235. separate application windows
  236. macros
  237. Cell Format & Dashes
  238. adding custom format
  239. SQL concatenation statement
  240. Linking data
  241. Allow Insert of objects onto Protected Worksheet
  242. Cell protection - drop down list
  243. Automated titles for charts
  244. Non-Printable Worksheets
  245. How to point to (select) a cell to the left from a cell where I enter the = equal sign?
  246. How to efficiently declare variables
  247. if or formula
  248. how do i find the last cell
  249. Earn Honestly, No Tricks, No Bluff
  250. Add-Ins and Buttons