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. How do I cut an Excel column of back to first 2 characers? Thanks
  2. I need a formula!!Ahhhh!
  3. blank rows between copied rows
  4. How do I not display the Euros sign, if value is 0?
  5. Using Vlookup with merged cells...
  6. Conditional formatting
  7. How do I lock the top 2 rows (headings) so that they are always displayed when moving around the spreadsheet?
  8. Sort by number not by letter (C1, A2, B3, D4)
  9. is it possible to recover an unsaved excel file that was x'd out
  10. Multiple users / Shared workbook without interfernce?
  11. I saved file A over file B. Can I get file B back?
  12. View tabs side by side?
  13. Worksheet name linked to cell
  14. Replacing specific numbers
  15. prevent a cell from breaking and printing on the next page
  16. Change date format from US to English (Australian)
  17. Adjust column width
  18. Drop down list
  19. how to set print area for the entire excel workbook
  20. Can you save a previous file you overwrote?
  21. End of month function
  22. Excel Macro
  23. Scrolling too fast on one sheet
  24. WEEKENDS VS. WEEKDAYS
  25. code suggestion
  26. One sheet is scrolling 3500 per inch moved
  27. circle around text in a cell
  28. PERSONAL.XLS file
  29. create a pop-up
  30. Search In a Macro/VBA
  31. Lots of numbers and columns
  32. Status bar does not display filter mode
  33. copy data from one sheet to another
  34. Assigning numbers to names
  35. I need a chart reference if certain criteria is entered...
  36. When i put a number in it changes to a date why
  37. Command button
  38. Hyperlink to an email to send a spreadsheet
  39. Protected worksheet
  40. multi split view
  41. STOP WORKBOOK CLOSING
  42. Simple question..I think
  43. Separate Paragraphs in a cell?
  44. Text Changing, based on data
  45. Running macros without lowering security
  46. Data Validation: Printing Invalid Data Circles
  47. Baffling! Spreadsheet Data Form Size
  48. My editing window is disappeared.
  49. Displaying numbers stored in a range???
  50. Display a UK Map from excel list Postcodes
  51. Hyperlinking from Outlook 2003 to an excel Worksheet
  52. Advanced filter
  53. use of calendar object?
  54. Formula follows the most recent entry in a column???
  55. Complex Formula Getting Error..
  56. Row sorting question
  57. Pivot Table Question
  58. 2 copies open
  59. Multiple Conditions
  60. Conditional Formatting-Comparing Two Columns
  61. Conditional Formatting-Comparing Two Columns
  62. Excel Copy/Paste Problem
  63. Formula Question
  64. How do I sort contents alphabetically in Excel?
  65. Cell value equals last four charecters
  66. How do I unlock Excel
  67. Conditional Formula
  68. new priorities
  69. When i delete rows the program freezes
  70. Converting CAPS text to Proper Case
  71. linked cells change to literals
  72. monthly quarterly splitting
  73. Cannot open Excel via icon or open Excel spreadsheets sent to me.
  74. Run time error 1004!
  75. Connecting Worsheets when there is a filter
  76. Update data automatically among worksheets
  77. I need a productif type function
  78. Can I create an index in an excel table?
  79. data validation
  80. Count consecutive dates only
  81. how do you get # value returned by entering: =4^3 (answer 64)???
  82. External data query leaves datasource workbook open
  83. Countif Statement
  84. Run Time error 1004
  85. Checking if a number appears within a cell
  86. Excel 97 File Recovery after Drive was erased please help.
  87. How many 'if's'?
  88. MS Office OFFLINE help does not display
  89. In spreadsheet click on one cell and several are selected
  90. sending excel spreadsheets to cell phones
  91. Excel Formula Help
  92. excell values
  93. restore title bar icons
  94. How do I set the Options to View Zero Values to be off always
  95. Entering a range of numbers and searching same
  96. Re: Protection & Grouping
  97. FORMAT COLUMN
  98. Change the column designation from a numeric to an alpha
  99. Conditional cell
  100. MACRO ACTIVATED EVERY 5 SECONDS
  101. Cut Option
  102. Excel 2003: I can't save customized toolbars.
  103. Individual Error Bars
  104. Unable to edit query
  105. how to delete header on second page of spreadsheet
  106. IF based on date
  107. Can I lock rows together and then filter for content in groups?
  108. INDIRECT
  109. Hyperlink to a graph.
  110. Automated Linking
  111. Excel Pivot chart - Scales of multiple field buttons
  112. Excel Pivot chart - Scales of multiple field buttons
  113. Format cells in pivot table
  114. I displaying a range in Time within a cell in Excel.
  115. Sorting dates with Vlookup
  116. Delete a row if blank cell
  117. Delete a row if blank cell
  118. Formatting
  119. How to merge cells in Word document by VBA code??
  120. Hover change
  121. How to Open the source list workbook automaticlly in Excel 2000?
  122. Non Adjacent percent average total
  123. Sorting columns
  124. Print page 1 of all work sheets??
  125. Hiding columns, custom views, protected sheet
  126. VBA between programmes
  127. Sorting problem
  128. Entering Values into Combobox in Spreadsheet
  129. Advanced Filter
  130. Getting percentile averages without the #DIV/0! errors!
  131. File Exists
  132. need help with expression
  133. Dynamic named range & Offset
  134. I am trying to figure a discount based on a count
  135. Complicated value lookup
  136. How many sheets in a workbook
  137. Comments Only
  138. Furmula Dependent Cell References
  139. Copy and Paste subtotlals
  140. What is the maximum formula lenght??
  141. how can I eliminate the last character of a cell?
  142. Replace #VALUE! in cells of a worksheet
  143. How many concurrent nested IF statments does Excel allow?
  144. How do I arrange my tabs in alphabetical order all at once?
  145. Combination of Vlookup & Hlookup
  146. Saving
  147. Excel: Narrow print area to wrap to 2nd "column" on page
  148. Excel: Narrow print area to wrap to 2nd "column" on page
  149. #N/A in vlookup
  150. Numbering Multiple Sheets
  151. Printing Excel Comments
  152. How do I group columns?
  153. Struggles with Numercial Sorting. Please Help.
  154. Struggles with Numercial Sorting. Please Help.
  155. Data Validation Message
  156. More than one copy of EXCEL 2003 invoked
  157. Help help, combining limited data
  158. Hidden cell contents with text wrapping
  159. count
  160. Change Order Management Tracking with Budgeting Focus
  161. Set Range of visible Autofilltered columns VBA?
  162. I am not able to control the margins.
  163. Pivot table subtotals
  164. html import errors
  165. date comparison help
  166. Need formula to calculate days between dates or back date
  167. Date Day Assistance
  168. INDIRECT Question I think
  169. Multiple Worksheets
  170. "Find" in Excel '03 - no keyboard key for closing dial.box like in
  171. Getting rid of error messages while using IF statements
  172. Getting rid of unusable charts?
  173. File in Use
  174. How do I take a toolbar created at home and install it at work?
  175. Sum in first blank cell and a few more things...
  176. HELP---Pivot question!!
  177. how do web query excel 2003 from site in browser?
  178. If protecting a sheet I lose the autosum feature, any way around
  179. VBA for file save as
  180. Message Errors
  181. Named cells across Excel files
  182. Golf Scores
  183. File->Open Long Delay
  184. help with VB/Macro to shift cells
  185. Excel 2003 can't do case sensitive sorting!
  186. Excel should let you remove hyperlinks for any range or selection
  187. pivot page prints
  188. MS Query and Excel 2003
  189. help with VB/Macro to shift cells
  190. Average
  191. I WANT TO REPEAT SOME CELLS AT THE TOP OF THE SECOND PAGE
  192. Formulas Not Working in Excel 2003
  193. Go to target cell
  194. CREATING A CUSTOM FILL WITH WORKDAYS
  195. change value with single click, increasing by 1 every time?
  196. ifs and ors
  197. Changing a column name
  198. How do I insert new fields in Excel DB created using template wiza
  199. How do I get leading zeros in zip codes in a mail merge
  200. vlookup
  201. Not obtaining the correct result
  202. Re: range in link?
  203. range in link?
  204. How do I filter names in Excel to eliminate repeats?
  205. MATCHING COLUMNS
  206. Hi Dudes, Take a Look, I did it
  207. Hi Dudes, Take a Look, I did it
  208. Hi Dudes, Take a Look, I did it
  209. Sum function
  210. Chart Series Formats lost when list re -sorted
  211. How do I assign keyboard shortcut for Grouping?
  212. Are you able to give a letter a number value
  213. how do i set decimal point like a calculator
  214. First Over 0
  215. Copying 1 column into multiple columns
  216. Working with range of numbers in a cell and searching same
  217. In Excel, print non-consecutive columns.
  218. Filters
  219. Autofilter Not Filtering Properly
  220. FORMULAS
  221. excel template inherit
  222. My Excel (2002) always opens on March 29 tab - how do I change it?
  223. Inverse rank
  224. How to correct a "#VALUE!"
  225. Text Box Comments
  226. AddNodes msoSegmentCurve
  227. Problem of corrupt file
  228. If Statement Problem
  229. Formula not working
  230. wrapped text cell
  231. missing data on screen
  232. Row and Column References
  233. Changing fixed width (column break) defaults when importing text
  234. Changing cell references in a Range to Absolute
  235. If contains
  236. need to compare two lists and identify cells with same numbers in
  237. Sumif formula - help required
  238. Help with spreadsheet to track membership dues...
  239. Conditional Data Validation
  240. Changing Pivot Table source
  241. Multi-colour 'Area' chart
  242. Alternative Printer Button
  243. I need a formula
  244. Excel should indicate a list of inactive names
  245. Table linking
  246. Excel should indicate a list of inactive names
  247. I need a formula
  248. First name, Last name in seperate columns
  249. Password Protection
  250. Column Width