| 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 |