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.
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.