1. Chapter 1 Entering Data Annoyances

   1. GENERAL DATA ENTRY ANNOYANCES

   2. IMPORTING DATA ANNOYANCES

   3. CUT-AND-PASTE ANNOYANCES

   4. NAVIGATION AND DISPLAY ANNOYANCES

   5. DATA VALIDATION ANNOYANCES

2. Chapter 2 Format Annoyances

   1. CELL FORMATTING ANNOYANCES

   2. CONDITIONAL FORMATTING ANNOYANCES

   3. TEMPLATE ANNOYANCES

   4. COLOR MANAGEMENT ANNOYANCES

   5. WORKBOOK FORMATTING ANNOYANCES

   6. CUSTOM FORMAT ANNOYANCES

3. Chapter 3 Formula Annoyances

   1. FORMULA ENTRY AND EDITING ANNOYANCES

   2. FORMULA ERROR AND AUDITING ANNOYANCES

   3. ARRAY FORMULA ANNOYANCES

   4. RECALCULATION ANNOYANCES

   5. DATE AND TIME ANNOYANCES

   6. NAMED RANGE ANNOYANCES

   7. TEXT FORMULA ANNOYANCES

   8. COUNTING AND CONDITIONAL SUM ANNOYANCES

4. Chapter 4 Manipulating Data Annoyances

   1. SORTING AND FILTERING ANNOYANCES

   2. LOOKUP FUNCTION ANNOYANCES

   3. WHAT-IF ANALYSIS ANNOYANCES

   4. PIVOTTABLE ANNOYANCES

5. Chapter 5 Chart Annoyances

   1. CHART CREATION AND FORMATTING ANNOYANCES

   2. CHART MANIPULATION ANNOYANCES

   3. PIVOTCHART ANNOYANCES

   4. CHART INTERACTION ANNOYANCES

   5. CHART ADD-INS AND HELPER APPLICATIONS

   6. 3D CHART ANNOYANCES

6. Chapter 6 Exhanging Data Annoyances

   1. MS QUERY AND DATABASE ANNOYANCES

   2. IMPORT AND EXPORT ANNOYANCES

   3. DATA FORMAT ANNOYANCES

7. Chapter 7 Printing Annoyances

   1. BASIC PRINTING ANNOYANCES

   2. PRINT LAYOUT ANNOYANCES

   3. PRINT CONTENT ANNOYANCES

   4. PRINTER MANAGEMENT ANNOYANCES

8. Chapter 8 Customization, Macro, and VBA Annoyances

   1. INTERFACE CUSTOMIZATION ANNOYANCES

   2. TOOLBAR AND MENU BAR ANNOYANCES

   3. MACRO ANNOYANCES

   4. MACRO SECURITY ANNOYANCES

   5. VBA ANNOYANCES

   6. HANDY VBA PROCEDURES

9. Chapter 9 Excel 2003 Annoyances

   1. EXCEL 2003 LIST ANNOYANCES

   2. EXCEL 2003 Excel 2003XMLXML ANNOYANCES

   3. EXCEL 2003 MENU AND FUNCTION ANNOYANCES

   4. EXCEL 2003 PROGRAM INTERACTION ANNOYANCES

1. Colophon

Our look is the result of reader comments, our own experimentation, and feedback from distribution channels. Distinctive covers complement our distinctive approach to technical topics, breathing personality and life into potentially dry subjects. Genevieve d'Entremont was the production editor and proofreader for Excel Annoyances. Audrey Doyle was the copyeditor. Genevieve d'Entremont did the typesetting and page makeup. Emily Quill and Claire Cloutier provided quality control. Julie Hawks wrote the index.

Volume Design, Inc. designed the cover of this book using Adobe Illustrator and produced the cover layout with Adobe InDesign CS using Lineto Gravur and Adobe Sabon fonts.

Patti Capaldi designed the interior layout using Adobe InDesign CS. The text and heading fonts are Rotis Sans Serif, Lineto Gravur Condensed, and Myriad Pro; the code font is TheSans Mono Condensed. Julie Hawks converted the text to Adobe InDesign CS. The screenshots and technical illustrations that appear in the book were produced by Robert Romano and Jessamyn Read using Macromedia FreeHand MX and Adobe Photoshop 7. The cartoon illustrations used on the cover and in the interior of this book are copyright© 2004 Hal Mayforth.