How to Print Multiple Tabs/Sheets in Excel

by

Excel has the option to print the active sheet, any selection on the active sheets as well as the entire workbook.

But what if you want to print multiple sheets in Excel, but don’t want to print the entire worksheets?

Of course, you can choose to do print one single sheet at one time and repeat the process, but you don’t have to.

There is a way to print multiple sheets/tabs in Excel (not the entire workbook), or even print the same selection of cells on multiple sheets

Let me show you how!

Print Multiple Sheets in Excel

Suppose you have five sheets in the Excel workbook and you only want to print the first three (or any other combination).

Below are the steps to do this:

  1. Select the sheets you want to print. To do this, hold the control key and then click on the tab where you have the sheet name.
  2. Hold the Control key and press the P key (or Command + P if you’re using a Mac)
  3. In the Print window that opens, under the Settings option, select Print Active SheetsSelect Print Active Sheets to print multiple selected sheets
  4. Select the Printer
  5. Click the Print buttonClick the Print button

That’s it!

This will print all the selected sheets, as now, Excel considers all the selected sheets as the active sheets and use all of them while printing.

Pro Tip: In case you have sheets that are not contiguous, you need to hold the control key and then use the mouse to select the sheets. In case these sheets are contiguous (i.e., all adjacent to each other), you can hold the SHIFT key, click on the left-most sheet, and the right-most sheet and it will select all the ones in between as well.

Caution: When you select multiple sheets, these are grouped together. When sheets are grouped, any changes you make will be made to all the grouped sheets. So make sure you ungroup the sheets once you’re done with printing

Print a Specific Selection in Multiple Sheets

In case you want to print multiple sheets in Excel, but not the entire worksheet – only a specific part, you can do that too.

Note that this would work only when you need to print the same range from all the selected sheets.

Below are the steps to print the same selection from multiple sheets:

  1. Select all the sheets that you want to print. To do this, hold the Control key and select the sheets (or Command key if you’re using Mac)
  2. In the active sheet, select the range of cells that you want to print
  3. Hold the Control key and press the P key (or Command + P if using Mac)
  4. In the Print window, under the Settings option, click and then select Print SelectionSelect Print Selection to print same area in multiple sheets
  5. Click the Print buttonClick the Print button

The above steps would only print the selected range of cells in the selected sheets.

So these are the ways you can use to print multiple sheets in Excel.

Hope you found this tutorial useful!

You may also like the following Excel tutorials:

Leave a Comment