Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours

Choosing What to Print

In some cases, you might want to choose what to print—perhaps only a portion of the worksheet, and not the whole worksheet or workbook. Excel's Print Area feature lets you single out an area on the worksheet that you want to print. The Print Titles feature lets you repeat the title, subtitle, column headings, and row headings on every page.

Excel's Fit To option lets you shrink the pages to fit any number of pages you want by shrinking a worksheet down so small that you can't read the text. If you shrink it to some suitable multiple-page setting, such as 1 page wide by 3 pages high, you could read the text comfortably.

Selecting a Print Area

To print specific portions of a worksheet, such as a range of cells, you can single ...