Chapter 1. Reducing Workbook and Worksheet Frustration

     

Hacks #1-15

Section 1.   Create a Personal View of Your Workbooks

Section 2.   Enter Data into Multiple Worksheets Simultaneously

Section 3.   Prevent Users from Performing Certain Actions

Section 4.   Prevent Seemingly Unnecessary Prompts

Section 5.   Hide Worksheets So That They Cannot Be Unhidden

Section 6.   Customize the Templates Dialog and Default Workbook

Section 7.   Create an Index of Sheets in Your Workbook

Section 8.   Limit the Scrolling Range of Your Worksheet

Section 9.   Lock and Protect Cells Containing Formulas

Section 10.   Find Duplicate Data using Conditional Formatting

Section 11.   Tie Custom Toolbars to a Particular Workbook

Section 12.   Outsmart Excel's Relative Reference Handler

Section 13.   Remove Phantom Workbook Links

Section 14.   Reduce Workbook Bloat

Section 15.   Extract Data from a Corrupt Workbook