How to Perform the Same Action to a Group of Excel Sheets Simultaneously
If you need to perform the same action to multiple worksheets in your Excel workbook, you can group worksheets and perform that action only once. Left-click on the tab of the first worksheet to include, hold down the Shift key, and left-click on the last worksheet to include. You have now made those worksheets a group. Go to any of the worksheets and perform the desired action. You will see that action has been performed on all worksheets that were included in the group. When you are done, right-click on any of the worksheets in the group and select Ungroup Sheets.