If you are editing multiple worksheets in Microsoft Excel, it may be useful to group them. This enables you to make changes to the same cell range in multiple worksheets. Here's how to do it.
Group multiple worksheets in Microsoft Excel
Grouping worksheets in Excel can be useful if you have an Excel workbook with multiple sheets that contain different data but follow the same layout..
The following example shows this in action. Our Excel workbook, called “School details”, contains various worksheets associated with running a school. Three of the worksheets have lists of students for different classes, calls “A class”, “Class B” and “Class C”.
If we group these worksheets, any action we take in any of these worksheets will apply to all of them.
As an example, let's say we want to insert an IF formula in column G (cells G4 to G12) on each worksheet to establish whether any student was born in 1998 O 1999. If we group the worksheets before inserting the formula, we can apply it to the same cell range in all three worksheets.
RELATED: How to use logical functions in Excel: AND, AND, O, XOR, NO
To group worksheets, press and hold the Ctrl key and click each worksheet you want to group at the bottom of the Excel window.
Grouped worksheets appear with a white background, while unselected worksheets are grayed out.
the following example shows the if formula that we suggested previously inserted into the worksheet “Class B”. Thanks to grouping worksheets, In addition, the same formula was inserted in cells G4 to G12 of the worksheets "Class A" and "Class C".
If we further modify any of these cells, like adding a second set of formulas to column H, the change will be applied to all grouped worksheets simultaneously.
Group all worksheets in Microsoft Excel
When you hold down the Ctrl key, you can choose multiple individual worksheets and group them. Despite this, if you have a much larger workbook, this is not practical.
If you want to group all worksheets in one Excel workbook, you can save time by right-clicking one of the worksheets listed at the bottom of the Excel window.
From here, click on “Choose all sheets” to group all your worksheets.
Ungroup worksheets in Microsoft Excel
After you have finished making changes to multiple worksheets, you can ungroup them in two ways.
The fastest method is to right-click a selected worksheet at the bottom of the Excel window and then click “Ungroup sheets”.
You can also ungroup individual sheets one at a time.. Just press and hold the Ctrl key and then select the sheets you want to delete from the group. The worksheet tabs you ungroup will have a gray background again.
