WEBVTT
Kind: captions
Language: en

00:00:08.059 --> 00:00:11.089 align:start position:0%
 
if<00:00:09.059><c> your</c><00:00:09.719><c> workbook</c><00:00:10.110><c> contains</c><00:00:10.320><c> multiple</c>

00:00:11.089 --> 00:00:11.099 align:start position:0%
if your workbook contains multiple
 

00:00:11.099 --> 00:00:12.919 align:start position:0%
if your workbook contains multiple
worksheets<00:00:11.519><c> there</c><00:00:12.059><c> may</c><00:00:12.210><c> be</c><00:00:12.240><c> a</c><00:00:12.360><c> time</c><00:00:12.660><c> when</c><00:00:12.840><c> you</c>

00:00:12.919 --> 00:00:12.929 align:start position:0%
worksheets there may be a time when you
 

00:00:12.929 --> 00:00:14.539 align:start position:0%
worksheets there may be a time when you
want<00:00:13.110><c> to</c><00:00:13.170><c> group</c><00:00:13.440><c> some</c><00:00:13.650><c> of</c><00:00:13.710><c> them</c><00:00:13.920><c> together</c><00:00:14.130><c> and</c>

00:00:14.539 --> 00:00:14.549 align:start position:0%
want to group some of them together and
 

00:00:14.549 --> 00:00:16.340 align:start position:0%
want to group some of them together and
take<00:00:14.910><c> advantage</c><00:00:15.210><c> of</c><00:00:15.509><c> the</c><00:00:15.570><c> fact</c><00:00:15.809><c> that</c><00:00:15.960><c> you</c><00:00:16.170><c> can</c>

00:00:16.340 --> 00:00:16.350 align:start position:0%
take advantage of the fact that you can
 

00:00:16.350 --> 00:00:18.109 align:start position:0%
take advantage of the fact that you can
edit<00:00:16.500><c> more</c><00:00:16.800><c> than</c><00:00:17.010><c> one</c><00:00:17.160><c> worksheet</c><00:00:17.580><c> at</c><00:00:17.760><c> a</c><00:00:17.789><c> time</c>

00:00:18.109 --> 00:00:18.119 align:start position:0%
edit more than one worksheet at a time
 

00:00:18.119 --> 00:00:20.269 align:start position:0%
edit more than one worksheet at a time
this<00:00:18.960><c> is</c><00:00:19.109><c> crucial</c><00:00:19.560><c> if</c><00:00:19.710><c> you're</c><00:00:19.859><c> working</c><00:00:20.160><c> with</c>

00:00:20.269 --> 00:00:20.279 align:start position:0%
this is crucial if you're working with
 

00:00:20.279 --> 00:00:22.730 align:start position:0%
this is crucial if you're working with
large<00:00:20.310><c> amounts</c><00:00:20.699><c> of</c><00:00:21.000><c> related</c><00:00:21.449><c> data</c><00:00:21.500><c> let's</c><00:00:22.500><c> take</c>

00:00:22.730 --> 00:00:22.740 align:start position:0%
large amounts of related data let's take
 

00:00:22.740 --> 00:00:25.279 align:start position:0%
large amounts of related data let's take
a<00:00:22.769><c> look</c><00:00:23.150><c> for</c><00:00:24.150><c> example</c><00:00:24.630><c> I'm</c><00:00:24.810><c> planning</c><00:00:25.170><c> on</c>

00:00:25.279 --> 00:00:25.289 align:start position:0%
a look for example I'm planning on
 

00:00:25.289 --> 00:00:27.830 align:start position:0%
a look for example I'm planning on
moving<00:00:25.500><c> in</c><00:00:25.920><c> the</c><00:00:26.039><c> month</c><00:00:26.220><c> of</c><00:00:26.340><c> September</c><00:00:26.599><c> my</c><00:00:27.599><c> rent</c>

00:00:27.830 --> 00:00:27.840 align:start position:0%
moving in the month of September my rent
 

00:00:27.840 --> 00:00:29.630 align:start position:0%
moving in the month of September my rent
is<00:00:27.990><c> going</c><00:00:28.199><c> to</c><00:00:28.289><c> go</c><00:00:28.410><c> up</c><00:00:28.590><c> and</c><00:00:28.800><c> I'm</c><00:00:29.010><c> canceling</c><00:00:29.250><c> my</c>

