1. A BETTER VIEW 8
2. A DYNAMIC SUM 9
3. A KEYBOARD SHORTCUT FOR CLOSING FORMS 11
4. A list box with a dynamic named range 11
5. A LITTLE TO THE RIGHT 12
6. A one-step formula for multiplying and adding 12
7. A perfect fit 12
8. A QUICK DATE 13
9. A RETURN TO BASICS 13
10. A SHARPER ANGLE 14
11. A SHORTCUT FOR UNDOING YOUR LAST ACTION 14
12. A TRAIL OF BREADCRUMBS 14
13. A variable with a good memory 15
14. ABOUT N() 15
15. ACTIVEX HELP 15
16. ACTIVEX LEGALITIES 16
17. Add graphics to your bar charts 16
18. Add it up in a flash 16
19. Add up values in a filtered list 17
20. ADDING AN ITEM TO A LIST BOX 17
21. ADDING BLANK LINES TO LISTS 18
22. ADDING ITEMS TO LISTS 18
23. ADDING LINE NUMBERS TO CODE 18
24. ADDING MULTIPLE CONTROLS THE EASY WAY 19
25. ADDING TIME 19
26. ADJUSTING CONTROLS 20
27. Adjusting reality 20
28. ALIGNING CONTROLS 20
29. ALL LINED UP IN A ROW 21
30. All numbers, large and small 21
31. ALTERNATE FORMATS 21
32. AN ALTERNATIVE TO CELL COMMENTS 22
33. AN EASY DELETE 22
34. AN EASY JULIAN DATE 22
35. AN EASY PRINT TASK 23
36. ANNOYING LINKS 23
37. ANOTHER AUTOMATIC SAVE ADD-IN 23
38. Are we connecting? 24
39. Ask users for their input 24
40. AT THE CENTER OF IT ALL 24
41. Audit yourself with these tools 25
42. AUTOMATIC ARRAY 25
43. Automatically extend formats and formulas 25
44. AUTOSUM FROM THE KEYBOARD 26
45. AVOID ERROR WHEN DELETING RANGES 26
46. Avoid overflow errors 26
47. Be explicit with your options 27
48. Break up the text in a MsgBox 27
49. Breaking the lines 28
50. BREAKING THE LINK 28
51. Calculate loan payments 28
52. CALCULATING BINARY 29
53. CALCULATING FORMULAS 29
54. Call it by name 30
55. CAN'T UNDO 30
56. CAN'T PRINT? 31
57. CHANGE THE WIDTH OF TOOLBAR CONTROLS 31
58. CHANGE YOUR DEFAULT BUTTON 31
59. CHANGING A CHART'S DEFAULT SCALE VALUES 32
60. CHANGING DEFAULT FORMATS 32
61. Check the type of the selection 33
62. Checking if your add-ins are added 33
63. CIRCLE THIS! 33
64. CLEARING A RANGE 34
65. CLICK EVENT ORDER 34
66. CLIPART 34
67. COLOR CONSTANTS 34
68. Color-coordinate your worksheets 35
69. COLUMNS AND AUTOFILTER 35
70. Combine many worksheets into a single workbook 36
71. COMBINING CELLS 36
72. CONCATENATING DATES 36
73. Control the form and position of AutoShapes 37
74. Control the status bar 37
75. CONVERSION ISSUE 38
76. Convert formulas to values in the blink of an eye 38
77. Convert formulas to values 38
78. Converting degrees to radians 39
79. CONVERTING DRAG-AND-DROP DATA 39
80. CONVERTING DRAG-AND-DROP DATA 39
81. CONVERTING LABELS TO NUMBERS 40
82. Copy a list of unique values 40
83. COPY CAT 40
84. COPYING TO OTHER WORKSHEETS 41
85. COPYING VALIDATION RULES 41
86. Count with two criteria 41
87. Counting items in an Excel list 42
88. Create an easy bar chart with the REPT function 44
89. Create your own add-ins 45
90. Create your own functions 45
91. CREATING A MACRO BUTTON 46
92. CREATING A UNIQUE LIST 46
93. Creating hyperlinks in a worksheet 47
94. CUSTOM MENUS 47
95. Customizing error messages 47
96. CUSTOMIZING YOUR DICTIONARY 48
97. DATA ENTRY MADE EASY 48
98. DATA ENTRY RELIEF 48
99. DATA FORMS WON'T UNDO 48
100. Database totaling with DSUM 49
101. DATEDIFF BEHAVIOR 49
102. DEBUGGING SAFETY 49
103. DELETING A SPLIT SCREEN 50
104. DEVELOPER TOOLS 50
105. DISPLAY FILE NAME IN SHEET FOOTER OR HEADER 50
106. DISPLAYING COMMENTS 51
107. DISPLAYING LARGE BUTTONS 51
108. DISPLAYING MULTIPLE SHEETS 52
109. Do you feel lucky? 52
110. Do you have a secret? 52
111. Do you have the time? 53
112. Do you have too many windows open? 53
113. DOCKING WINDOWS 53
114. Don't be so negative 54
115. DOUBLE-CLICK'S A BUST 55
116. DOWNLOAD UTILITIES 55
117. EASY ABSOLUTE REFERENCES 55
118. EASY CHART UPDATE 55
119. EASY COUNTING EXPRESSION 56
120. EASY LINK 56
121. EASY SELECTION METHODS 56
122. EDITING A HYPERLINK 57
123. EDITING THE OFFICE 2000 DICTIONARY 57
124. E-MAILING EXCEL DATA 57
125. EMBEDDED CHART TITLES 57
126. Enter sums at toolbar speed 58
127. ENTERING A CARRIAGE RETURN 58
128. ENTERING FIXED DECIMAL VALUES 58
129. Event handling procedures 58
130. EXCEL AND ARRAYS 59
131. EXCLUDE HIDDEN CELLS FROM COPY 59
132. EXCLUDE HIDDEN CELLS 59
133. Execute a menu using VBA 60
134. EXTRA HELP WHEN EXITING 60
135. FASTER UPDATE 61
136. FEELING LOST 61
137. Fill in the blanks 61
138. FINANCIAL TEMPLATES 62
139. Find out which printer you're using 62
140. Find repetitive values in a list 63
141. Find the last used cell 63
142. FIRST THING EVERY MORNING! 64
143. FOREIGN FORMATS 64
144. FORMATTING ERROR MESSAGES 64
145. FORMULA HELP 64
146. GENERIC ERROR MESSAGE 65
147. Get personal with macros 65
148. Get to know Julian dates 65
149. Get updated on the latest trends 66
150. Getting over your fear of Excel's database functions 66
151. GLOBALS LOSE VALUE 68
152. Go through the backdoor 69
153. Go where you want to go 69
154. Graphics in the header or footer 69
155. GREAT POINTERS 70
156. HELP IS JUST A KEYSTROKE AWAY 70
157. HIDDEN RESOURCE 70
158. HIDE 'N' SEEK WITH OBJECTS 71
159. HIDING A WORKBOOK 71
160. HIDING A WORKSHEET 71
161. HIDING AND UNHIDING COLUMNS AND ROWS 72
162. HIDING DATA 72
163. HIDING ROW AND COLUMN HEADERS 73
164. HIRING A NEW ASSISTANT 73
165. HOW BIG IS THAT FONT? 73
166. HOW BIG IS THAT FONT? 74
167. How many is too many? The elusive many-to-many relationship 74
168. How to teach charting in Excel in 15 minutes 74
169. HTML PASTE OPTION 77
170. HYPERLINK SHORTCUT 77
171. I CHANGED MY MIND 77
172. IDENTIFYING MARGINS IN PRINT PREVIEW 77
173. Immediate calculations in the formula bar 78
174. IMPLICITLY TRUE 78
175. IMPORT ACCESS DATA 79
176. IMPORTING A CUSTOM LIST 79
177. IMPORTING FOREIGN DATA 80
178. IMPORTING STRAIGHT TEXT 80
179. INCREASE AND DECREASE DECIMALS 80
180. INHIBITING VLOOKUP'S BEST CHOICE 80
181. INSERTING A PAGE BREAK 81
182. INSERTING EVERY OTHER ROW 81
183. INSERTING MULTIPLE SHEETS 82
184. INSERTING ROWS AND COLUMNS 82
185. INSTALLING ASSISTANTS 82
186. IS THAT MY TOOLBAR 83
187. Keep a running total 83
188. Keep it in the background 84
189. Keep your tools in reach 84
190. Keep your users from printing workbooks 84
191. LABELED CELL 85
192. Lessons in hyperlinking 85
193. LINK TEXT BOX TO CELL 86
194. Link up your cells 86
195. Locate hard-to-find objects 87
196. LOCK THE FORMAT PAINTER 87
197. Look both ways 87
198. MAINTAIN AN AUDIT TRAIL 88
199. Make a carbon copy 88
200. Make a choice 88
201. Make changes to a report "on the fly" 89
202. Make sure that macros are enabled 89
203. Make your charts modifiable 90
204. Make your column widths consistent 91
205. Making VLOOKUP look down 91
206. MAPS AREN'T JUST FOR SISSIES 92
207. Metrics made easy 92
208. 3D QUICK CHANGE 92
209. ALTERNATIVE TO AUTOSUM 93
210. ARGUMENT LIMITS 93
211. ARRANGING WINDOWS 93
212. AUTOMATIC DATE FORMAT 94
213. CELL SELECTION FROM SHEET TO SHEET 94
214. CELLS THAT PASS IN THE NIGHT 94
215. CLOSING THE ACTIVE WINDOW 94
216. COPY PRINT SETTINGS 95
217. CURRENCY FORMATS 95
218. DATA ENTRY EASE--PART 1 OF 2 95
219. DATA ENTRY EASE--PART 2 OF 2 96
220. DETECT AND REPAIR 96
221. DIM ADVICE 97
222. DIM WARNING 97
223. DISGUISE THE #DIV/0 ERROR 97
224. DISPLAYING LONG VALUES 98
225. DOWNLOADING DATA FASTER 98
226. EDITING DATA POINT LABELS 98
227. ELIMINATING A FILTER 99
228. ENTERING FRACTIONS 99
229. EVERYTHING YOU EVER WANTED TO KNOW ABOUT CELL REFERENCES 99
230. FILTERING DATA 100
231. FIND GROUPS 100
232. JUST A LITTLE HELP 100
233. LIMITING PRINT PREVIEW 101
234. LOOKING FOR CODE 101
235. MAKE IT FIT 101
236. MORE ON DATA POINT LABELS 102
237. MORE ON PRINT AREAS 102
238. MULTIPLE WINDOWS 102
239. ONE MORE ON FILTERING 103
240. OPEN FROM THE KEYBOARD 103
241. OPEN OPTIONS 103
242. OPEN WORKBOOKS FROM THE VBE 104
243. PERCENT OPERATOR 104
244. PRINTING CHARTS 104
245. QUICK FORMATS FROM THE KEYBOARD 104
246. QUICK MODULE LAUNCH 105
247. QUICKLY ASSIGN GENERAL FORMAT 105
248. SMALLER IMAGES 105
249. SORTING BY THE DAY OF THE WEEK 105
250. SPLITTING THE SCREEN 106
251. STYLE TIMESAVER 106
252. TURNING OFF SCREENTIPS 106
253. TURNING OFF TASKBAR OBJECT DISPLAY 107
254. UNHIDING MULTIPLE COLUMNS OR ROWS 107
255. USE MID() TO PARSE 107
256. VIRUS HELP 108
257. WATCH THOSE PAGE BREAKS 108
258. WEB AS SHEET 109
259. WHEN NUMBERS COUNT 109
260. MINIMIZING OLE REFERENCES 109
261. MISSING ARGUMENTS 110
262. Modify your toolbars 110
263. MORE INFORMATION FOR ERROR MESSAGES 111
264. MORE ON AUTOFORMAT 111
265. MORE ON DATA ENTRY RELIEF 111
266. MORE ON FINDING YOUR WAY 112
267. MORE ON GREENBAR 112
268. MORE ON HEADERS AND FOOTERS 112
269. MORE ON PASTE SPECIAL 113
270. MORE ON PRINTING 113
271. MORE ON THE FIXED DECIMAL 113
272. MORE ON THE FORMULA PALETTE 114
273. MOVING AFTER ENTER 114
274. MOVING BUTTONS 114
275. MOVING PAGE BREAKS 114
276. MOVING TO THE LAST CELL 115
277. A BETTER VIEW 115
278. A DYNAMIC SUM 115
279. A KEYBOARD SHORTCUT FOR CLOSING FORMS 116
280. A list box with a dynamic named range 116
281. A LITTLE TO THE RIGHT 117
282. A perfect fit 117
283. A QUICK DATE 117
284. A RETURN TO BASICS 118
285. A SHARPER ANGLE 118
286. A variable with a good memory 119
287. MSDN FAVORITES 119
288. MULTIPLE CASE EXPRESSIONS 120
289. MULTIPLE FILL 120
290. MY ANALYSIS TOOLPAK ISN'T INSTALLED 120
291. MY, WHAT BIG WORKSHEETS YOU HAVE 121
292. NAMED CELLS IN FORMULA 121
293. NAME VERSUS CAPTION 121
294. NAMING RULES 122
295. Navigate between many sheets 122
296. NEED A CALCULATOR? 122
297. NEED A PREVIEW 123
298. NEED THE RESULTS WITHOUT THE HASSLE 123
299. NESTING FUNCTIONS 123
300. NONCONTIGUOUS RANGE 124
301. NONCONTIGUOUS RANGES 124
302. Nothing to worry about 124
303. NOW IT'S TEXT, NOW IT'S NOT! 125
304. OFFICE 2000 TOOLS AND UTILITIES 125
305. OFFICE ERROR MESSAGES 125
306. On these conditions 126
307. ONE CLICK OPENS THE VISUAL BASIC EDITOR 126
308. ONE DAY IS THE SAME AS ANOTHER 127
309. ONE MORE ON PRINT AREAS 127
310. ONE TOOLBAR PER LINE, PLEASE 128
311. ONE WORKSHEET, ONE PIECE OF PAPER 128
312. ORDER IN THE SORT 128
313. PARENTHESES ARE A NEGATIVE 129
314. PASTE PICTURES, NOT DATA 129
315. PASTING FORMATS 129
316. PATCH FOR ODBC 130
317. PICTURE PERFECT 130
318. Picture this 130
319. Play hide and seek with worksheets 131
320. PRINT AREA WARNING 131
321. PRINT BUTTON PROBLEM 132
322. Print only the data that you need 132
323. PRINTING GRID LINES 133
324. PRINTING HELP TOPICS 133
325. PRINTING THE WORKBOOK PATH IN A HEADER 133
326. Problems with Excel workbooks in Explorer 134
327. PROTECT YOUR PROJECT 134
328. PROTECTING WEB DATA 134
329. Put the full filename in the footer 135
330. QUICK CHARTS 135
331. QUICK COLUMN WIDTH CHANGE IN PRINT PREVIEW 
332. QUICK COMMENTS 136
333. QUICK COPY 136
334. QUICK FORMATS 136
335. QUICK MACROS 136
336. QUICK TIP FOR ENTERING NAMES IN A FORMULA 136
337. QUICK VIEW 137
338. QUICKLY CLOSING WORKBOOKS 137
339. QUICKLY INSERTING A NEW SHEET 137
340. QUICKLY SELECTING AN ENTIRE COLUMN 138
341. QUICKLY SELECTING AN ENTIRE ROW 138
342. QUICKY ASSIGNING A NAME 138
343. RANGE SHORTCUT 139
344. REDUCE CODING TIME 139
345. REPEATING HEADINGS IN LARGER SPREADSHEETS 139
346. REPLACE TEXT MACRO 140
347. RESETTING ADAPTIVE MENUS 140
348. RESETTING TOOLBARS 141
349. RETURN TO THE LAST WINDOW 141
350. RICH FORMATTING 141
351. ROUND TRIP 142
352. ROUNDING VERSUS TRUNCATING 142
353. Run code when a workbook opens 143
354. Save a chart as a .gif file 143
355. Save time by using Excel's Left, Right, and Mid string functions 144
356. Save yourself 146
357. SAVING FILES AUTOMATICALLY 146
358. SAVING TIME WITH TEMPLATES 146
359. SAVING WORKBOOKS 147
360. SAVING YOUR SPOT IN A MODULE 147
361. Schedule a procedure to run at a certain time 148
362. SELECTING ALL OBJECTS 148
363. SELECTING CHART PARTS 148
364. Send balloons to your users 149
365. Set a worksheet scroll area 149
366. Set the mode for calculation 150
367. Shift your focus with these keyboard tricks 150
368. SIMULATE GREENBAR PAPER IN A SHEET 151
369. SORTING WITH HIDDEN ROWS AND COLUMNS 151
370. SPEAKING OF CALCULATIONS 151
371. SPECIAL DATE FUNCTIONS 152
372. SPECIAL FILL FEATURE 152
373. Split texts in cells into multiple lines 152
374. Start a formula with a plus sign 153
375. Subtotaling Excel records by week and month 153
376. SUMMING ONLY THE NEGATIVE VALUES IN A RANGE 
377. Take command of button problems 156
378. TAKE THAT, YOU MACRO! 156
379. THE ENHANCED FILE DIALOG BOX 157
380. THE FRIEND KEYWORD 157
381. The incredible shrinking entry 157
382. THE PIVOTTABLE TOOLBAR 158
383. The quickest way to enter the same value 158
384. These functions know their names 158
385. THIRD-PARTY ASSISTANTS 159
386. Tips for multiple-page reports, part 1 159
387. TODAY'S DATE 160
388. Top of the list 160
389. Total a range that contains errors 160
390. TRACKING THE SCROLL BAR'S EXACT LOCATION 161
391. UNCOVERING THE VALUES 161
392. UNDERSTANDING DATE ARITHMETIC 162
393. UNDO WHAT 162
394. Update your values 162
395. Use a 3D range to total worksheets 163
396. Use Application.Interactive to control Excel 163
397. Use COUNT to avoid errors 164
398. Use Excel to test your application 164
399. Use GetOpenFilename to select files 164
400. USE GROUPS TO HIDE DATA 165
401. Use lowercase in worksheet formulas 165
402. Use VBA to e-mail your workbook 165
403. Use Web queries to get current data 166
404. Use your mouse to zoom 166
405. USING AUTOFORMAT 166
406. USING FORMAT PAINTER 168
407. USING OBJECT VARIABLES 169
408. Using the INDEX worksheet function 169
409. Using the OFFSET worksheet function 170
410. Using the R1C1 reference style 170
411. USING THE SELECT VISIBLE CELLS TOOL 171
412. USING THE SET PRINT AREA BUTTON 171
413. Using the TEXT worksheet function 172
414. Using the UsedRange property 172
415. Value your time wisely 172
416. View the same workbook in several windows 173
417. VIEWING MORE THAN YOU THOUGHT 173
418. WARNING WHEN VIEWING FORMULAS 174
419. WEB WORK 174
420. WHAT DAY IS IT 174
421. WHAT DAY IS IT 175
422. WHAT TIME IS IT 175
423. What week is it, really? 175
424. What week is it? 176
425. WHAT'S TODAY 176
426. WHEN A HYPERLINK IS NOT A HYPERLINK 176
427. WHEN AN EMBEDDED WORKSHEET DOESN'T WORK 
428. WHEN CASE COUNTS 177
429. WHEN FORMULAS DON'T WORK 177
430. When in Rome, count like the Romans 178
431. WHEN TO BEEP 178
432. WHEN TO ELSE OR ELSEIF USING VBA'S IF 178
433. WHEN TO USE DATA MARKERS 179
434. Where am I? 180
435. WHERE O' WHERE CAN THAT STATUS BAR BE 180
436. WINGDINGS IN COMMENTS 181
437. WORKBOOK NAMES 181
438. WORKING WITH CURRENCY 181
439. Working with multiples 182
440. Would you like to see a menu? 182
441. YOU WANT A FRAME WITH THAT 182
442. Your favorite places 183
443. YOU'RE BLOCKING MY VIEW 183
444. ZOOM IN 183
445.