How to Print in Excel

Once you’ve created a worksheet, and your computer is connected to a printer, you can print a copy. Before you do this, it’s a good idea to preview how it’s going to look.

Preview and Print a Worksheet

You can preview and then print a worksheet as part of the same operation.

  1. Click the File tab.
    Preview and Print a Worksheet
  2. Select Print.

    The Print tab is where you’ll find the print preview.

  3. Click Print.
    Preview and Print a Worksheet

Press Ctrl + P to quickly print a worksheet.

Specify Printing Options

Sometimes you will want to specify more printing options, such as the number of copies to print.

  1. Click the File tab.
    Specify Printing Options
  2. Select Print.
  3. Select the desired print options:
    • Number of Copies you want to print.
    • Printer where you want to send the worksheet.
    • Print Area you want to print.
    • Page Orientation
  4. Click Print.
    Specify Printing Options

Customizable Print Options

Print Option Description
Printing, number of copies Specify the number of copies you want to print.
Printer options Select the printer you want to use (if you have more than one).
Print area Print the active worksheet, the entire workbook, or a selection of cells.
Collation options If you are printing multiple copies, you can select collation options.
Printing Page orientation Select between portrait or landscape orientations.
Printer paper size Select the paper size you want to print on.
Adjust page margins Adjust page margins.
Print scale Reduce the print scale, to include more text on the printout.

FREE Quick Reference

Click to Download

Free to distribute with our compliments; we hope you will consider our paid training.