00:00:29.630 --> 00:00:29.640 align:start position:0%
is going to go up and I'm canceling my
 

00:00:29.640 --> 00:00:32.240 align:start position:0%
is going to go up and I'm canceling my
gym<00:00:29.880><c> membership</c><00:00:30.000><c> too</c><00:00:30.570><c> that</c><00:00:31.349><c> means</c><00:00:31.679><c> I</c><00:00:31.890><c> need</c><00:00:32.130><c> to</c>

00:00:32.240 --> 00:00:32.250 align:start position:0%
gym membership too that means I need to
 

00:00:32.250 --> 00:00:34.250 align:start position:0%
gym membership too that means I need to
update<00:00:32.430><c> this</c><00:00:32.759><c> worksheet</c><00:00:33.270><c> and</c><00:00:33.450><c> also</c><00:00:34.110><c> my</c>

00:00:34.250 --> 00:00:34.260 align:start position:0%
update this worksheet and also my
 

00:00:34.260 --> 00:00:35.840 align:start position:0%
update this worksheet and also my
worksheets<00:00:34.710><c> for</c><00:00:34.890><c> the</c><00:00:35.010><c> rest</c><00:00:35.190><c> of</c><00:00:35.340><c> the</c><00:00:35.430><c> year</c><00:00:35.700><c> I</c>

00:00:35.840 --> 00:00:35.850 align:start position:0%
worksheets for the rest of the year I
 

00:00:35.850 --> 00:00:38.389 align:start position:0%
worksheets for the rest of the year I
can<00:00:36.540><c> update</c><00:00:36.930><c> them</c><00:00:37.290><c> all</c><00:00:37.469><c> at</c><00:00:37.649><c> once</c><00:00:37.829><c> just</c><00:00:37.980><c> by</c>

00:00:38.389 --> 00:00:38.399 align:start position:0%
can update them all at once just by
 

00:00:38.399 --> 00:00:40.580 align:start position:0%
can update them all at once just by
grouping<00:00:38.790><c> them</c><00:00:38.969><c> start</c><00:00:39.840><c> by</c><00:00:39.989><c> selecting</c><00:00:40.469><c> the</c>

00:00:40.580 --> 00:00:40.590 align:start position:0%
grouping them start by selecting the
 

00:00:40.590 --> 00:00:42.709 align:start position:0%
grouping them start by selecting the
first<00:00:40.800><c> sheet</c><00:00:41.040><c> you</c><00:00:41.129><c> want</c><00:00:41.280><c> to</c><00:00:41.399><c> group</c><00:00:41.489><c> then</c><00:00:42.300><c> press</c>

00:00:42.709 --> 00:00:42.719 align:start position:0%
first sheet you want to group then press
 

00:00:42.719 --> 00:00:44.389 align:start position:0%
first sheet you want to group then press
and<00:00:42.930><c> hold</c><00:00:43.110><c> the</c><00:00:43.260><c> ctrl</c><00:00:43.620><c> key</c><00:00:43.649><c> on</c><00:00:43.860><c> your</c><00:00:44.160><c> keyboard</c>

00:00:44.389 --> 00:00:44.399 align:start position:0%
and hold the ctrl key on your keyboard
 

00:00:44.399 --> 00:00:49.310 align:start position:0%
and hold the ctrl key on your keyboard
while<00:00:44.850><c> you</c><00:00:44.879><c> select</c><00:00:45.120><c> the</c><00:00:45.390><c> rest</c><00:00:48.110><c> release</c><00:00:49.110><c> the</c>

00:00:49.310 --> 00:00:49.320 align:start position:0%
while you select the rest release the
 

00:00:49.320 --> 00:00:50.930 align:start position:0%
while you select the rest release the
ctrl<00:00:49.649><c> key</c><00:00:49.680><c> and</c><00:00:50.129><c> you'll</c><00:00:50.340><c> be</c><00:00:50.460><c> able</c><00:00:50.550><c> to</c><00:00:50.789><c> navigate</c>

00:00:50.930 --> 00:00:50.940 align:start position:0%
ctrl key and you'll be able to navigate
 

00:00:50.940 --> 00:00:53.479 align:start position:0%
ctrl key and you'll be able to navigate
and<00:00:51.270><c> make</c><00:00:51.539><c> changes</c><00:00:52.110><c> to</c><00:00:52.170><c> the</c><00:00:52.379><c> data</c><00:00:52.500><c> changes</c>

