Edit Multiple Sheets At The Same Time
This will select all sheets.
When you are making changes to any sheet, these changes will also be present at all the selected sheets.
To ungroup sheets, and then work on one, right-click at any tab and select Ungroup Sheets.
This easy trick will help you to edit multiple sheets at the same time in Excel.