-
Select the worksheet or select the worksheets that you want to preview.
-
Choose File > Print. (You can also press CTRL+P.)
NOTE: The preview window will display in black and white, regardless of whether your worksheet(s) includes color, unless you are configured to print on a color printer.
-
To preview the next and previous pages, at the bottom of the Print Preview window, choose Next Page and Previous Page.
-
To set the printing options, do the following:
-
To change the printer, use 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 the options that you want under Settings.
-
To scale the entire worksheet to fit on a single printed page, under Settings, click the option that you want in the scale options drop-down box.
-
To print the workbook, do one of the following:
-
To print a portion of a worksheet, select the worksheet, and then select the range of data that you want to print.
-
To print the entire worksheet, select the worksheet to activate it.
-
Click Print.