Preview pages before you print

You can see how the data on your sheet will look when it is printed and identify any final adjustments that you want to make before you print.

Do any of the following:

Preview one sheet in a workbook

  1. Click the tab for the sheet that you want to preview.

    Excel sheet tabs

  2. On the Layout tab, under Print, click Preview.

    Layout tab, Print group

Preview all sheets in a workbook

  1. Hold down CONTROL and click the tab for any sheet in the workbook.

  2. On the shortcut menu, click Select All Sheets.

  3. On the Layout tab, under Print, click Preview.

    Layout tab, Print group

    Excel creates a separate preview page for each sheet.

See also

Print cell gridlines

Insert, move, or delete page breaks in a sheet

Print part of a sheet

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×