Datasheet

Tips and Where to Find Them
Tip 1 Understanding Excel Versions 9
Tip 2 Maximizing Ribbon Efficiency 12
Tip 3 Selecting Cells Efficiently 14
Tip 4 Making “Special” Range
Selections 18
Tip 5 Undoing, Redoing, and
Repeating 21
Tip 6 Discovering Some Useful
Shortcut Keys 24
Tip 7 Navigating Sheets in a
Workbook 26
Tip 8 Resetting the Used Area of a
Worksheet 28
Tip 9 Understanding Workbooks
versus Windows 29
Tip 10 Customizing Your Quick Access
Toolbar 31
Tip 11 Accessing the Ribbon with the
Keyboard 35
Tip 12 Customizing the Default
Workbook 36
Tip 13 Using Document Themes 38
Tip 14 Changing the Sheet Tab
Appearance 42
Tip 15 Hiding User Interface Elements 44
Tip 16 Hiding Columns or Rows 46
Tip 17 Hiding Cell Contents 48
Tip 18 Taking Pictures of Ranges 49
Tip 19 Performing Inexact Searches 51
Tip 20 Replacing Formatting 53
Tip 21 Changing the Excel Color
Scheme 55
Tip 22 Limiting the Usable Area in a
Worksheet 56
Tip 23 Using an Alternative to Cell
Comments 60
Tip 24 Understanding the Excel
Help System 61
Tip 25 Making a Worksheet “Very
Hidden” 64
Tip 26 Disabling Hyperlink Warnings 66
04_137666 ch01.qxp 5/22/07 7:31 PM Page 8