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