文档介绍：Excel Hacks ***@Team DDU
Table Of Contents
1. Excel Hacks 6
2. Table of Contents 6
3. Copyright 10
4. Dedication 10
5. Credits 10
About the Authors 11
Contributors 11
Acknowledgments 12
6. Preface 12
Why Excel Hacks? 12
Getting and Using the Hacks 13
How to Use This Book 13
How This Book anized 14
Windows and Macintosh Users 15
Conventions Used in This Book 16
Using Code Examples 17
How to Contact Us 18
7. Chapter 1. Reducing Workbook and Worksheet Frustration 18
Hacks #1-15 19
Hack 1 Create a Personal View of Your Workbooks 22
Hack 2 Enter Data into Multiple Worksheets Simultaneously 26
Hack 3 Prevent Users from Performing Certain Actions 28
Hack 4 Prevent Seemingly Unnecessary Prompts 33
Hack 5 Hide Worksheets So That They Cannot Be Unhidden 37
Hack 6 Customize the Templates Dialog and Default Workbook 38
Hack 7 Create an Index of Sheets in Your Workbook 41
Hack 8 Limit the Scrolling Range of Your Worksheet 44
Hack 9 Lock and Protect Cells Containing Formulas 48
Hack 10 Find Duplicate Data using Conditional Formatting 51
Hack 11 Tie Custom Toolbars to a Particular Workbook 53
Hack 12 Outsmart Excel's Relative Reference Handler 56
Hack 13 Remove Phantom Workbook Links 56
Hack 14 Reduce Workbook Bloat 59
Hack 15 Extract Data from a Corrupt Workbook 62
8. Chapter 2. Hacking Excel's Built-in Features 64
Hacks #16-38 65
Hack 16 Validate Data Based on a List on Another Worksheet 66
Hack 17 Control Conditional Formatting with Checkboxes 67
Hack 18 Identify Formulas with Conditional Formatting 71
Hack 19 Count or Sum Cells That Meet Conditional Formatting Criteria 72
Hack 20 Highlight Every Other Row or Column 75
Hack 21 Create 3D Effects in Tables or Cells 76
Hack 22 Turn Conditional Formatting and Data Validation On and Off with a Checkbox 78
Hack 23 Support Multiple Lists in boBo