How to Print All Sheets in an Excel Workbook at Once

Learn how to print all worksheets in an Excel file with a single print command. This quick Excel trick helps you save time by printing multiple tabs at once.

The Ribbon

You can easily print all the Excel sheets together from one menu. Excel includes a built-in feature to print an entire workbook with just a few clicks.

To print all tabs in Excel, go to the File tab, then click on Print to open the printing options.

Excel Print Button

Printing entire workbook

In the Excel Print menu (backstage view), go to the Settings section to choose what to print. Use the first dropdown under Settings to choose whether to print the current sheet, selected sheets, or the entire workbook. Select “Print Entire Workbook” to print all worksheets in your Excel file at once. This command sends every worksheet in your Excel workbook to the printer in one batch.

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. All these print and layout options are available in Excel’s Print backstage menu.

See also  How to Bold the Highest Value in Excel