Page 11 - Excel Timesaving Techniques for Dummies

00b_574272_ftoc.qxd 10/1/04 10:24 PM Page x
x
Excel 2003 Timesaving Techniques For Dummies
Part II: Quick Worksheet Creation Information Please! 75
Tricks 45 Warnings to Make Them Wary 76
Technique 15: All Aboard the Numerical
Technique 9: Navigating the Worksheet
in a Snap 47 Entry Express! 78
Taking Advantage of the Numeric Keypad 78
Saving the Cell Pointer’s Position 47
Putting the Decimal Places at Your Service 79
Going Direct 48
Number Please! 80
Leaping through data ranges and hopping
over blanks 48 Technique 16: Verifying Entries with Text
Going right to the last cell in a sheet 49 to Speech 82
Zipping through the sheets 50
“Can You Hear Me Now?” 82
A Little Go To Magic 51
Speak on Enter 83
Zooming Out to Get the Big Picture 52
Reading by columns and rows 83
Technique 10: Making the Most Efficient Modifying the Text to Speech Settings 84
Cell Selections 53
Part III: Handy Ways to Format and
AutoSelect at Your Service 54
Go To It and Select It 55 Present Worksheet Data 85
Going for the Big Selections 56 Technique 17: Instant Range Formatting 87
Technique 11: Speeding Through Long Head-to-Toe Table Formatting with AutoFormat 87
Data Entries with AutoCorrect 58 Getting Artistic with the Format Painter 89
Setting the Correct AutoCorrect Settings 58 Cutting and Pasting Formats Only 90
Losing the Links 59 Technique 18: Style Formatting Magic 92
Taming the Smart Tags 60
Styling 93
Technique 12: Data Entry Tricks 62 Applying predefined styles in a spreadsheet 93
Customizing predefined styles 94
Making the Same Entry in Many Places 62
Creating Styles of Your Own 94
Putting the Wraps on the Data Entry 63
Merging Styles from One Book into Another 95
Let’s Do It as a Group! 65
Technique 19: Controlling When Certain
Technique 13: Speeding Up Data Entry
with AutoFill 67 Formats Are Used 97
Formats to Suit Every Condition 97
Getting Your Fill of AutoFill 67
When two conditions are better than one 99
Using AutoFill to generate a sequentially
numbered series 69 Finding cells with conditional formatting 100
Making Your Outstanding Errors Stand Out 100
Copying an entry instead of filling in a series 69
Incrementally Speaking 70 Technique 20: Customizing Number
Fill Lists Made to Order 71 Formats 102
Technique 14: Ensuring Accurate Data Creating Custom Number Formats 102
Entries with Data Validation 72 Custom formats that conditionally
format entries 105
Only the Valid Need Apply 72
Custom formats that hide certain entries 106
Data entries from a list 73
Copying data validation settings 74
Finding cells using data validation 75