Use Group Mode to Change All Worksheets


September 17, 2021 - by

Use Group Mode to Change All Worksheets

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

Title photo by Duy Pham on Unsplash