WEBVTT
Kind: captions
Language: en

00:00:09.440 --> 00:00:13.440
If your workbook contains multiple worksheets,
there may be a time when you want to group

00:00:13.440 --> 00:00:17.160
some of them together, and take advantage
of the fact that you can edit more than one

00:00:17.160 --> 00:00:18.950
worksheet at a time.

00:00:18.950 --> 00:00:22.460
This is crucial if you're working with large
amounts of related data.

00:00:22.460 --> 00:00:23.570
Let's take a look.

00:00:23.570 --> 00:00:27.550
For example, I'm planning on moving in the
month of September.

00:00:27.550 --> 00:00:31.439
My rent is going to go up and I'm canceling
my gym membership too.

00:00:31.439 --> 00:00:35.670
That means I need to update this worksheet,
and also my worksheets for the rest of the

00:00:35.670 --> 00:00:36.670
year.

00:00:36.670 --> 00:00:39.559
I can update them all at once just by grouping
them.

00:00:39.559 --> 00:00:43.899
Start by selecting the first sheet you want
to group, then press and hold the Ctrl key

00:00:43.899 --> 00:00:48.960
on your keyboard while you select the rest.

00:00:48.960 --> 00:00:53.429
Release the Ctrl key, and you'll be able to
navigate and make changes to the data - changes

00:00:53.429 --> 00:00:56.039
that will apply to all of the worksheets in
the group.

00:00:56.039 --> 00:00:58.229
Let me show you what I mean.

00:00:58.229 --> 00:01:06.500
If I update the rent in one worksheet, the
rest of the group gets updated too.

00:01:06.500 --> 00:01:16.110
The same rule applies if I delete the row
that contains my gym membership.

00:01:16.110 --> 00:01:20.710
To ungroup, just right-click one of the worksheets,
and select Ungroup Sheets.

00:01:20.710 --> 00:01:25.360
The alternative to that is to click any worksheet
outside of the group - just be careful not

00:01:25.360 --> 00:01:27.690
to do that by accident.

00:01:27.690 --> 00:01:31.750
Whether you have a few worksheets or many,
many more, grouping gives you the flexibility

00:01:31.750 --> 00:01:58.070
you need to keep your workbook up-to-date
and easy to edit.