00:00:53.479 --> 00:00:53.489 align:start position:0%
and make changes to the data changes
 

00:00:53.489 --> 00:00:55.189 align:start position:0%
and make changes to the data changes
that<00:00:53.640><c> will</c><00:00:53.760><c> apply</c><00:00:54.030><c> to</c><00:00:54.090><c> all</c><00:00:54.329><c> of</c><00:00:54.539><c> the</c><00:00:54.780><c> worksheets</c>

00:00:55.189 --> 00:00:55.199 align:start position:0%
that will apply to all of the worksheets
 

00:00:55.199 --> 00:00:57.500 align:start position:0%
that will apply to all of the worksheets
in<00:00:55.379><c> the</c><00:00:55.469><c> group</c><00:00:55.680><c> let</c><00:00:56.550><c> me</c><00:00:56.670><c> show</c><00:00:56.850><c> you</c><00:00:56.910><c> what</c><00:00:57.180><c> I</c><00:00:57.210><c> mean</c>

00:00:57.500 --> 00:00:57.510 align:start position:0%
in the group let me show you what I mean
 

00:00:57.510 --> 00:01:01.119 align:start position:0%
in the group let me show you what I mean
if<00:00:58.170><c> I</c><00:00:58.379><c> update</c><00:00:58.770><c> the</c><00:00:58.920><c> rent</c><00:00:59.129><c> in</c><00:00:59.280><c> one</c><00:00:59.460><c> worksheet</c>

00:01:01.119 --> 00:01:01.129 align:start position:0%
if I update the rent in one worksheet
 

00:01:01.129 --> 00:01:05.530 align:start position:0%
if I update the rent in one worksheet
the<00:01:02.129><c> rest</c><00:01:02.399><c> of</c><00:01:02.609><c> the</c><00:01:02.699><c> group</c><00:01:02.879><c> gets</c><00:01:03.120><c> updated</c><00:01:03.510><c> too</c>

00:01:05.530 --> 00:01:05.540 align:start position:0%
the rest of the group gets updated too
 

00:01:05.540 --> 00:01:08.179 align:start position:0%
the rest of the group gets updated too
the<00:01:06.540><c> same</c><00:01:06.780><c> rule</c><00:01:07.020><c> applies</c><00:01:07.350><c> if</c><00:01:07.619><c> I</c><00:01:07.740><c> delete</c><00:01:08.070><c> the</c>

00:01:08.179 --> 00:01:08.189 align:start position:0%
the same rule applies if I delete the
 

00:01:08.189 --> 00:01:16.160 align:start position:0%
the same rule applies if I delete the
row<00:01:08.340><c> that</c><00:01:08.520><c> contains</c><00:01:08.670><c> my</c><00:01:09.180><c> gym</c><00:01:09.420><c> membership</c><00:01:15.170><c> to</c>

00:01:16.160 --> 00:01:16.170 align:start position:0%
row that contains my gym membership to
 

00:01:16.170 --> 00:01:18.020 align:start position:0%
row that contains my gym membership to
ungroup<00:01:16.530><c> just</c><00:01:17.159><c> right-click</c><00:01:17.700><c> one</c><00:01:17.880><c> of</c><00:01:17.939><c> the</c>

00:01:18.020 --> 00:01:18.030 align:start position:0%
ungroup just right-click one of the
 

00:01:18.030 --> 00:01:20.719 align:start position:0%
ungroup just right-click one of the
worksheets<00:01:18.150><c> and</c><00:01:18.750><c> select</c><00:01:19.259><c> ungroup</c><00:01:19.799><c> sheets</c><00:01:19.830><c> the</c>

00:01:20.719 --> 00:01:20.729 align:start position:0%
worksheets and select ungroup sheets the
 

00:01:20.729 --> 00:01:22.700 align:start position:0%
worksheets and select ungroup sheets the
alternative<00:01:21.330><c> to</c><00:01:21.450><c> that</c><00:01:21.600><c> is</c><00:01:21.840><c> to</c><00:01:22.020><c> click</c><00:01:22.380><c> any</c>

00:01:22.700 --> 00:01:22.710 align:start position:0%
alternative to that is to click any
 

