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.

Note: The following instructions apply to Excel for Mac 2011. If you're using Excel 2016 for Mac, print preview is built in to the Print dialog box. Click File > Print to preview your sheet and make any print-related adjustments.

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

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×