Microsoft Excel - Printing a Worksheet in Excel

Print a worksheet

1. Select the worksheet or select the worksheets that you want to preview.

2. 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.

3. To preview the next and previous pages, at the bottom of the Print Preview window, choose Next Page and Previous Page.

4. 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.

5. 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.

6. Click Print.