Before you print a worksheet, it's a good idea to preview it to make sure that it looks the way you want. That's why when you print a worksheet in Microsoft Excel, it opens a preview screen. In this view, you can change the page setup and layout before you print.
Preview the worksheet
-
Select the worksheet or select the worksheets that you want to preview.
-
Select File > Print.
Keyboard shortcut: Press Ctrl+P.
Set printing options
Do one or more of the following:
-
Select the worksheet or select the worksheets that you want to preview.
-
Select File > Print.
-
To change the printer, select the drop-down box under Printer, and select the printer that you want.
-
To make page setup changes, including changing page orientation, paper size, and page margins, select Printer Properties.
Print all or part of the worksheet
-
To print the active sheet or sheets, or the whole workbook, in the Print dialog box, select from Settings: Print Active Sheets, Print Entire workbook, or Print Selection.
-
Select Print.
Note: If a worksheet has a defined print area, Excel prints only that area. If you don't want to print only the defined print area, select Ignore print area in the Settings drop-down box.
Next steps
For detailed instructions on how to print a worksheet, see Print a worksheet or workbook and Define or clear a print area on a worksheet.