00:01:22.710 --> 00:01:24.830 align:start position:0%
alternative to that is to click any
worksheet<00:01:23.159><c> outside</c><00:01:23.670><c> of</c><00:01:23.790><c> the</c><00:01:23.880><c> group</c><00:01:24.060><c> just</c><00:01:24.630><c> be</c>

00:01:24.830 --> 00:01:24.840 align:start position:0%
worksheet outside of the group just be
 

00:01:24.840 --> 00:01:26.770 align:start position:0%
worksheet outside of the group just be
careful<00:01:25.200><c> not</c><00:01:25.229><c> to</c><00:01:25.409><c> do</c><00:01:25.650><c> that</c><00:01:25.860><c> by</c><00:01:26.100><c> accident</c>

00:01:26.770 --> 00:01:26.780 align:start position:0%
careful not to do that by accident
 

00:01:26.780 --> 00:01:29.179 align:start position:0%
careful not to do that by accident
whether<00:01:27.780><c> you</c><00:01:27.990><c> have</c><00:01:28.170><c> a</c><00:01:28.200><c> few</c><00:01:28.500><c> worksheets</c><00:01:28.979><c> or</c>

00:01:29.179 --> 00:01:29.189 align:start position:0%
whether you have a few worksheets or
 

00:01:29.189 --> 00:01:31.100 align:start position:0%
whether you have a few worksheets or
many<00:01:29.520><c> many</c><00:01:29.790><c> more</c><00:01:30.030><c> grouping</c><00:01:30.659><c> gives</c><00:01:30.840><c> you</c><00:01:30.990><c> the</c>

00:01:31.100 --> 00:01:31.110 align:start position:0%
many many more grouping gives you the
 

00:01:31.110 --> 00:01:32.690 align:start position:0%
many many more grouping gives you the
flexibility<00:01:31.740><c> you</c><00:01:31.920><c> need</c><00:01:31.950><c> to</c><00:01:32.369><c> keep</c><00:01:32.520><c> your</c>

00:01:32.690 --> 00:01:32.700 align:start position:0%
flexibility you need to keep your
 

00:01:32.700 --> 00:01:37.310 align:start position:0%
flexibility you need to keep your
workbook<00:01:33.090><c> up</c><00:01:33.270><c> to</c><00:01:33.509><c> date</c><00:01:33.689><c> and</c><00:01:33.900><c> easy</c><00:01:34.530><c> to</c><00:01:34.740><c> edit</c>

00:01:37.310 --> 00:01:37.320 align:start position:0%
 
 

00:01:37.320 --> 00:01:41.280 align:start position:0%
 
like<00:01:38.320><c> that</c><00:01:38.500><c> you</c><00:01:38.650><c> just</c><00:01:38.680><c> saw</c><00:01:39.720><c> rated</c><00:01:40.720><c> at</c><00:01:41.230><c> a</c>

00:01:41.280 --> 00:01:41.290 align:start position:0%
like that you just saw rated at a
 

00:01:41.290 --> 00:01:44.100 align:start position:0%
like that you just saw rated at a
comment<00:01:41.620><c> subscribe</c><00:01:42.370><c> to</c><00:01:42.790><c> our</c><00:01:42.910><c> Channel</c>

00:01:44.100 --> 00:01:44.110 align:start position:0%
comment subscribe to our Channel
 

00:01:44.110 --> 00:01:48.450 align:start position:0%
comment subscribe to our Channel
the<00:01:44.350><c> freedom</c><00:01:44.830><c> to</c><00:01:44.860><c> learn</c><00:01:45.750><c> what</c><00:01:46.750><c> you</c><00:01:46.960><c> want</c><00:01:47.460><c> when</c>

00:01:48.450 --> 00:01:48.460 align:start position:0%
the freedom to learn what you want when
 

00:01:48.460 --> 00:01:56.610 align:start position:0%
the freedom to learn what you want when
you<00:01:48.670><c> want</c><00:01:49.890><c> absolutely</c><00:01:50.890><c> free</c><00:01:55.020><c> GCF</c><00:01:56.020><c> learn</c>

00:01:56.610 --> 00:01:56.620 align:start position:0%
you want absolutely free GCF learn
 

00:01:56.620 --> 00:01:58.650 align:start position:0%
you want absolutely free GCF learn
free.org