Using the Print Preview Window

You can access the Print Preview window in the following ways:

Ribbon bar. Select the File tab. In the left pane, select Print. In the right pane, click Print Preview.

Classic menus. From the File menu, select Print Preview, or click the Print Preview toolbar button.

You can also access the Print Preview window from the Print Spreadsheet dialog box by clicking the Preview button.

Before you print a spreadsheet, it is useful to see how the spreadsheet looks when you print it. The way a spreadsheet appears in the window depends on the resolution of your printer and the available fonts and colors. The status bar at the bottom of the window shows the current page number.

The Margins group lists the margin information for Left, Right, Top, and Bottom margins, as well as how far the header and footer prints from the edge of the page. You can modify the margin information in any of these fields by entering new measurements and clicking Adjust. You can also adjust the margins by dragging the dashed lines (which correspond to the six margin measurements) to the desired location.

The Header/Footer button accesses the header and footer information for the spreadsheet (see Create a Custom Header or Footer).
Option Description
Print You can access the Print dialog box.
Next page You can view the next page of the active spreadsheet in the Print Preview window.
Prev page You can view the previous page of the active spreadsheet in the Print Preview window.
Two page You can see a two-page view of the active spreadsheet in the Print Preview window.
Margins You can show or hide the margin information at the right side of the Print Preview window.
Zoom in You can magnify the view of the active spreadsheet.
Zoom out You can decrease the magnification of the view.
Close Closes the Print Preview window and returns to an editable view of the active spreadsheet.

See also: Printing a Spreadsheet.