1. Click the worksheet that you want to preview before you print it.
  2. Click the Microsoft Office Button button image, click the arrow next to Print, and then click Print Preview.

    Keyboard shortcut You can also press CTRL+F2.

  3. On the Print Preview tab, do one or more of the following:
    • To preview the next and previous page, in the Preview group, click Next Page and Previous Page.
    • To view page margins, in the Preview group, select the Show Margins check box.

      This displays the margins in the Print Preview view. To make changes to the margins, you can drag the margins to the height and width that you want. You can also change the column widths by dragging handles at top of print preview page.

Tip To make page setup changes, on the Print Preview tab, in the Print group, click Page Setup, and then select the options that you want on the Page, Margins, Header/Footer, or Sheet tab of the Page Setup dialog box.

See also: