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. msgbox
  2. VLOOKUP
  3. insert a new row between exsisting rows on entire worksheet
  4. Validation - Custom
  5. If Statements Question
  6. how to interchange positive to negative value in excel
  7. Excel & Access Import Problems
  8. How can I create a master spreadsheet from different workbooks
  9. calender as a drop down list option in excel
  10. resetting excel to default values
  11. Lookup table
  12. pivot layout
  13. Formula for this?
  14. if statement for summing cells
  15. =?Utf-8?Q?Stop_=28C=29_becoming_=C2=A9?=
  16. Delete empty rows with cell type 2
  17. Printing multiple worksheets.
  18. adding only working days to dates
  19. Best 4 scores
  20. Calculating Number of days from one date to another
  21. I need to figure out how to get this =(DAY(TODAY())*2) to stop calcul. at end of mnth
  22. Macro Run-time error
  23. Count Difference between two dates
  24. how to I disable text import wizard?
  25. How to place a secondary y axis bar in a bar chart next to two primary y axis bars?
  26. Enter a value dependant on the colour of a cell
  27. WEEKDAY question on year
  28. Cell address in a range
  29. easy way to change a formula
  30. Excel 2000 with macros slows to write to W2k3/XP disk or shares
  31. making a cell zero out after calculation
  32. print screening from excel and then pasting it into word
  33. Voting results in Excel
  34. cannot wrap text after 1245 characters
  35. Stop opening a blank worksheet
  36. Change drop-down list font
  37. activate opened workbook via VBA
  38. Set up excel page size
  39. Date format (reposted)
  40. Data import problem
  41. Excel formulas
  42. Insertion of formulas in foreign language in english version of ex
  43. adding in exel
  44. Merging multiple WS with diff values into one master
  45. More than 1 countif criteria
  46. once more - - -
  47. Insert Function?
  48. How to add CellPhone minutes from a bill to a sheet like 603:57?
  49. Sharing Workbook
  50. Field Select in a Pivot Table
  51. Using Countif to Count Consecutive Relative Increases in Numbers
  52. Modify cell contents
  53. frequency
  54. All of contents in cell don't link
  55. OR Function (MAYBE)
  56. Car loan payment calculations
  57. what does $ mean before a number in a formula
  58. Damaged files
  59. changing cell values
  60. Extracting numbers from a cell with carriage returns
  61. How do I set up XML on Data menue?
  62. Formatting cells
  63. How do I use excel information for a second excel worksheet
  64. remove gridlines
  65. Formula Help
  66. Multiple worksheets as the source for a pivot table
  67. Exporting a PDF file
  68. sorting question
  69. Connecting Worksheets
  70. Embedded Object Flickering
  71. questins
  72. Trigonometry & Math functiona in Excel
  73. match number in a string of numbers
  74. Fun with Macros!
  75. Writing Fast VBA UDFs - London july19/20
  76. Advanced Filter for Values in Column M greater than Values in Colu
  77. Data Validation Lists
  78. Replace hyperlink throughout excel
  79. Auto Number in Excel
  80. Edate function Name error
  81. Copy and Paste Special (Formulas) pastes cell value if numeric
  82. =SUM(Sheet2:Sheet9!IV65536)-meaning of equation?
  83. Combine the data in 2 columns of 20 rows into one column of 40 row
  84. link to Lotus Database from Excel
  85. Please Help!!!!!!!!
  86. "Cleaning Up" Spreadsheet
  87. formula forPercenteage
  88. Finding a Problem Link in Excel
  89. Tracking Change in Excel
  90. Deselect All in a Pivot Table
  91. Change Smith, John to John Smith
  92. Refresh multiple pivot tables
  93. how to extract unique numbers once from a list of repeated numbers?
  94. Unopened workbook
  95. Worksheet protection is gone and only wokbook protection can be se
  96. File saves as XML back to XLS?
  97. deleting rows
  98. how to add a special subtotal in the pivot table?
  99. I type NWO and it becomes NOW How can I keep NWO from changing?
  100. Unable to install KB905756
  101. Open an XML file into Excel
  102. Lists From Another Worksheet
  103. Using "Enter" to click on a hyperlink
  104. Help!!!
  105. Lookup
  106. what is that little box (with a number in it) within the cell?
  107. VB Help WORD/EXCEL LINK
  108. Dragging Groups of Numbers
  109. Formula won't calculate...
  110. Parse cell contents ?
  111. First day of month
  112. How to make (XL) Merge Cells and Word Wrap work concurrently?
  113. Pulling a Summary List from a Larger List
  114. Joined Combo Boxes
  115. Dates
  116. Moving Four Rows at a Time
  117. graph formatting question
  118. Using the Cell descriptor in the formula
  119. Excel cell reference.
  120. Formulas referencing a spaces instead of number ?
  121. sorting question
  122. sorting question
  123. sorting question
  124. sorting question
  125. ff
  126. Indirect cell references ????
  127. Form Causes Out of Memory
  128. PivotTable Question
  129. Updating data...
  130. Converting to minutes and seconds
  131. Dropdown Menu
  132. Excel file corruption when opened with Word?
  133. Static formula when inserting new rows/columns?
  134. column copying and saving
  135. OLAP TABLES
  136. How to use bullets & numbering within a cell ?
  137. highlighing data which matches an SQL query
  138. Problem created by sorting linked sheet
  139. cell by cell transpose
  140. Subtotal without "xxxx total" but only xxxx
  141. 'Compare side by side' for work sheets
  142. How do I reference the comments of a cell?
  143. Edit Built in Footer
  144. leading zero not displaying
  145. Hi all need some help in excel transpose
  146. How to return a specific data point from a large array if I don't know the exact location?
  147. Summing non hidden values in a range
  148. making a cell zero out after calculation
  149. Data Validation
  150. Connection error
  151. formula to find the data of a next cell in a list
  152. I get #DIV/0!
  153. Converting date format
  154. Lookup formula?
  155. how do i prevent my tab key from jumping 10 columns vs. 1?
  156. Text message using data validation.
  157. Blank Window in Word and Excel Help
  158. data validation and formatting
  159. time difference
  160. Deleting duplicate rows
  161. How to blank out cells with duplicate values?
  162. Rounding numbers up or down
  163. Can't Edit Contents of Protected Worksheet
  164. I am trying to change Smith, John to John Smith
  165. Text in formula bar but not the cell
  166. How do I enable auto-expanding lists in a protected worksheet?
  167. How do you adjust the maximum characters in a excel header?
  168. Can't toggle (or display) formula bar
  169. Autocreate folders
  170. MULTIPLE CONDITIONS FORMULA
  171. In Excel, how can I convert h:mn to mn?
  172. 2 different INDIRECT data validation lists from one
  173. Sharing an Excel file NOT on a network?
  174. Automation of Averages (X-posted)
  175. Conditional Sum
  176. Import Issue
  177. Print IF return "OK" or "NOT OK" in different colors
  178. Testing Spreadsheet Cells while in a Macro
  179. Sorting IP Addresses in Excel?
  180. Excel Conditional Sum
  181. Any way to autofilter at seperate points on the same sheet?
  182. excel 2003 accessing hard drive and freezing
  183. Find and Replace in the Comment Field
  184. getting cells to shift to next column
  185. cell format: numbers won't be numbers
  186. If with automatic hyperlink
  187. data validation--multiple dependent list
  188. IF Statements
  189. delivering excel spreadsheets to mobile devices
  190. How do I recover an Excel file I accidentally deleted?
  191. problem not solved... CONT.IF depending on the text color
  192. How 2 create an Excel Form using & linking items on Forms Toolbar
  193. check box in excel
  194. Odd "circular refference" error
  195. autofilters lock up
  196. Removing unwanted data in a column
  197. weeknum formatting
  198. hOW DO i COPY FORMULAS FROM ONE SPREADSHEET TO ANOTHER IN EXCEL
  199. Copy String to the Right of "hyphen"
  200. How do I get numbers converted to cost?
  201. how can I set up an alphabetic sequence?
  202. cannot open encrypted file
  203. VLOOKUP
  204. can you copy and paste row height formatting in excel
  205. Another Zero problem...
  206. rearrange data
  207. weighted average
  208. HELP! Excel Thermometer Charts
  209. copying a cell
  210. CONT.IF and color condition?
  211. HOW DO I REMOVE THE GHOST ON DRAWING LINES in excel ?
  212. lookup help
  213. Subtract # of days from date, but if not sat, goto previous sat?
  214. tracking changes via email
  215. look up names in one excel tab to find a match in another tab
  216. Tricky counting question
  217. populated
  218. Sendto
  219. Enter numeric as text in Excel worksheet should not create error
  220. Pasting Formulas
  221. transfer info from one sheet to another?
  222. Excel 2003 loses the links to other excel spreadsheets on a server
  223. baseball Statistics spreadsheet
  224. counting button
  225. Remove BOM from UTF-8 file
  226. Multiple Files & Tabs Printing Options
  227. Ahhhhh...Help!
  228. "Save As" disabled
  229. UK Excel User Conference - July 19-21
  230. how can I open a file if its needs decoding with BINHEX4
  231. Keyboard problems
  232. CAPITALIZED ALL WORDS FROM WROKSHEET
  233. Loosing value of large number when saving file to CSV format
  234. how to compare multiple lists of data in excel
  235. On going "Component installation"
  236. Arrow keys to move cell
  237. Select data from 1st of up to 6 columns & Xfering to other workshe
  238. Customize Supercsript, e.g. word Centigrade to be oC, o superscri
  239. Conditional formula?
  240. How to link to an Excel file when sending an email in Outlook?
  241. why can't you right click then paste inside screentip box?
  242. Takes too long for Filedialog to change directory
  243. Buttons
  244. Price Lists
  245. Repeat alert, "No more new fonts may be applied to this workbook"
  246. Parse csv files
  247. Help!
  248. Return a price based on a customer from a drop down list
  249. How do I get new excel docs to work on old excel prog.?
  250. TROUBLE OPENING OLD WORKBOOK VERSION