See all How-To Articles

Print All Tabs / Sheets in Excel or Google Sheets Workbook

In this tutorial, you will learn how to print all tabs (worksheets) in an Excel or Google Sheets workbook.

 

print all tabs 5

 

Print All Tabs in Excel Workbook

There is a simple way to print all the sheets from your workbook at once in Excel.

1. In the Ribbon, click on the File, and from the drop-down menu choose Print (or use the CTRL + P shortcut).

 

print all tabs 1

 

2. After that, the Print Preview window will open. In the menu on the left side, under the Settings section click on the arrow next to the default print option (in this example, Print Active Sheets) and then choose Print Entire Workbook.

 

print all tabs 2

 

As a result of the previous steps, all tabs from the workbook will be ready for printing at the same time.

 

print all tabs 5

 

Print All Sheets in Google Sheets Workbook

To print all the sheets from the workbook in Google Sheets, follow these steps:

1. In the Toolbar, click on File > Print (or use the CTRL + P shortcut).

 

print all tabs 7

 

2. The Print Preview window will open. In the Menu click on the arrow under the Print section and in the drop-down menu choose Workbook.

 

print all tabs 8

 

As a result of the previous steps, all sheets from the workbook will be printed at the same time.

 

print all tabs 10