Print selection in excel pro#

Note that this would work only when you need to print the same range from all the selected sheets.īelow are the steps to print the same selection from 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.

So make sure you ungroup the sheets once you’re done with printing Print a Specific Selection in Multiple Sheets When sheets are grouped, any changes you make will be made to all the grouped 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.Ĭaution: When you select multiple sheets, these are grouped together.

Print selection in excel pro#

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

In the Print window that opens, under the Settings option, select Print Active Sheets.

Hold the Control key and press the P key (or Command + P if you’re using a Mac).

To do this, hold the control key and then click on the tab where you have the sheet name. Suppose you have five sheets in the Excel workbook and you only want to print the first three (or any other combination).

Print a Specific Selection in Multiple Sheets.