Page 13 - Excel Workbook for Dummies

02_798452 ftoc.qxp 3/14/06 10:34 AM Page x
x Excel Workbook For Dummies
Chapter 3: Printing Spreadsheet Reports.........................................................................37

Previewing the Printed Report...............................................................................................37
Adjusting Page Breaks.............................................................................................................38
Adding Custom Headers and Footers....................................................................................39
Adding Print Titles to a Report ..............................................................................................41
Modifying the Print Setting for a Report...............................................................................42
Printing All or Part of the Workbook.....................................................................................44
Printing a range of cells.................................................................................................44
Printing the entire workbook........................................................................................45
Printing charts in the spreadsheet ..............................................................................46
Printing the spreadsheet formulas...............................................................................46
Chapter 4: Modifying the Spreadsheet.............................................................................49

Finding and Opening the Workbook for Editing...................................................................49
Adding summary information to a workbook ............................................................49
Searching for workbook files ........................................................................................51
Exploring the Open options..........................................................................................53
Finding and Identifying the Region that Needs Editing.......................................................54
Selecting the Ranges to Edit ...................................................................................................56
Editing Data Entries .................................................................................................................57
Catching Errors with Text to Speech.....................................................................................58
Deleting and Inserting Data and Cells ...................................................................................60
Moving and Copying Data and Cells......................................................................................61
Using Notes in the Spreadsheet .............................................................................................64
Using Find and Replace and Spell-Checking.........................................................................66
Group Editing............................................................................................................................68

Part II: Using Formulas and Functions..........................................71

Chapter 5: Building Formulas.............................................................................................73
Building Formulas ....................................................................................................................73
Building formulas by hand............................................................................................74
Building formulas with built-in functions....................................................................78
Editing formulas .............................................................................................................81
Altering the natural order of operations.....................................................................82
Using External Reference Links..............................................................................................84
Controlling When Formulas Are Recalculated .....................................................................86
Chapter 6: Copying and Correcting Formulas..................................................................89
Copying Formulas with Relative References ........................................................................89
Copying Formulas with Absolute References.......................................................................91
Copying Formulas with Mixed References............................................................................92
Using Range Names in Formulas............................................................................................96
Building Array Formulas .........................................................................................................99
Tracing and Eliminating Formula Errors.............................................................................101
Dealing with Circular References.........................................................................................104

Chapter 7: Creating Date and Time Formulas................................................................107
Constructing Date and Time Formulas ...............................................................................107
Working with the Date Functions.........................................................................................109
Working with the Time Functions........................................................................................112