How to Print All Tabs in Excel

You will learn how to print an entire workbook in Excel. This is a useful trick that will make printing easier and faster.

The Ribbon

You can print all the sheets together. Excel has got an option which lets you print the entire workbook.

To print the entire workbook, begin by navigating to the File tab on the Excel ribbon and then selecting Print.

Excel Print Button

Printing entire workbook

Within the Print backstage view, you’ll find the Settings section. Here, the first dropdown menu allows you to specify what to print. To print the entire workbook, choose the Print Entire Workbook option from this dropdown. Selecting this option will send all worksheets in the workbook to the printer.

Print Entire Workbook

Before printing, it’s advisable to review your printer settings and page setup options (such as page orientation, margins, and scaling) to ensure the printed output meets your requirements for all worksheets in the workbook. These settings can also be found within the Print backstage view.

See also  How to open .VCF files?