Tip:
Highlight text to annotate it
X
If your workbook contains multiple worksheets, there may be a time when you want to group
some of them together, and take advantage of the fact that you can edit more than one
worksheet at a time. This is crucial if you're working with large amounts of related data.
Let's take a look.
For example, I'm planning on moving in the month of September. My rent is going to go
up and I'm canceling my gym membership too. That means I need to update this worksheet,
and also my worksheets for the rest of the year.
I can update them all at once just by grouping them. Start by selecting the first sheet you
want to group, then press and hold the Ctrl key on your keyboard while you select the
rest. Release the Ctrl key, and you'll be able to navigate and make changes to the data
- changes that will apply to all of the worksheets in the group.
Let me show you what I mean. If I update the rent in one worksheet, the rest of the group
gets updated too. The same rule applies if I delete the row that contains my gym membership.
To ungroup, just right-click one of the worksheets, and select Ungroup Sheets. The alternative
to that is to click any worksheet outside of the group - just be careful not to do that
by accident.
Whether you have a few worksheets or many, many more, grouping gives you the flexibility
you need to keep your workbook up-to-date and easy to edit.