Use Group Mode to Change All Worksheets
September 17, 2021 - by Bill Jelen
Problem: I now have 12 nearly identical worksheets. I have to make a similar change to all 12 sheets.
Strategy: Use Group Mode. Any changes you make to the active sheet will apply to all of the sheets in the group.
- If you need to put all of the sheets in the workbook in group mode, you can right-click any tab and choose Select All Sheets.
- To group several consecutive sheets, select the first sheet, then Shift Click on the last sheet. Alternatively, use Ctrl+Shift+PageDown to add sheets to the right to the group.
- To group sheets that are not adjacent, select the first sheet, then Ctrl+Click other sheets.
When worksheets are grouped, you will see the word [Group] to the right of the workbook name in the title bar. Any changes that you make will happen to all of the sheets in the group.
Gotcha: Don’t get distracted and forget that you are in group mode. I’ve forgotten that I was in group mode and spent an hour keying numbers into January, only to discover that I was destroying numbers on all of the back sheets.
Additional Details: There are three ways to exit group mode. First: Right-click any sheet tab and choose Ungroup Sheets. Second: If a sheet is not included in the group, select that sheet. Third option: If all of the sheets are included in the group, click on any sheet that is not the active sheet.
This article is an excerpt from Power Excel With MrExcel
