How to Print All Tabs in Excel

In this article, 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 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.

Using a Macro

To print an entire workbook using a macro, follow these steps:

Insert a new module in the Visual Basic Editor (VBE) by pressing Alt+F11.

Paste the following code into the module:

Sub PrintEntireWorkbook()

'Print the entire workbook

End Sub

Save the module and close the VBE.

To run the macro, press Alt+F8 to open the Macro dialog box.

Select the PrintEntireWorkbook macro and click Run.

See also  How to Recover Recently Closed Excel Files: A Step-by-Step Guide