Excel Hacks 100 Industrial Strength Tips and Tools

By David Hawley, Raina Hawley

Cover | Table of Contents | Colophon

---

Sample Hacks

• Hack 2: Entering Data into Multiple Worksheets Simultaneously (PDF Format)

• Hack 9: Locking and Protecting Cells Containing Formulas (PDF Format)

• Hack 18: Identifying Formulas with Conditional Formatting (PDF Format)

• Hack 28: Customizing Cell Comments (PDF Format)

• Hack 39: Addressing Data by Name (PDF Format)

• Hack 46: Sharing PivotTables but Not Their Data (PDF Format)

• Hack 51: Creating Two Sets of Slices in One Pie Chart (PDF Format)

• Hack 60: Adding Descriptive Text to Your Formulas (PDF Format)

• Hack 81: Speeding Up Code While Halting Screen Flicker (PDF Format)

• Hack 99: Accessing SOAP Web Services from Excel (PDF Format)

Return to Excel Hacks