Teach MeShow MeLet Me TryPrint

Previewing a Print Area

The Print Preview window shows you a reduced version of your worksheet as it will appear when printed. Save time and printing by always checking your layout in Print Preview before you print. Use this view to see how your information fits on each page and to verify such things as placement of page numbers, headers, and column and row labels.

To preview your worksheet before printing it:

  1. Click the Print Preview button on the standard toolbar.
  2. When the Print Preview window opens, scroll the window to view the pages.
  3. Notice that the mouse pointer has changed to a magnifying glass. Click on a portion of the document you want to see it full-sized.
  4. Click again to reverse the magnification.
  5. Click the Next and Previous buttons to view the pages of your workbook.
  6. To return to Normal view, click Close on the Print Preview toolbar.

To see how your sheets will be divided into pages, switch to Page Break view. To do this, click the View menu and select Page Break Preview. Excel will display how your worksheet will print, including the order in which the pages will print. You can then adjust where the page breaks will occur by clicking and dragging a page dividing line. Click the View menu and select Normal to return to Normal View.
You can adjust page breaks, page setup, margins, headers and footers, and other page options from the Print Preview window. You can also print the worksheet from the Print Preview window by clicking the Print button to bring up the Print dialog box.