Grouping Your Worksheets Together -- 2
Budget: ₹750 – ₹1,250 INR
n Excel, working with your worksheets as a single group is a quicker way for applying formulas and formatting across worksheets with the same formatting. For instance, let’s say you need to change your monthly rent costs and regular bills. If you’re moving in September and need to update your budget worksheets, grouping them together will let you input the data once to update the entire group.
a) Click on the first worksheet tab you wish to edit.
b) Then Click + CTRL (for non-adjacent worksheet tabs) or Click + Shift (for adjacent worksheets) on the other worksheet tabs to add it to the group.
c) Modify the cell as needed. Click on enter.
To ungroup your worksheets, you can right click and select Ungroup Sheets option. This may seem like a basic tip, but it’s a powerful one to have!
a) Click on the first worksheet tab you wish to edit.
b) Then Click + CTRL (for non-adjacent worksheet tabs) or Click + Shift (for adjacent worksheets) on the other worksheet tabs to add it to the group.
c) Modify the cell as needed. Click on enter.
To ungroup your worksheets, you can right click and select Ungroup Sheets option. This may seem like a basic tip, but it’s a powerful one to have!