Group Worksheets In Excel

If you want to modify data across multiple worksheets, then let me tell you that it is very easy to do with the help of Group Worksheets feature in Excel.

Here I have this same mistake on multiple worksheets –  see the Messis typo in the screenshot given below. I want to change this to Messi.

Previously In Excel Shortcuts2 Simple Steps to View Multiple Worksheets in Excel?

Group Worksheets

I have found this same spelling mistake in other 2 worksheets (2020 & 2019):

Group Worksheets

I have explained below how you can do this and please go to the bottom of the page to see the complete tutorial:

STEP 1: Firstly, select the worksheets with the left mouse button that need editing while holding the CTRL button.

For example, I’m selecting 2019, 2020, and 2021 worksheets while holding the CTRL button (you will see that each selected sheet showing white colour).

Group Worksheets

STEP 2: Now go and edit the cell in any one of that worksheet

like here I’m going to change the Messis to Messi and press the ENTER button after that.

This will change the same changes into all that worksheet values.

Group Worksheets

STEP 3: Ungroup The Worksheets

To ungroup (this is important to do when you finish making your changes in worksheets) the worksheets, right-click on the worksheet tabs and select the option of Ungroup Sheets.

Group Worksheets