Page 13 - Excel Timesaving Techniques for Dummies

00b_574272_ftoc.qxd 10/1/04 10:24 PM Page xii
xii
Excel 2003 Timesaving Techniques For Dummies
Part V: Worksheet Editing Timesavers 169 Part VI: Tips for Printing, Sharing,
Technique 31: Quickly Finding the and Reviewing Workbooks 205
Workbook You Want to Edit 171 Technique 38: Spreadsheet Security 207
Opening Recently Used Files 171 Assigning a Password for Opening a Workbook 207
Making the Most of the File Search Task Pane 172 Opening a password-protected workbook 209
Doing a basic file search 172 Changing or deleting passwords 210
Conducting the file search and using the results 173 Protecting the Worksheet Against Unwanted
Doing an advanced file search 174 Changes 211
Searching for Files in the Open Dialog Box 175 Unlocking cells for data entry 211
Technique 32: Controlling the Worksheet Turning on worksheet protection 212
Removing protection from a worksheet 213
Window Display 177
Enabling cell range editing by certain users 214
Zooming In for the Edits 177 Protecting the structure of the workbook file 216
Frozen Panes in My Windows 179 Hiding Sensitive Worksheet Data 217
A Worksheet with a Custom View 180
Technique 39: Printing Tricks for
Technique 33: Managing Worksheet Flawless Reports 219
Windows 182 Making Last-Minute Adjustments with
Opening Panes in the Worksheet Window 182 Print Preview 219
Comparing Sheets in the Same Workbook 184 Manipulating the margins and column widths 221
Comparing Sheets in Separate Workbooks 185 Manipulating the page settings 221
Controlling Bad Page Breaks 222
Technique 34: Quick and Easy Insertion
Using the Page Break Preview feature 223
and Deletion 187 Changing the scale of the printing 224
Inserting and Deleting Cells in an Adding Headings to Your Report 225
Existing Range 187 Headers and footers made to order 225
Inserting and Deleting Rows and Columns 188 Print titles on every page 226
Inserting and Deleting Worksheets 190 Printing the Formulas in the Report 227
Printing the Charts in the Report 228
Technique 35: Outline and Subtotal Magic 191
Technique 40: Sharing Data with
Adding Outline Levels to a Table or List 191
Subtotaling a Table or List 193 Other Office Programs 230
Swapping Data via the Clipboard 230
Technique 36: Consolidating Data from
Importing Text Files into Excel 232
Different Worksheets 195
Embedding Excel Data in Other Office
Consolidating Data by Position 195 Documents 235
Consolidating Data by Category 197 Embedded worksheet data 235
Linking Consolidated Data 197 Linking worksheet data 237
Technique 37: Editing with Search & Technique 41: Sharing Workbooks
Replace and Spell Check 199 on a Network 238
Using Find and Replace 199 Let’s All Learn to Share 238
Eliminating Typing Errors with Spell Check 201 Editing changes not available
Customizing the Spell Check settings 202 to a shared workbook 239
Adding words to a custom dictionary 203 Sharing a workbook 239