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, go to File > Print > Settings, and then choose 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, go to File > Print > Settings, and then choose 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, click 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, choose 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 check off the ones you want to print. Then click Apply.

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

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