Preview worksheet pages before printing
- Click the worksheet that you want to preview before you print it.
- Click the
Microsoft Office Button
, click the arrow next to Print, and then clickPrint Preview.Keyboard shortcut You can also press CTRL+F2.
- On the
Print Previewtab, do one or more of the following:- To preview the next and previous page, in the
Previewgroup, clickNext PageandPrevious Page. - To view page margins, in the
Previewgroup, select theShow Marginscheck box.This displays the margins in the
Print Previewview. 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.
- To preview the next and previous page, in the
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:
- Add, delete, or move page breaks
- Print a worksheet or workbook
- Use Page Layout view to fine-tune pages before printing