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 all the tabs, go to the Ribbon. Click File > Print.

Excel Print Button

Printing entire workbook

Here you see the Settings. In the first list, you can choose what to print. Click Print Entire Workbook.

Print Entire Workbook

Excel will print the entire workbook. The more you print, the more time you will save.

See also  Using ByVal in VBA