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 Shortcuts: 2 Simple Steps to View Multiple Worksheets in Excel?
I have found this same spelling mistake in other 2 worksheets (2020 & 2019):
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).
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.
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.