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
like that you just saw rated at a
comment subscribe to our Channel
the freedom to learn what you want when
you want absolutely free GCF learn
free.org