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.

Printing entire workbook

Here you see the Settings. In the first list, you can choose what to print. Click 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
ActiveWorkbook.PrintOut

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.

Related posts:

How to create household budget? How to count cells with a specific content in a range? How to open xlb file in Excel