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. Pivot Table external XLS file source change and GETPIVOTDATA refresh
  2. Day of week for pre 1900 dates
  3. How to get 2 tables (one below the other) with different sizes?
  4. Excel Background Sharing Problem
  5. Excel toooo slow
  6. Does anyone know how I can seperate a post code in my data sheet?
  7. how to have two seperate data in one cell
  8. Set margins in Excel in centimeters.
  9. option to prevent Excel changing 1-2-3 to a date
  10. repeat a formula same column same number of rows apart
  11. Drop-down list problem
  12. Tools>AutoCorrect options...Where's this data file on my PC?
  13. Get distinct rows from different worksheets into another worksheet
  14. =SUMIF Problem
  15. search a column for a character..
  16. Cell Formula substitution.
  17. adjusting columns in multiple worksheets of workbook with one step
  18. Named range error
  19. How do I copy each row from 1 Worksheet to separate Worksheets?
  20. Averaging Time Difference
  21. How do I delete links to websites in Excel spreadsheet?
  22. Import data format, need help
  23. Excel 2007 Worksheet
  24. Is there a way that I can exclude a formula from being printed?
  25. Copied Cell
  26. Control Toolbox
  27. Makeing a Spreadsheet
  28. change font color in regular view to show on screen
  29. When I hit shift + left click highlighted object stuck.
  30. Merging from Excel to Word
  31. Move data Macro
  32. Number of characters in a cell
  33. Personal.xls
  34. calculating cells twice?
  35. Round to nearest 5000
  36. Sum up columns in different sheet with error check
  37. compile data
  38. Substitute text with assigned values
  39. Accounting format does not align decimals.
  40. Limit Digits entered into a cell
  41. Date format....
  42. printing cells with borders
  43. How do I fix . . remove formatting to avoid corruption . .
  44. Aligning Wraped Text to the bottom of a cell
  45. importing and exporting documents using word/excel
  46. Running total....
  47. Copy/Paste Macro
  48. matching 2 worksheets together
  49. import filtered data
  50. Excel, How do I get rows to adjust to cronological order of date
  51. Running Balances
  52. How do I add a 0 and 2 dashes to a truncated soc. sec.# in a cell
  53. Basic questions
  54. Automated Hyperlink format?
  55. Convert a column of numbers from positive to negative in Excel
  56. Conditional format based on other cells
  57. CONVER CSV CUSTOMER DATA TO A CUSTOM INDIVI CUSTOMER PRICE SHEET
  58. Question
  59. message: file cannot be deleted . . ..
  60. Links (multiple) to Imbedded W/S in adjacent cell
  61. Quick text to graphic converstion in excel
  62. Random Excel spreadsheets won't "Save As"
  63. excel check boxes moving when excel selected cells pasted in word
  64. Counting blank cells
  65. How do I put a check mark box in an excel document form?
  66. how to copy a trendline formula into an active cell ?
  67. putting symbols
  68. Sum on Select Criteria
  69. CD
  70. Text To Columns
  71. Zoom level
  72. Export Toolbar
  73. how do i set the default sort option to recognize a header
  74. Array of Strings
  75. Sorting problem
  76. There should be a swap function for 2 values
  77. How to enter Naira currency symbol
  78. I want to transfer a data base file into Excel then do mail merge
  79. Consolidating information from one sheet to a list on another
  80. Real hard one
  81. Second to last cell
  82. How do you print the "comments" in a cell of an excel spreadsheet?
  83. How can I place a table in ONE cell (ex A1)
  84. How can I get a moving Clip art o move in my Excel file???
  85. Problems saving a worksheet with links
  86. Changing the Column Headers back to letters from #s
  87. Text To Columns
  88. Excel 2007 (BETA) Missing data when doing pivot table
  89. Time formatting
  90. COUNTIF In The Row Below
  91. I can't see my Data
  92. Moving between cells
  93. In Excel-shade the cell automatically when data is entered
  94. Conditional Formatting/VBA
  95. Advanced Filter/ Extracting Data
  96. Is there an elegant solution to this table?
  97. ###### Wrong Formula
  98. Set Permanent Date Format to MM//DD/YYYY
  99. Missing Menu Bar When Starting Excel
  100. formula for populaing other cells
  101. If Function with Multiple Conditions
  102. Formula Help
  103. SUMPRODUCT
  104. Counting single instances in a column
  105. Enforce cell completion
  106. Referencing Cell Info to call a File
  107. Totaling sections within a list
  108. Excel 2007 - Custom menus is missing!
  109. CAN YOU SET GRAPH TO READ, FORMULA IN A CELL AS A BLANK CELL
  110. Excel(with hyperlinks) as a message body of outlook mail
  111. Bespoke drop down list
  112. After much help from this forum, I still some guidance...
  113. Using a lookup to return multiple values in one cell??
  114. Moving between worksheets
  115. interest rate mathematical formula
  116. How do I automatically count the number of cells highlighted
  117. How do I automatically count the number of cells highlighted
  118. Forcing value based on list choice??
  119. De-Duping
  120. Cell Format
  121. REFERENCING WORKSHEET CELL FROM VISUAL FOXPRO FORM
  122. See names of controls
  123. change default setting of accept labels in formulas
  124. Same Data source for Multiple Pivots
  125. How to return the default setting of numbering format in Excel?
  126. Allow pasting as a value to several discontinuous cells at once.
  127. Embedding operators, IF(x="up",>,<)IF..
  128. filtered pasting
  129. set XL formula to add mins to a time i.e add 45mins to 8am to get
  130. countif formula to find the occurances of a number that is greater than one number but less than another
  131. Problem with Date Picker control in Excel
  132. RE: How do I switch off automatic formatting (e.g. dates)?
  133. If statements
  134. Conditional formatting
  135. architectural data in excel
  136. Return true if multiple cells are the same
  137. Concatenate several dates and hide 1/00/00
  138. Excel : F2-F4 in multiple sheets should have independent result
  139. Excel: Cant copy an relative Cell and make absolute
  140. How to...
  141. Cells display function's text rather than its results
  142. how do i copy the same cell multiple times in excel.
  143. Beep Change The Sound
  144. Limiting size field MS query returns
  145. Print number larger than cell
  146. range of values
  147. Drop-down lists in vlookup
  148. How do I change the default location when Importing data?
  149. Trending data
  150. unable to change date format on imported data
  151. Please Help A Newbie - Running Totals
  152. Open CSV file in excel
  153. Ho do I make multiple line within a cell?
  154. printing of text box in excel 2007 beta
  155. Print in Excel displays "save as" screen and never prints.
  156. Lost Border Formatting
  157. Can I create a fill-in form on excel and then calculate the result
  158. Microsoft Excel 2003- Email hyperlinks
  159. Printing certain cells in excel.
  160. How to have a chart automatically adjust range as I add data entri
  161. Duplicate records with various formats for fields
  162. How do I omit content within a hidden row and copy only viewable r
  163. Query Items Listed During a Specific Time Period
  164. lookup function formatting
  165. Shifting Hyperlink
  166. how do i choose multiple options in a drop down menu in excel?
  167. lookup for criteria from either of 2 worksheets.
  168. HELP - keyboard locked in excel
  169. Conditional Formating Problem
  170. How can I Export data from to Access to an Excel Template
  171. Put Wingdings Characters in Toolbar button caption- IF POSSIBLE
  172. Macros - Force execution using workbook_open
  173. print a whole folder
  174. Perpelexing Row to Column conversion
  175. Conditional Formatting
  176. Updating links in multiple worksheets
  177. Excel Template
  178. Index/match question.
  179. Highlighting a cell in excel, how do I edit a pop-up window
  180. Text To Columns
  181. macro to print only pages that are filled in
  182. Office 2007 release date ?
  183. vlookup formula
  184. Can excel regognise asp environment?
  185. Sum values depending in values next column
  186. Is There a Formula that copies another cell exactly in Excel?
  187. Column Headings that are hidden
  188. Why are the Copy and Paste preferences in Excel not as good as Wor
  189. Copy & Paste with Subtotals
  190. Macro Makes List Box Selection
  191. splitting a number into two cells from one
  192. Question about Discussion Group
  193. Copy/Paste problems to Microsoft Word
  194. Excel Linking
  195. Excel file and path Footers
  196. Protected Workbook - Not a Good Idea!
  197. how do I send a spreadsheet so it's not a "read only"
  198. Hide items w/a 0 value in a chart?
  199. Not in the order
  200. Cells formatted as currency, need to sum just positives...
  201. Cannot empty clipboard"
  202. Running Macros
  203. PivotTable List
  204. template
  205. Count wrong
  206. How do I format Zip codes to print properly in a Mail merge?
  207. How do I copy and paste formulas between workbooks?
  208. Age Calculation
  209. Need to export to text results not formula
  210. Using variables . . .
  211. Disappearing toolbar icon
  212. .xls is locked for editing. Really strange.
  213. Help needed replacing multiple cells from a list of values.
  214. Excel vba to call Access Macro
  215. How do i allow users to insert hyperlinks into a protected sheet
  216. Macro to export as Text, only the results not the formula
  217. COUNTIF() with multiple criteria
  218. email
  219. Pagination across worksheets
  220. Printing a sheet onto 4 pages: page 2 is empty.
  221. Goto code
  222. Extracting rows based on fixed criteria
  223. Linked cells becoming inactive
  224. need to search a table such as distance table in road maps.
  225. if statement
  226. Exclude zero values using average function in a pivot table
  227. Referencing in formulas
  228. Another Userform question.
  229. Dates as Serial Values
  230. mathematical formula of rate
  231. Fractions
  232. Disabling SaveAs and Save?
  233. Deleting rows with specific values
  234. Detabulating Data
  235. Sum function based on Date recognition
  236. Formula not working when letter A is used in a named range
  237. Missing Drop Down list -Data Validation
  238. How do I get users to fill out excel spreadsheet sequentially
  239. Excel function to find difference of timestamps in milliseconds?
  240. Web Query Historical Stock Quotes
  241. How do I add values in the Legend?
  242. How to import multiple sheet of excel into Access database to a diffrent tables??
  243. Concatenate into 1 cell and drop down lines?
  244. How do i update multiple data ranges across multiple worksheets?
  245. no more lines??
  246. How to change cell text based on another selected cell?
  247. making a list
  248. How to format this number cell automatically
  249. Automatically define a list of words in Excel?
  250. Locking/Protecting Rows