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. If sum of an equation = 0, need to display blank cell
  2. Move File
  3. Excel journal or similar publication?
  4. Help Pls
  5. Working with "record-oriented" spreadsheets
  6. what is the vb code to copy rows from one sheet to another?
  7. macro if statements
  8. Removing blanks / sorting - common methods not applicable
  9. How can I save Excel am spreadsheet as pipe delimiter?
  10. Excel $ help!
  11. Cell Color
  12. Apply fomulas to additional worksheets as added
  13. Can I create a list from the results of a file search in Excel?
  14. Test a Hyperlink
  15. Macro that saves excel workbook as PDF??
  16. Excel columns are now numbered instead of lettered
  17. Excel2007Beta2: Selecting Range doesn't popup DesignTab
  18. Using RIGHT function in a VLOOKUP
  19. IF macro
  20. Exact Copy
  21. Obtaining & using last cell in a column in a cell formula
  22. Controling the Worksheet_Change Event?
  23. autofill with number embedded in text
  24. Microsoft Date and Time Picker
  25. Excel column sumif is incorrect
  26. numbers sum to a specific amount
  27. Sound+color alert if cell changed in another worksheet
  28. Excel spreadsheets with data, Powerpoint charts... and VBA!
  29. Excel Chart Question
  30. How do I insert the date modified in a spreadsheet footer?
  31. complicated if then formula...need help
  32. 2nd Post - Urgently need Help on VBA Procedure
  33. Display Date Modified
  34. Excel FormTrouble
  35. Excel weird behavior
  36. How to find and replace in Excel for special characters?
  37. CELL NAME (A, B, C,) CHANGED SIZE
  38. Drop down list as part of a file name selector
  39. Excel Template with functions
  40. Sum Array
  41. Autofit with Merged Cells/Wrap Text Macro Problem
  42. Formatting
  43. How can I remove values under a certain value from a table?
  44. cells don't upate
  45. 2nd Posting - Need Help on VBA Procedure
  46. Adding rows in several worksheets along with formulas
  47. Data Validation
  48. Pretty Buttons...
  49. Pivot Tables lost link
  50. How to use Calender control as date chooser in excel??
  51. How do I display zeros in excel if they are the beginning characte
  52. delete entirerow if date more than 12months old
  53. Abstracting text
  54. Changing the code on an external link.
  55. Lookup and list
  56. Text file saving, setting file origin
  57. how do i update the date on a 2005 calendar template
  58. Why does caps lock automatically turn on?
  59. What is the maximum file size Excel can save?
  60. Transpose data
  61. Excel Save As issues
  62. Help with formula?
  63. Urgent help on VBA Procedure
  64. People seeking help lack competency. Your HELP unhelpful
  65. I think Linking
  66. Excel If/and
  67. Turn Off Hyperlinks?
  68. Complicated extraction of text
  69. Here we go again....
  70. calculating time with tenths
  71. page number shows in background
  72. Filtering Using Variables
  73. Auto Calculate
  74. Omitting A Row From Autofilter
  75. Round function in If statement
  76. change format of cells (bold, italic) based on one cell's answer
  77. Displaying negative numbers - inconsistent between desktop and lap
  78. Unwanted Rounding
  79. I'm Stumped
  80. How can I use SumProduct with a horizonontal and vertical array?
  81. Files open only when excel already open
  82. How do I insert a filtered subtotal into overall summary
  83. Huge increase in file size
  84. VLookup query
  85. make row height automatic
  86. Excel same Formula in different columns-calculate columnwise?
  87. SUMIF/SUMPRODUCT/IF - 2 criteria - Date and Text
  88. Challenge experts will LOVE!!, Can you get the formula??
  89. Cannot Open Webpage With Excel 2003
  90. how i can take file from adobe reader and make it read with micr.
  91. Converting a decimal number into time
  92. Excel should allow all open worksheets to close at once
  93. RANDBETWEEN funtion is missing from my new Excel.
  94. When I copy cells in Excel they go to my printer. How can i stop .
  95. Help with Default Excel file and template
  96. How do I select same day of month, 3 mths apart when day 31 of mth
  97. How to paste objects in a protected sheet
  98. Excel 2003 Formula
  99. Macro hanging up on 2nd use and later.
  100. how can I use eudora to send email from excel?
  101. Division Sign
  102. trouble ranking data...
  103. Change RADIX within Excel cell
  104. Want to view excel files in separate windows
  105. Transfer Macro code to another computer
  106. Pie Chart Labels
  107. Formulas do not recognize numbers
  108. test
  109. Counting days in month
  110. negative numbers as a zero
  111. Can I toggle between files easily
  112. XL 2003 & Sumproduct Question
  113. Performance not upto Office 2003 standards in Office 2007
  114. Resizing cells
  115. making columns flow down the page
  116. making columns flow down the page
  117. Ctrl + Home stopped working
  118. How do I create a crossover for old to new products,w/ explanatio
  119. Averaging percentages
  120. Zeros
  121. Is this possible?
  122. Can I wrap a row onto one page in Excel when printing?
  123. Help! - Lost function in Find & Replace!
  124. summing a volitile number of cells
  125. Cell size
  126. COUNTIF with non-zero format?
  127. Excel charts
  128. sort last names by in alphabetical order
  129. Lost formatting after special paste...
  130. Locking rows in Excel 97
  131. Slow Save
  132. Data Source for MS Query
  133. Easy Printer Switch Question
  134. Excel file
  135. Can't edit in cell anymore
  136. problems with dates
  137. Importing list from Word to Excel
  138. how do i open a file on my documents
  139. Problems with Excel 2003 - Dashboards
  140. Lookup question
  141. How do you link Check Boxes?
  142. Hours to minutes
  143. excel open in outlook if outlook is running
  144. out of limit data
  145. VBA : adding and removing text within cells
  146. How do i calculate standardised mortality ratios using Excel?
  147. too many rows in csv file
  148. Formula for Mileage from Latitude and Longitude
  149. URGENT: Please Advise. SumProduct and Operand Question
  150. Month & year question
  151. DaVinchi Code
  152. How do I create a separate radio button set in the same sheet?
  153. formula using multiple ranges
  154. How to rename references from range names to cell references
  155. Duplicate Range Names by worksheet
  156. Formula for changing all caps to lower case
  157. Excel VBA Help Files (*.chm) and Location
  158. Display number of day of month depending on the year
  159. sumproduct - reading a variable value
  160. Trace Dependents
  161. Lists
  162. auto format problems
  163. Date Reference Oddity
  164. Formula to Remove Weekend Days
  165. Formulas not Updating
  166. Date calculations
  167. Pivot Report - Remove 'Sum of'
  168. I want to change Exc Doc-save-e-mail, can receiving end trk chngs
  169. Pop Up Calendar
  170. How to hyperlink in document so reference remains valid after a so
  171. formula's turn to results
  172. Conditional formatting - range of dates
  173. Conditional formatting - range of dates
  174. Worksheet Events
  175. How do you sort copied from internet data in Excel?
  176. Cannot paste
  177. weird> no more cell fill and text colour
  178. Validation
  179. how do i extract data from pivot table to txt file
  180. Merging of multipul data into single enteries.
  181. Run a Batch file with variables
  182. Dynamic Range with Function "AND"
  183. Excel '00, 1st file has macros, how to stop macro in 2nd file?
  184. Rounding and Ceilings
  185. Row Heights Incorrect Sizes
  186. I am making MIS tracker
  187. How do I create a counter?
  188. Move Word form to Excel
  189. Ranking a List which must be within GROUPS
  190. More than 65,000 days.
  191. funcao
  192. multiple item entries from drop-down list
  193. Userform and variables
  194. How do I generate Errors for Drop-Down Lists?
  195. Flashes
  196. preventing copying
  197. URGENT: Excel link to webpage and back
  198. Pivot Table Source Data
  199. Flashes
  200. Tools in excell,word & access not highlighted
  201. Replace dialog should put focus on "Find What" not "Replace With"
  202. Digits to character...!!!
  203. Text and Numerical data in a Pivottable without summarising?
  204. WANT AMOUNT IN C6-C100 TO = C3(550)
  205. How do I make Excel column headers alphabetical...
  206. Indirect.ext #value!
  207. Solution to stopping IE opening excel workbooks without changing windows settings
  208. Merging errors
  209. VBA - Not Excel
  210. EXCEL FILTERING
  211. How do I enable insert copied cells (option not available in menu.
  212. How do I enable 'insert copied cells' (option not available in men
  213. Changing row content with single cell click
  214. Suggestions for the Next Release
  215. Linking vs Data Consolidation Help!!
  216. ALT +Enter not working?
  217. what is the formula for adding up time intervals?
  218. How do I find Top Spenders?
  219. Formatting numbers
  220. Excel Worksheet
  221. Help with VBA
  222. All 0's for Sums in Pivot Table
  223. Pivot Table Question
  224. Hiding cursor
  225. macro to clear cells
  226. Formulas
  227. I need the equivalent of a "averageif" formula...
  228. Excel edit problem, (of my own making!!)
  229. if you've accidentally saved a huge spreadsheet as a web doc...
  230. If statement to test font color
  231. Pivot Tables and blanks
  232. Excel lookup macro
  233. Can't get Grand Totals (rows) to appear
  234. I can't delete a cell without deleting a row
  235. Help with Excel Formulas or Functions
  236. Can I change column width for remainder but NOT previous text?
  237. Use Named Range instead?
  238. GFET RID OF FUNCTION
  239. Formula
  240. Not Printing the information in cells
  241. add delta symbol to toolbars in word and excel
  242. Permanently-sorted lists?
  243. Can I display various Graphic Files based on Condition?
  244. How do I print a spreadsheet with multiple worksheets?
  245. Choose filename to go in a cell
  246. Concatenate
  247. ALT+ENTER = line break
  248. Find & Replace text format
  249. SumIF full columns, multiple conditions
  250. find largest values, then return corresponding row values.