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 blank cells show data deleted months ago!
  2. Convert $12.25 to "twelve and 25/100 dollars" in Excel?
  3. Restructure text order
  4. Custom Format Cell
  5. use a range for a print header
  6. Excel Menus/Toolbars missing
  7. Excel asks to save an unchanged document. Why?
  8. Search and retrieve
  9. Userform for displaying values from a row
  10. Shared workbooks - copying worksheet
  11. Can I expand Excel workshhet beyond 65000 rows?
  12. How can I delete links (I can't locate) from one file to another?
  13. excel loads another workbook to run the macro...
  14. Process Priority
  15. ISBLANK returns flase when there is nothing in the cell referenced
  16. how do i remove the limit set on the worskheet i am working on
  17. Mirror columns or text
  18. connect to access database and run a query in excel VBA
  19. Formulas
  20. Exporting contact info to Outlook 2003
  21. Expenses Spread sheet Tutorial for Newbie ?
  22. Automate display/ hide rows in excel based on yes/no check box
  23. excel crashed before saving. Where is draft of file?
  24. Problems with date input
  25. Find/replace defaults
  26. Criteria for DCOUNTA for date values
  27. applying formula
  28. Custom Format Cell
  29. Excel, adding figures from one cell to a summary sheet or workbook
  30. Userform
  31. Dollar weighted rate of return with random cash flows
  32. Excel function button in spreadsheet
  33. Re: How do I format a cell for time (ex. 02:17 without AM or PM)?
  34. Excel Logic Statements
  35. Workbook_Open macro not running
  36. Text and dates into one cell without loosing date format
  37. Invoice that calculates total
  38. Lowercase text changed by Ecel to Uppercase after import
  39. Changing cell references in formulas to names and back again.
  40. simple average formula...can you solve it in principle?
  41. excel automatic numbering
  42. what excel opens with
  43. Dumb sorting question
  44. Subtotals
  45. Pasting Graphs - making me crazy!
  46. Cell contents don't display everything entered?
  47. Merge and Center when sheet is protected
  48. Capitalization of first word in a cell
  49. named arrays in other workbooks
  50. How do you embed an Outlook e-mail into Excel Spreadsheet?
  51. Can Excel automatically color highlight entire row of cell I'm in
  52. Represent blanks in an Excel IF statement?
  53. Pivot table layout
  54. fix for open/close files problem
  55. Retaining Excel colors when pasting into Word or PowerPoint
  56. Format of Cells
  57. Opening web links from an excel spreadsheet
  58. excel send to
  59. Either/Or in Conditional Formatting
  60. How do I fix row alignment when I print so it stays in grid lines
  61. 'Preview Pane'
  62. Can Excel access substrings and individual characters?
  63. Fix for open/save files problem
  64. Copy and paste
  65. characters in a cell
  66. Unwanted Zeros in Excel Chart Displayed Values
  67. Identifying a Selected Range in a Macro
  68. Office Assistant Switch
  69. fill series - I think!
  70. Combining two Subs
  71. auto numbering macro
  72. Re: How do I format a cell for time (ex. 02:17 without AM or PM)?
  73. Group Repeating Text Values in a Column?
  74. Excel problem
  75. Complete lock up in returning to Excel 2000
  76. Database function that sums?
  77. Intermittent Formula Issue
  78. Events won't Disable!
  79. Question about format of a formula
  80. Can excel macro access SUBstring individual 'char' level? If so how?
  81. Insert Options button doesn't disappear
  82. Can excel macro access SUBstring individual 'char' level? If so how?
  83. Summarising Information from other files
  84. Extracting the Duplicate Records
  85. Convert UDF from excel 2000 to excel 2003
  86. Summarising Information from other files
  87. Convert UDF from excel 2000 to excel 2003
  88. Summarising Information from other files
  89. Convert UDF from excel 2000 to excel 2003
  90. Getting an external file creation date as data
  91. Printing many columns but few rows
  92. Changing Behavior of the <Enter> Key?
  93. Size of font in headings
  94. changing cell values with text and currency
  95. Excel and Word will not open saved files
  96. One page Data Entry Sheet for Database?
  97. How do I bring Lotus123 files over in to Excel
  98. Pivot tables: SUM not COUNT!!!!!!!!
  99. searching and summing using string within cell
  100. Microsoft Query parameter - "is one of"
  101. Summing values b/t two dates
  102. '09:00AM trying to get remove the apostrophe
  103. Hyperlink without using control key
  104. Combine INDEX & LOOKUP?
  105. How to get 500 hyperlink address efficiently?
  106. Morefunc
  107. Sort a column of formulas
  108. VBA password protected modules
  109. Protected modules
  110. Range limit of CF
  111. Make Money From Google
  112. Fixed area above row 1
  113. Make Money From Google
  114. Fixed area above row 1
  115. Fixed area above row 1
  116. conditional format
  117. sumif function when left 4 texts are matching
  118. sumif function with partially matchin sentences
  119. Can Web Query retrieve a single HTML table cell?
  120. Custom Format syntax Q
  121. here's a doosey
  122. adding name values
  123. change autoshape by condition from a cell value
  124. Sepearting Numeric Data from Letters
  125. Compare two different spreadsheet
  126. Need to have cell C8 contain contents of Cell G(formula)
  127. Problems changing cell formatting
  128. Check Box
  129. equation editor 3.0
  130. Urgent Help
  131. Transpose? Offset? Variable starting cell
  132. Concatenate Unique Entries
  133. Formula Question
  134. Refreshing Pivot Tables linked to Oracle Datasource
  135. Arrangement problems.
  136. Arrangement problems.
  137. Unprotect a textbox in a protected worksheet
  138. Format text in cell from XY to X-Y
  139. How would I write a max formula that included color formats?
  140. Converting a date field into a month-year only field
  141. Excel 2000 suddenly stopped letting me enter data. Help?
  142. removing hidden fields from equation?
  143. Validation lists
  144. date that a row is modified
  145. Wizard Template - multiple cells
  146. Suggested new functionalities for Filters, Pivots and other issues
  147. Reset Macro
  148. Openning Excel Files takes too long
  149. Can't access excel files from worksheet
  150. How do I email an Excel spreadsheet to a Blackberry
  151. How do I unhide the formula bar?
  152. Slope of a Trend Line
  153. How do I maintain hyperlinks when converting from Excel to PDF?
  154. retrieve the data from web to excel
  155. relative cell reference in custom validation
  156. How to write this formula?
  157. omiting cells in average calcs
  158. Rank with condition
  159. how do I format data into columns using a pivot table report?
  160. Hyperlink
  161. Language Translation in Excel
  162. MS Word and Excel "save as" will not drill down
  163. problems with excel
  164. excel vba help plz
  165. Formula to govern Print Area
  166. Heights
  167. date formulas
  168. Passwords
  169. How do I set the default font for hyperlinks in Excel?
  170. Need Quick Macro Help!
  171. Urgent - Run-Time Error "450"
  172. Linking cell values
  173. How do I auto launch an excel file upon log in?
  174. headers
  175. Optimization question
  176. auto recover
  177. Task Pane Start Up
  178. Sending emails from Excel with Outlook Signature
  179. Check and Highlight!
  180. Add Refresh date
  181. inhibit input
  182. Application.Trim with VBA
  183. Repeat rows on bottom when printing in Excel
  184. =RATE(17,1,-5) returns #NUM! but the answer should be about 18.9
  185. Date Functions
  186. Compiling data from multiple worksheets into one worksheet
  187. Importing XML files into individual worksheets
  188. cell border colors in Excel
  189. macro question with example file....
  190. 3 pg excel wrksht,pg 2 prints formula answers,insert pic behind
  191. Can't get evenly spaced chart x-axis labels
  192. The Formula is displaying, not the result
  193. AutoFill down X number of rows.
  194. Size and Location of the MsgBox
  195. On Error GoTo skip needs help
  196. excel, word freeze when opening files
  197. a second x axis
  198. Question about columns
  199. Filter function; copy values to another sheet
  200. Inserting into Word
  201. Skipping rows with VBA
  202. program says "not responding"
  203. Help with a formula please.
  204. Printing a Spreadsheet with Black Background and Yellow Text
  205. Cursor moving slow in excel
  206. Strange Occurrence Copying Formula
  207. DPI and Format Cells window
  208. Daily production worksheet for manufacturing
  209. Printing Full File Name in Footer
  210. Dynamic directory path
  211. How do I change the case from all caps to proper for names I have in columns E, F, G?
  212. Date formula
  213. how tell if cell has formula
  214. How do I edit this macro?
  215. Compress big Excel file
  216. Import Email from Outlook into Worksheet
  217. Function to clear data
  218. What is the keyboard shortcut to insert a bullet in Excel 2003?
  219. Trivial question
  220. copy cell value not contents
  221. importing data
  222. Conditional Formatting a Linked Cell
  223. MAX value of a column that has #div/0 errors in it
  224. keeping info together
  225. Adding a date stamp to each cell in column - after the fact
  226. copying formula down
  227. How do I stop mouse from highlighting cells automatically
  228. clipboard pop up box
  229. hide comments automatically (can't find the setting)
  230. When trying to open an Excel workbook.....
  231. Save as locks up Excel
  232. replace "." with "/"
  233. Use cells from other documents..
  234. Format all worksheets for identical printing
  235. Excel does not displaying formatting correctly
  236. Is there a way to automate google searches into excel?
  237. Odd "Scripting" Icon in Excel cells
  238. Converting a date from nonsense to sense
  239. Why can't I write out an Excel file?
  240. Input Mask for Dates
  241. Input Mask for Dates
  242. Input Mask for Dates
  243. How do i insert of spacer rows between rows in large spreadsheets
  244. Easy way to convert multiple columns into one
  245. Pivot Table
  246. Can I use the Excel product icon image on my internal website?
  247. Date convertion
  248. Copying worksheets into one workbook... based on content
  249. Consolidate multiple spreadsheets into a single workbook
  250. Program carshes on opening a file