With the worksheet you want to print open on your desktop, click the Print Preview button on the Standard toolbar.
The Print Preview window opens, displaying the worksheet in Print Preview mode. Press the Page Up and Page Down keys to view the pages in your worksheet.
Click the Zoom button to toggle between increasing and decreasing the worksheet size. You can also simply click once on the worksheet to zoom in.
INTRODUCTION
Workbooks or worksheets with a lot of data can generate large print jobs, possibly containing hundreds of pages. Waiting until all these pages are printed to verify that the information is printed correctly can cost a lot in both time and printing supplies. To help prevent printing mistakes, use Print Preview to ensure that all the necessary elements appear on the pages being printed.
Click the Margins button to display the current worksheet margins. (For more information about working with margins, see p. 162.)
Click Zoom again to toggle between increasing and decreasing the size of the work sheet in Print Preview mode; here you zoom out. You can also click the worksheet once.
Click the Close button to exit Print Preview mode.
TIP
Using the Page Break Preview Button
Clicking the Page Break Preview button takes you from Normal view to Page Break Preview view, in which you can see exactly what is selected to print (in the print area). If you haven't set the print area, see the next task, "Setting the Print Area." If you are already in Page Break Preview view when you click the Print Preview button, the toolbar button will display Normal view instead, which shows your entire worksheet (regardless of whether you have set the print area).