Print Selected Worksheets (w/o Print Preview) in Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on August 21, 2023

This tutorial demonstrates how to print selected worksheets at once in Excel and Google Sheets.

print selected worksheets 8

Print Selected Worksheets in Excel

Printing multiple sheets at once is quite easy. All you need to do is to select the sheets you want to print and print normally.

  1. First, to select the sheets you want to print, hold the CTRL key and click on each sheet you want to print, one by one, to group them.

print selected worksheets 2

  1. After that, in the Ribbon, click on the File tab. In it, click Print. Then in Print Settings, click Print Active Sheets. It’s already the default option, but if it isn’t already selected, you can choose Print Active Sheets from the drop down.

print selected worksheets 3

  1. Finally, just click print, and you are done.

print selected worksheets 5

As a result, you’ll print only the sheets you selected.

Note: Another option is to use a macro to loop through selected sheets and print them that way.

Print Selected Worksheets in Google Sheets

  1. First, in the Menu, go to File > Print (or use the CTRL + P shortcut).

print selected worksheets 6

  1. This opens the Print Settings window. Under the Print section, choose Workbook.

print selected worksheets 7

  1. To select specific sheets you want to print, click on the Selection section, then tick the sheets you want to print. After that, click Apply.

print selected worksheets 4

As a result, you print only the sheets you selected.

AI Formula Generator

Try for Free

See all How-To Articles