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 the entire workbook, begin by navigating to the File tab on the Excel ribbon and then selecting Print.
Printing entire workbook
Within the Print backstage view, you’ll find the Settings section. Here, the first dropdown menu allows you to specify what to print. To print the entire workbook, choose the Print Entire Workbook option from this dropdown. Selecting this option will send all worksheets in the workbook to the printer.
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. These settings can also be found within the Print backstage view.
