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. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |