How often are you working on a workbook with multiple sheets that are set up the same way and need to perform the same function on each one? Well, there’s a way that you only need to do it once and it will happen on all sheets simultaneously. It’s called Grouping!
I’ll start out with a sheet that has 3 tabs – Sheet1, Sheet2, & Sheet3. Normally they are ungrouped and the active sheet (in this case Sheet1) is brighter than the others:
Grouping sheets can be done in one of two ways:
– to group continuous sheets, hold down the Shift key and click on the last one you want to group. This will select all the sheets from the current one to the last one you clicked on; or
– to group non-continuous sheets, hold down the Ctrl key and click on each sheet that you want to group. This will allow you to group non-continuous sheets.
In the image below, I’ve chosen to group all 3 sheets. Notice how they are now all the same color:
Now, while the sheets are grouped, anything you do to one will automatically be done to the others! Try it! Enter a formula. Format a cell. Sum a column. It doesn’t matter what you do, it will happen to all the grouped sheets!
When you are done performing the functions that you want to occur on all selected sheets, just ungroup them by clicking on any of the grouped tabs and click on Ungroup Sheets:
Now that’s a nice time-saver!