How to Print Multiple Sheets in Excel & Google Sheets

This tutorial demonstrates how to print multiple worksheets in Excel and Google Sheets.

 

 

Print Entire Workbook

If a workbook contains multiple sheets, and you wish to print all sheets at once, you can opt to print the entire workbook.

 

 

1. In the Ribbon, select File > Print > Settings and then select Print Entire Workbook.

 

 

2. Check that all tabs in the workbook are shown in Print Preview, where each tab starts on a new page.

 

 

3. Then, just click Print.

Print Selected Sheets

If you have multiple sheets in your workbook, but you only wish to print selected sheets, not all, follow these steps:

1. Select the tabs you wish to print. Click on the tab of the first sheet you wish to print, and then, holding down the CTRL key, click on subsequent sheet tabs.

 

 

2. In the Ribbon, select File > Print > Settings and then select Print Active Sheets.

 

 

3. Only the two selected tabs are shown in Print Preview.

 

 

4. Then, click Print.

Print Multiple Google Worksheets

1. In the Toolbar, select Print.

 

 

2. This takes you to a Print Preview screen with a pane on the right-hand side of the screen. This pane is automatically set to print the Current sheet.

 

 

3. From the drop-down arrow, select Workbook.

 

 

The Selection drop down is set to all sheets by default.

 

 

4. Click on the drop-down arrow to show the individual sheets in the workbook and select the ones you wish to print. Then click Apply.

 

 

5. Click the Next button in the top right-hand corner of your screen.

 

 

6. Your Google Sheets file is shown in Print Preview with your printer options available. Click Print to print to print the selected sheets.