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. XL "zero-day" flaw used in Attacks
  2. Copy Cells
  3. Please respond: Need to create additional measure in pivot table
  4. Cell can only equal Whole Number
  5. formula to sort a range so that it matches the exact rows of a column that is outside that range?
  6. Macro to paste and print in another application
  7. Using the $ in a count formula
  8. Max
  9. Live stock prices from all over the world...
  10. how do i convert spreadsheets to html keeping the comments
  11. Where is Personal Macro Workbook?
  12. Problem in Conversion
  13. Emailing a worksheet
  14. next empty cell in a row
  15. adv filter
  16. Using Macro function in Excel
  17. Swap to another worksheet after given time
  18. Calculating a percentage with the end percentage in mind
  19. File Compare
  20. how can i change the colum width for cells on the same worksheet
  21. Can't access Office Online from Excel Application
  22. copying a formula
  23. excel bugs
  24. can i use the color of a cell to count the different colerd cells
  25. Rolling year
  26. This might be a little tricky......
  27. Sorting Data
  28. anchor comments to cell while inserting and deleting rows
  29. how do i show only the last four digits of a credit card number
  30. Increment a number in a cell for each page printed
  31. Please help - Looking for a way to sum up for specific error codes that occur in multiple months.
  32. ASCII files ...please help
  33. Freezing Worksheet Tabs
  34. Freezing worksheet tabs
  35. Formatting a cell based on another cells value
  36. IF Function
  37. Is it possible to change a Sheet reference in a formula?
  38. Date problem!
  39. How to auto insert rows in a list of numbers
  40. HELP!! It's STuck
  41. Excel merge mailing list template?
  42. Can I sum #s in a cell if other cells meet a certain criteria?
  43. How do i create multiple pivot tables with one field automatically
  44. SUMPRODUCT/COUNTIF
  45. Pivot tables and column data
  46. How do I turn on Auto Filter?? It is grayed out.
  47. Combo Box
  48. how do I integrate MapPoint into Excel?
  49. Running Access-to-Excel Automation....
  50. Referencnig a cell to select a value in a Pivot Table Pull-Down Me
  51. Formula Question
  52. Automatically separating worksheet into multiple pages
  53. How to stop Excel remembering/loading macro from previously opened Workbook
  54. Making special color effects in excel charts
  55. Selecting Various Values for One Source
  56. hyper links in pull down menus
  57. Excel Red X is grayed out & wont close application how do I fix
  58. How do I link custom headers to one page?
  59. How do I convert a Quattro Pro 7 file to an Excel 2003 file?
  60. Excell 2003 copy function properties
  61. I know this is easy but I don't remember how.
  62. Error: The text string you entered is too long.
  63. how do I remove data from cells ex. (232)-555-1212 to 2325551212
  64. 2 data types (same col/dif times), do: custom? parse? 2col?
  65. Subtracting
  66. Relative references
  67. How to right-click via keyboard in excel
  68. Incompatible "allow users to edit range" in earlier Excel versions
  69. What type of /program/database is Excel?
  70. Simple Checkbox Message Code
  71. Count number of times two columns have desired values
  72. Relative references
  73. AutoFilter report in status bar
  74. Can I Protect a cell range only?
  75. Saving Versions
  76. Relative references
  77. Storing a value to variable
  78. Offset and Matching
  79. setting for "original picture" size
  80. how to link a macro to a button on the excel sheet
  81. How to prevent file date change when no update made in Excel?
  82. IP Trimming
  83. Recording macros with autofill
  84. Lookup Value in Range/Array and Return Column Header Value
  85. formula on Witholding tax computation
  86. Disappearing text
  87. sum function
  88. Working with dates
  89. look for buttons in a macro
  90. variable date in XIRR function possible?
  91. Combo Box
  92. Need a excel template for job costing labor and insurance
  93. Need a excel template for job costing labor and insurance
  94. Pivot Tables
  95. New data automatically duplicates itself when file reopened.
  96. how do I set up in excel a calender to enter a date
  97. XLS Worksheet 'Select All' button + top 2 rows not in view in wind
  98. Macro Commands
  99. If, formula's and datastreams
  100. how do I custom format .0040 to show as 40 ?
  101. excel bug
  102. Average Function (include Blank Cells and Zeros)
  103. Speeding Up A Spreadsheet
  104. Conditoinal format trouble
  105. How to find next value if rows between are empty?
  106. import flash file in excel
  107. Delete Duplicate Rows Macro Question
  108. Listing all items only once
  109. Cannot modify Comments
  110. Re:Final days - London Excel Conference Registration giveaway
  111. Drop down menu
  112. R1C1 problems - Can't change
  113. Sequential dates.
  114. AAAARrrrrrrrrrrrrrrrrgggggggggggggghhhhhhhhhhhh Formulas
  115. Please help with Excel import
  116. The If function
  117. combo box from control toolbox
  118. Paste in "match destination format" macro code
  119. conditional format in look up
  120. change a cell background colour to my own RGB colour requirements
  121. Easy way to shade cells
  122. How to find the number of days from 2 dates?
  123. External Link error
  124. Cell references
  125. How can I set number values for letters (eg. B, A-) in Excel 2003
  126. using autofilter in excel and feature locks up
  127. Item order in ListBox
  128. Web Queries Excel 97
  129. opening xls files associated to excel viewer in ie
  130. no user-defined category
  131. How can I protect only format of the cell ?
  132. From List
  133. Excel Template
  134. Background
  135. Sorting by date
  136. How do you round up to nearest 10???
  137. Text does not display
  138. Multiplying by -1 and then copy/pasting
  139. Can I Select an "Import" Template Based on a Doc's Filename?
  140. VLOOKUP HELP
  141. Copying data different sheet
  142. Open file to specific tab
  143. FileSearch in a combo box
  144. filter rows with shaded cells
  145. Despite data existing in Excel 2002 spreadsheet Find doesn't find
  146. CSV file in excel
  147. can you please help
  148. spellcheck can not change back. changed language can't save work.
  149. Run Time error using AdvancedFilter
  150. Number Format
  151. Exporting spreadsheet data
  152. Calculating Time
  153. Pick up format from another cell
  154. Summation of columns of varying heights?
  155. Issues with white space when printing & with wrapping text
  156. Has anyone ever validated Excel or Word for Quality Records?
  157. How do i have one Drop down list reference another drop down list
  158. Deleting data in a list
  159. sumproduct vs. countif
  160. Can somebody help me with this! Please!!!
  161. How do I use base 256 numbers?
  162. Use the value in a cell in a formula in another cell
  163. Sort corrupts mass data intermittently?
  164. FORMULA FOR CALCULATING YEARS, DAYS, & MONTHS BETWEEN SEVERAL DATE
  165. How to delete a button
  166. How do I turn off "cannot load speech recognition ..." message?
  167. Saving Excel as a CSV
  168. Copied worksheet not working
  169. automatically paste values from a different file
  170. Combining formulas
  171. D:\program file\sprdprof\sprdprof.xla
  172. Help with pivot calculated fields?
  173. 12 month pivot table
  174. Extracting HTML from web based query?
  175. How do I set up imported data to stack info within a cell?
  176. How do I set up imported data to stack info within a cell?
  177. How do I set up imported data to stack info within a cell?
  178. How do I set up imported data to stack info within a cell?
  179. How do I set up imported data to stack info within a cell?
  180. How do I set up imported data to stack info within a cell?
  181. how to keyboard navigate to other cells during editing formula, when arrow keys don't work
  182. How do I hide text from printing?
  183. how to keyboard select cells for a formula if arrow keys don't wo
  184. Switching views - Hide / Unhide preselected cells (Repost)
  185. Using dropdown list to find file
  186. =IF($D6>=AprStart,$D6<=AprEnd)
  187. wrapping of very long text in EXCEL 2002 cells
  188. wrapping of very long text in EXCEL 2002 cells
  189. =IF($D6>=AprStart,$D6<=AprEnd)
  190. How do I change the defaults for Page Setup in Excel?
  191. Any body help me out with this?
  192. Printing Columns (not A,B,C order)
  193. why does data (such as 8-22) automatically convert to 22 Aug ?
  194. save to folder based on cell value
  195. How to get plus/minus box of data group at top, not bottom of grp
  196. Email distribution of certain cells, not an entire sheet/workbook
  197. font different than what prints out
  198. RE: How to get plus/minus box of data group at top, not bottom of grp
  199. Using Function (reposted)
  200. When i hide columns it hides whole sheet
  201. Getting a hyperlink to follow a sort
  202. Hide/Unhide Option - Need to consider all options!
  203. annual growth rate from monthly data
  204. Hope someone can help me
  205. color changing of cells
  206. Separating words in a single cell
  207. using a function
  208. Want to print only rows that have value in certain columns- Excel
  209. Find and replace
  210. How do I create conditional formatting?
  211. Pasting a formula in multiple cells without changing the range
  212. How do I print the names of my columns on each page? (Excel)
  213. Select data from cells
  214. text in a pivot table
  215. Pricing for Inventory
  216. How do I get my printer to print in consecutive order
  217. enable/disable macro
  218. How do I save spreadsheet to CD that gets flagged as Read Only?
  219. print jobs
  220. SUMPRODUCT QUESTION
  221. Stepping Through vs. Play
  222. Autosave workbook as unique file
  223. Copy and link formats from cell to cell
  224. PivotTable
  225. Charting Non-Numerical Data
  226. Dictate physical size of pictures inserting into Excel?
  227. Counting Rows
  228. Format option for decimal. e.g., entering 531 results in 5.31
  229. excel opens two copies of spreadsheets
  230. How do I hyperlink a value so it will show the value on another sh
  231. Can I set an automatic page breaks to break every 40 lines?
  232. Pivot tables connected to SSAS issues
  233. Moving all worksheets
  234. Making a dynamic list?!
  235. Save as CSV
  236. open and save an entire folder
  237. Browsing to Hyperlink location
  238. excel will not open a file with a double clik on a icon
  239. How do I set a date formula in the page setup header to add 10
  240. SQL
  241. cntrl+n wont work
  242. end down option in a textbox of a form
  243. Copy Page in 2007
  244. adjust row height of secured document
  245. formula
  246. =GETPIVOTDATA
  247. Using Autofilter
  248. how to get rid of hyperlinks when cutting and pasting e-mail addre
  249. Formatting
  250. calculating seconds in excel..please help