See all How-To Articles

How to Print Multiple Sheets in Excel & Google Sheets

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

 

printmultiplesheets intro

 

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.

 

printmultiplesheets all tabs

 

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

 

printmultiplesheets wholeworkbook

 

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

 

printmultiplesheets preview

 

  1. Then, just click Print.

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

 

printmultiplesheets selected tabs

 

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

 

printmultiplesheets active sheets

 

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

 

printmultiplesheets preview selected sheets

 

  1. Then, click Print.

Print Multiple Google Worksheets

  1. In the Toolbar, select Print.

 

printmultiplesheets gs menu

 

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

 

printmultiplesheets gs currentsheet

 

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

 

printmultiplesheets gs workbook

 

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

 

printmultiplesheets gs select

 

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

 

printmultiplesheets gs select sheets

 

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

 

printmultiplesheets gs next

 

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

 

printmultiplesheets gs print preview