How to Print Multiple Sheets in Excel & Google Sheets

Written by

Mel Jenkins

Reviewed by

Laura Tsitlidze

Last updated on August 23, 2023

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

print multiple sheets 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.

print multiple sheets all tabs

  1. In the Ribbon, go to File > Print > Settings, and then choose Print Entire Workbook.

print multiple sheets whole workbook

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

print multiple sheets preview

  1. Then, just click Print.

print multiple sheets 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.

print multiple sheets selected tabs

  1. In the Ribbon, go to File > Print > Settings, and then choose Print Active Sheets.

print multiple sheets active sheets

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

print multiple sheets preview selected sheets

  1. Then, click Print.

Print Multiple Google Worksheets

  1. In the Toolbar, click Print.

print multiple sheets 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.

print multiple sheets gs current sheet

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

print multiple sheets gs workbook

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

print multiple sheets gs select

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

print multiple sheets gs select sheets

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

print multiple sheets gs next

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

print multiple sheets gs print preview

AI Formula Generator

Try for Free

See all How-To Articles