In this quick video, you will learn how to Group and Ungroup Worksheets in Excel. Grouping worksheets can save you some time when you want to perform the same task repeatedly.
How to Group 2 or More Worksheets in Excel:
1. Open the workbook you want to work with, containing the worksheets you want to group together.
2. Press and hold down the Ctrl key, and then click on each of the worksheet tabs you want to group.
3. Alternatively, click the first worksheet tab you want to group, press and hold the Shift key, and then click the last worksheet tab to group consecutive worksheets.
4. Now, make any change to one of the worksheets in the group. You should notice that this change happens in all of the worksheets, even if you only edited one of them. This is the power of groups in Excel.

You can learn more here

свернуть