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:
- 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.
- Hold the Control key and press the P key (or Command + P if you’re using a Mac)
- In the Print window that opens, under the Settings option, select Print Active Sheets
- Select the Printer
- Click 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:
- 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)
- In the active sheet, select the range of cells that you want to print
- Hold the Control key and press the P key (or Command + P if using Mac)
- In the Print window, under the Settings option, click and then select Print Selection
- Click 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:
- How to Set a Row to Print on Every Page in Excel
- How to Fit to Page in Excel (Print on One Sheet)
- How to Center the Worksheet Horizontally on the Page in Excel
- How to Print Row Numbers in Excel
- How to Print Gridlines in Excel
- 3 Ways to Duplicate Sheet in Excel
- Print Preview in Excel [Keyboard Shortcut]