![](https://csdnimg.cn/release/download_crawler_static/10585353/bg10.jpg)
Chapter 9: At Home on the Range . . . . . . . . . . . . . . . . . . . . . . . . . . . . .155
Selecting Your Cells ....................................................................................155
Selecting a range of cells ..................................................................156
Selecting a large range of cells .........................................................156
Selecting noncontiguous ranges of cells ........................................157
Selecting one row or column, or many, or all of them ..................158
Copying, pasting, cutting, dragging, and dropping your cells ..............159
Copying and pasting cells ................................................................159
Cutting and pasting cells ..................................................................159
Dragging and dropping cells ............................................................159
Formatting Your Numbers and Text .........................................................160
Formatting numbers with the toolbar ............................................160
Adding style with the toolbar ..........................................................162
Formatting using the Cell Attributes dialog box ...........................162
To AutoCorrect or not to AutoCorrect ...........................................164
Spell-checking ....................................................................................167
Seeing Sheer Simplicity in Sheets .............................................................168
Adding sheets ....................................................................................169
Scrolling through sheets ...................................................................170
Entering data into more than one sheet simultaneously .............170
Selecting sheets .................................................................................170
Selecting a single sheet .....................................................................170
Selecting several sheets simultaneously ........................................171
Selecting a large group of sheets .....................................................171
Selecting all sheets ............................................................................171
Deselecting one sheet at a time .......................................................171
Deselecting a large group of sheets ................................................171
Deselecting all sheets except the active sheet ..............................172
Renaming sheets ...............................................................................172
Moving and copying sheets .............................................................172
Deleting sheets ..................................................................................173
Chapter 10: Knock on Wood and Print! . . . . . . . . . . . . . . . . . . . . . . . . .175
Previewing Your Printout ...........................................................................175
Customizing Your Headers and Footers ...................................................176
Dealing with Page Breaks ...........................................................................177
Previewing page breaks ....................................................................178
Inserting manual page breaks ..........................................................179
Orienting your printout sideways ...................................................179
Scaling your printout ........................................................................179
Printing a Selection .....................................................................................180
Printing or Suppressing Sheets .................................................................180
Printing the Grid — or Not .........................................................................181
Expressing or Suppressing Those Doodles .............................................181
Printing Formulas ........................................................................................182
Printing Your Spreadsheet .........................................................................183
xiii
Table of Contents
542222 FM.qxd 11/6/03 3:29 PM Page xiii