WEBVTT
Kind: captions
Language: en

00:00:06.620 --> 00:00:10.580 align:start position:0%
 
so<00:00:07.620><c> far</c><00:00:08.130><c> I'm</c><00:00:08.580><c> only</c><00:00:09.030><c> using</c><00:00:09.480><c> one</c><00:00:09.900><c> worksheet</c><00:00:10.440><c> in</c>

00:00:10.580 --> 00:00:10.590 align:start position:0%
so far I'm only using one worksheet in
 

00:00:10.590 --> 00:00:13.669 align:start position:0%
so far I'm only using one worksheet in
my<00:00:10.710><c> workbook</c><00:00:11.190><c> my</c><00:00:12.120><c> inventory</c><00:00:12.509><c> is</c><00:00:12.960><c> only</c><00:00:13.200><c> for</c><00:00:13.500><c> one</c>

00:00:13.669 --> 00:00:13.679 align:start position:0%
my workbook my inventory is only for one
 

00:00:13.679 --> 00:00:17.390 align:start position:0%
my workbook my inventory is only for one
month<00:00:14.040><c> and</c><00:00:14.340><c> only</c><00:00:15.089><c> appears</c><00:00:15.509><c> on</c><00:00:15.780><c> one</c><00:00:15.809><c> sheet</c><00:00:16.440><c> but</c>

00:00:17.390 --> 00:00:17.400 align:start position:0%
month and only appears on one sheet but
 

00:00:17.400 --> 00:00:19.730 align:start position:0%
month and only appears on one sheet but
let's<00:00:17.640><c> take</c><00:00:17.940><c> a</c><00:00:17.970><c> look</c><00:00:18.300><c> at</c><00:00:18.449><c> how</c><00:00:18.720><c> you</c><00:00:18.779><c> can</c><00:00:19.170><c> use</c><00:00:19.380><c> the</c>

00:00:19.730 --> 00:00:19.740 align:start position:0%
let's take a look at how you can use the
 

00:00:19.740 --> 00:00:21.620 align:start position:0%
let's take a look at how you can use the
other<00:00:19.949><c> sheets</c><00:00:20.340><c> to</c><00:00:20.460><c> accomplish</c><00:00:21.000><c> your</c><00:00:21.119><c> goals</c><00:00:21.390><c> in</c>

00:00:21.620 --> 00:00:21.630 align:start position:0%
other sheets to accomplish your goals in
 

00:00:21.630 --> 00:00:26.420 align:start position:0%
other sheets to accomplish your goals in
Excel<00:00:23.060><c> by</c><00:00:24.060><c> default</c><00:00:24.689><c> three</c><00:00:25.500><c> sheets</c><00:00:25.890><c> appear</c>

00:00:26.420 --> 00:00:26.430 align:start position:0%
Excel by default three sheets appear
 

00:00:26.430 --> 00:00:30.259 align:start position:0%
Excel by default three sheets appear
when<00:00:26.789><c> you</c><00:00:26.910><c> create</c><00:00:27.269><c> a</c><00:00:27.510><c> new</c><00:00:27.539><c> workbook</c><00:00:27.960><c> if</c><00:00:29.269><c> you</c>

00:00:30.259 --> 00:00:30.269 align:start position:0%
when you create a new workbook if you
 

00:00:30.269 --> 00:00:32.600 align:start position:0%
when you create a new workbook if you
want<00:00:30.510><c> to</c><00:00:30.660><c> change</c><00:00:30.960><c> this</c><00:00:31.140><c> default</c><00:00:31.560><c> setting</c><00:00:31.679><c> you</c>

00:00:32.600 --> 00:00:32.610 align:start position:0%
want to change this default setting you
 

00:00:32.610 --> 00:00:35.600 align:start position:0%
want to change this default setting you
can<00:00:32.820><c> do</c><00:00:33.059><c> that</c><00:00:33.239><c> in</c><00:00:33.390><c> your</c><00:00:33.510><c> Excel</c><00:00:33.870><c> options</c><00:00:34.610><c> I'm</c>

00:00:35.600 --> 00:00:35.610 align:start position:0%
can do that in your Excel options I'm
 

00:00:35.610 --> 00:00:37.850 align:start position:0%
can do that in your Excel options I'm
going<00:00:36.149><c> to</c><00:00:36.270><c> leave</c><00:00:36.450><c> the</c><00:00:36.600><c> default</c><00:00:37.020><c> settings</c><00:00:37.110><c> set</c>

00:00:37.850 --> 00:00:37.860 align:start position:0%
going to leave the default settings set
 

00:00:37.860 --> 00:00:41.270 align:start position:0%
going to leave the default settings set
to<00:00:37.890><c> 3</c><00:00:38.370><c> for</c><00:00:38.579><c> right</c><00:00:38.760><c> now</c><00:00:38.969><c> I</c><00:00:39.290><c> can</c><00:00:40.290><c> add</c><00:00:40.620><c> new</c><00:00:40.649><c> sheets</c>

00:00:41.270 --> 00:00:41.280 align:start position:0%
to 3 for right now I can add new sheets
 

00:00:41.280 --> 00:00:45.350 align:start position:0%
to 3 for right now I can add new sheets
as<00:00:41.520><c> I</c><00:00:41.579><c> meet</c><00:00:42.270><c> them</c><00:00:42.480><c> I</c><00:00:43.579><c> would</c><00:00:44.579><c> like</c><00:00:44.610><c> to</c><00:00:44.910><c> name</c><00:00:45.090><c> this</c>

00:00:45.350 --> 00:00:45.360 align:start position:0%
as I meet them I would like to name this
 

00:00:45.360 --> 00:00:49.310 align:start position:0%
as I meet them I would like to name this
first<00:00:45.719><c> sheet</c><00:00:46.200><c> January</c><00:00:47.210><c> to</c><00:00:48.210><c> do</c><00:00:48.420><c> this</c><00:00:48.690><c> just</c>

00:00:49.310 --> 00:00:49.320 align:start position:0%
first sheet January to do this just
 

00:00:49.320 --> 00:00:52.970 align:start position:0%
first sheet January to do this just
right<00:00:49.530><c> click</c><00:00:50.070><c> the</c><00:00:50.370><c> sheet</c><00:00:50.610><c> tab</c><00:00:50.969><c> and</c><00:00:51.829><c> from</c><00:00:52.829><c> the</c>

00:00:52.970 --> 00:00:52.980 align:start position:0%
right click the sheet tab and from the
 

00:00:52.980 --> 00:00:58.119 align:start position:0%
right click the sheet tab and from the
menu<00:00:53.250><c> that</c><00:00:53.460><c> appears</c><00:00:54.079><c> choose</c><00:00:55.079><c> rename</c>

00:00:58.119 --> 00:00:58.129 align:start position:0%
 
 

00:00:58.129 --> 00:01:01.430 align:start position:0%
 
now<00:00:59.129><c> the</c><00:00:59.190><c> worksheets</c><00:01:00.120><c> appears</c><00:01:00.750><c> highlighted</c>

00:01:01.430 --> 00:01:01.440 align:start position:0%
now the worksheets appears highlighted
 

00:01:01.440 --> 00:01:06.910 align:start position:0%
now the worksheets appears highlighted
and<00:01:01.649><c> you</c><00:01:02.160><c> can</c><00:01:02.340><c> begin</c><00:01:02.460><c> typing</c><00:01:02.969><c> the</c><00:01:03.239><c> new</c><00:01:03.510><c> name</c><00:01:05.630><c> if</c>

00:01:06.910 --> 00:01:06.920 align:start position:0%
and you can begin typing the new name if
 

00:01:06.920 --> 00:01:11.240 align:start position:0%
and you can begin typing the new name if
I<00:01:07.920><c> want</c><00:01:08.220><c> to</c><00:01:08.430><c> rename</c><00:01:08.670><c> the</c><00:01:09.270><c> next</c><00:01:09.750><c> sheet</c><00:01:10.140><c> I</c><00:01:10.470><c> just</c>

00:01:11.240 --> 00:01:11.250 align:start position:0%
I want to rename the next sheet I just
 

00:01:11.250 --> 00:01:16.399 align:start position:0%
I want to rename the next sheet I just
select<00:01:11.640><c> it</c><00:01:11.850><c> and</c><00:01:12.090><c> do</c><00:01:12.659><c> the</c><00:01:12.810><c> same</c><00:01:13.020><c> thing</c><00:01:14.119><c> or</c><00:01:15.409><c> if</c>

00:01:16.399 --> 00:01:16.409 align:start position:0%
select it and do the same thing or if
 

00:01:16.409 --> 00:01:19.160 align:start position:0%
select it and do the same thing or if
you<00:01:16.680><c> prefer</c><00:01:17.040><c> to</c><00:01:17.070><c> use</c><00:01:17.430><c> the</c><00:01:17.610><c> ribbon</c><00:01:18.030><c> you</c><00:01:18.270><c> can</c>

00:01:19.160 --> 00:01:19.170 align:start position:0%
you prefer to use the ribbon you can
 

00:01:19.170 --> 00:01:21.170 align:start position:0%
you prefer to use the ribbon you can
click<00:01:19.380><c> the</c><00:01:19.530><c> format</c><00:01:19.979><c> commands</c><00:01:20.490><c> in</c><00:01:20.790><c> the</c><00:01:20.880><c> cells</c>

00:01:21.170 --> 00:01:21.180 align:start position:0%
click the format commands in the cells
 

00:01:21.180 --> 00:01:24.289 align:start position:0%
click the format commands in the cells
group<00:01:21.360><c> on</c><00:01:21.810><c> the</c><00:01:21.990><c> Home</c><00:01:22.200><c> tab</c><00:01:22.229><c> and</c><00:01:22.920><c> then</c><00:01:23.850><c> select</c>

00:01:24.289 --> 00:01:24.299 align:start position:0%
group on the Home tab and then select
 

00:01:24.299 --> 00:01:29.090 align:start position:0%
group on the Home tab and then select
rename<00:01:25.020><c> sheet</c><00:01:26.570><c> the</c><00:01:27.570><c> word</c><00:01:27.930><c> sheets</c><00:01:28.530><c> appears</c>

00:01:29.090 --> 00:01:29.100 align:start position:0%
rename sheet the word sheets appears
 

00:01:29.100 --> 00:01:31.819 align:start position:0%
rename sheet the word sheets appears
highlighted<00:01:29.820><c> and</c><00:01:30.000><c> you</c><00:01:30.750><c> can</c><00:01:30.900><c> begin</c><00:01:31.020><c> typing</c><00:01:31.560><c> the</c>

00:01:31.819 --> 00:01:31.829 align:start position:0%
highlighted and you can begin typing the
 

00:01:31.829 --> 00:01:39.109 align:start position:0%
highlighted and you can begin typing the
new<00:01:32.100><c> name</c><00:01:37.009><c> you</c><00:01:38.009><c> can</c><00:01:38.189><c> use</c><00:01:38.460><c> whichever</c><00:01:38.939><c> method</c>

00:01:39.109 --> 00:01:39.119 align:start position:0%
new name you can use whichever method
 

00:01:39.119 --> 00:01:42.380 align:start position:0%
new name you can use whichever method
you<00:01:39.479><c> prefer</c><00:01:39.860><c> personally</c><00:01:40.860><c> I</c><00:01:41.520><c> use</c><00:01:41.970><c> the</c><00:01:42.150><c> first</c>

00:01:42.380 --> 00:01:42.390 align:start position:0%
you prefer personally I use the first
 

00:01:42.390 --> 00:01:44.600 align:start position:0%
you prefer personally I use the first
way<00:01:42.659><c> I</c><00:01:42.689><c> showed</c><00:01:42.840><c> you</c><00:01:43.140><c> I</c><00:01:43.590><c> think</c><00:01:44.009><c> it's</c><00:01:44.369><c> a</c><00:01:44.460><c> bit</c>

00:01:44.600 --> 00:01:44.610 align:start position:0%
way I showed you I think it's a bit
 

00:01:44.610 --> 00:01:46.910 align:start position:0%
way I showed you I think it's a bit
faster<00:01:45.149><c> for</c><00:01:45.329><c> me</c><00:01:45.390><c> but</c><00:01:46.020><c> you'll</c><00:01:46.409><c> learn</c><00:01:46.649><c> what</c>

00:01:46.910 --> 00:01:46.920 align:start position:0%
faster for me but you'll learn what
 

00:01:46.920 --> 00:01:51.200 align:start position:0%
faster for me but you'll learn what
works<00:01:47.130><c> for</c><00:01:47.220><c> you</c><00:01:49.009><c> since</c><00:01:50.009><c> my</c><00:01:50.189><c> default</c><00:01:50.670><c> sheet</c>

00:01:51.200 --> 00:01:51.210 align:start position:0%
works for you since my default sheet
 

00:01:51.210 --> 00:01:54.020 align:start position:0%
works for you since my default sheet
setting<00:01:51.600><c> is</c><00:01:51.720><c> 3</c><00:01:52.079><c> I</c><00:01:52.290><c> need</c><00:01:52.860><c> to</c><00:01:53.009><c> add</c><00:01:53.189><c> more</c><00:01:53.579><c> sheets</c>

00:01:54.020 --> 00:01:54.030 align:start position:0%
setting is 3 I need to add more sheets
 

00:01:54.030 --> 00:01:56.090 align:start position:0%
setting is 3 I need to add more sheets
so<00:01:54.479><c> that</c><00:01:54.509><c> I</c><00:01:54.659><c> can</c><00:01:54.930><c> list</c><00:01:55.140><c> my</c><00:01:55.290><c> inventory</c><00:01:55.619><c> each</c>

00:01:56.090 --> 00:01:56.100 align:start position:0%
so that I can list my inventory each
 

00:01:56.100 --> 00:02:00.050 align:start position:0%
so that I can list my inventory each
month<00:01:56.549><c> to</c><00:01:57.509><c> add</c><00:01:57.689><c> a</c><00:01:57.990><c> new</c><00:01:58.200><c> sheet</c><00:01:58.530><c> left</c><00:01:59.369><c> click</c><00:01:59.820><c> the</c>

00:02:00.050 --> 00:02:00.060 align:start position:0%
month to add a new sheet left click the
 

00:02:00.060 --> 00:02:02.959 align:start position:0%
month to add a new sheet left click the
insert<00:02:00.509><c> worksheet</c><00:02:00.840><c> icon</c><00:02:01.560><c> and</c><00:02:01.950><c> a</c><00:02:02.490><c> new</c><00:02:02.700><c> sheet</c>

00:02:02.959 --> 00:02:02.969 align:start position:0%
insert worksheet icon and a new sheet
 

00:02:02.969 --> 00:02:05.899 align:start position:0%
insert worksheet icon and a new sheet
will<00:02:03.000><c> appear</c><00:02:03.439><c> I'll</c><00:02:04.439><c> do</c><00:02:04.950><c> this</c><00:02:05.189><c> several</c><00:02:05.729><c> more</c>

00:02:05.899 --> 00:02:05.909 align:start position:0%
will appear I'll do this several more
 

00:02:05.909 --> 00:02:08.979 align:start position:0%
will appear I'll do this several more
times<00:02:06.210><c> so</c><00:02:06.780><c> now</c><00:02:07.500><c> we'll</c><00:02:07.740><c> have</c><00:02:07.829><c> enough</c><00:02:08.190><c> sheets</c><00:02:08.550><c> if</c>

00:02:08.979 --> 00:02:08.989 align:start position:0%
times so now we'll have enough sheets if
 

00:02:08.989 --> 00:02:10.940 align:start position:0%
times so now we'll have enough sheets if
you'd<00:02:09.989><c> prefer</c><00:02:10.170><c> to</c><00:02:10.619><c> use</c><00:02:10.800><c> the</c><00:02:10.920><c> keyboard</c>

00:02:10.940 --> 00:02:10.950 align:start position:0%
you'd prefer to use the keyboard
 

00:02:10.950 --> 00:02:13.700 align:start position:0%
you'd prefer to use the keyboard
shortcut<00:02:11.940><c> just</c><00:02:12.569><c> press</c><00:02:12.930><c> the</c><00:02:13.140><c> shift</c>

00:02:13.700 --> 00:02:13.710 align:start position:0%
shortcut just press the shift
 

00:02:13.710 --> 00:02:18.170 align:start position:0%
shortcut just press the shift
eeee and<00:02:14.120><c> the</c><00:02:15.120><c> function</c><00:02:15.720><c> 11</c><00:02:16.500><c> or</c><00:02:16.740><c> f11</c><00:02:17.640><c> key</c><00:02:17.850><c> at</c>

00:02:18.170 --> 00:02:18.180 align:start position:0%
eeee and the function 11 or f11 key at
 

00:02:18.180 --> 00:02:22.400 align:start position:0%
eeee and the function 11 or f11 key at
the<00:02:18.600><c> top</c><00:02:18.840><c> of</c><00:02:18.960><c> your</c><00:02:18.990><c> keyboard</c><00:02:19.700><c> if</c><00:02:21.170><c> you</c><00:02:22.170><c> do</c>

00:02:22.400 --> 00:02:22.410 align:start position:0%
the top of your keyboard if you do
 

00:02:22.410 --> 00:02:25.250 align:start position:0%
the top of your keyboard if you do
decide<00:02:22.650><c> you</c><00:02:23.070><c> want</c><00:02:23.250><c> to</c><00:02:23.340><c> delete</c><00:02:23.610><c> a</c><00:02:23.670><c> sheet</c><00:02:24.260><c> just</c>

00:02:25.250 --> 00:02:25.260 align:start position:0%
decide you want to delete a sheet just
 

00:02:25.260 --> 00:02:28.930 align:start position:0%
decide you want to delete a sheet just
right-click<00:02:26.130><c> the</c><00:02:26.400><c> sheet</c><00:02:26.670><c> and</c><00:02:27.410><c> select</c><00:02:28.410><c> delete</c>

00:02:28.930 --> 00:02:28.940 align:start position:0%
right-click the sheet and select delete
 

00:02:28.940 --> 00:02:32.600 align:start position:0%
right-click the sheet and select delete
or<00:02:29.990><c> if</c><00:02:30.990><c> you</c><00:02:31.260><c> like</c><00:02:31.470><c> using</c><00:02:31.860><c> the</c><00:02:31.950><c> ribbon</c><00:02:32.160><c> commands</c>

00:02:32.600 --> 00:02:32.610 align:start position:0%
or if you like using the ribbon commands
 

00:02:32.610 --> 00:02:34.820 align:start position:0%
or if you like using the ribbon commands
just<00:02:33.180><c> select</c><00:02:33.630><c> the</c><00:02:33.960><c> sheets</c><00:02:34.230><c> you</c><00:02:34.410><c> want</c><00:02:34.710><c> to</c>

00:02:34.820 --> 00:02:34.830 align:start position:0%
just select the sheets you want to
 

00:02:34.830 --> 00:02:37.430 align:start position:0%
just select the sheets you want to
remove<00:02:35.160><c> and</c><00:02:35.550><c> click</c><00:02:36.390><c> the</c><00:02:36.570><c> drop</c><00:02:36.840><c> down</c><00:02:37.110><c> arrow</c>

00:02:37.430 --> 00:02:37.440 align:start position:0%
remove and click the drop down arrow
 

00:02:37.440 --> 00:02:40.010 align:start position:0%
remove and click the drop down arrow
next<00:02:37.650><c> to</c><00:02:38.220><c> delete</c><00:02:38.670><c> in</c><00:02:38.880><c> the</c><00:02:39.000><c> cells</c><00:02:39.300><c> group</c><00:02:39.420><c> on</c><00:02:39.900><c> the</c>

00:02:40.010 --> 00:02:40.020 align:start position:0%
next to delete in the cells group on the
 

00:02:40.020 --> 00:02:42.950 align:start position:0%
next to delete in the cells group on the
Home<00:02:40.230><c> tab</c><00:02:41.030><c> from</c><00:02:42.030><c> the</c><00:02:42.090><c> menu</c><00:02:42.690><c> that</c><00:02:42.720><c> appears</c>

00:02:42.950 --> 00:02:42.960 align:start position:0%
Home tab from the menu that appears
 

00:02:42.960 --> 00:02:52.010 align:start position:0%
Home tab from the menu that appears
select<00:02:43.850><c> delete</c><00:02:44.850><c> sheet</c><00:02:49.610><c> ok</c><00:02:50.610><c> now</c><00:02:51.360><c> you</c><00:02:51.420><c> know</c><00:02:51.780><c> how</c>

00:02:52.010 --> 00:02:52.020 align:start position:0%
select delete sheet ok now you know how
 

00:02:52.020 --> 00:02:55.970 align:start position:0%
select delete sheet ok now you know how
to<00:02:52.080><c> rename</c><00:02:52.620><c> add</c><00:02:53.010><c> and</c><00:02:53.790><c> delete</c><00:02:54.120><c> sheets</c><00:02:54.980><c> let's</c>

00:02:55.970 --> 00:02:55.980 align:start position:0%
to rename add and delete sheets let's
 

00:02:55.980 --> 00:02:58.070 align:start position:0%
to rename add and delete sheets let's
actually<00:02:56.280><c> go</c><00:02:56.670><c> ahead</c><00:02:57.000><c> and</c><00:02:57.150><c> rename</c><00:02:57.360><c> these</c><00:02:57.840><c> two</c>

00:02:58.070 --> 00:02:58.080 align:start position:0%
actually go ahead and rename these two
 

00:02:58.080 --> 00:03:08.780 align:start position:0%
actually go ahead and rename these two
sheets<00:03:06.140><c> we</c><00:03:07.140><c> can</c><00:03:07.320><c> add</c><00:03:07.530><c> the</c><00:03:07.710><c> rest</c><00:03:07.740><c> of</c><00:03:08.310><c> the</c><00:03:08.400><c> months</c>

00:03:08.780 --> 00:03:08.790 align:start position:0%
sheets we can add the rest of the months
 

00:03:08.790 --> 00:03:12.830 align:start position:0%
sheets we can add the rest of the months
later<00:03:09.240><c> on</c><00:03:09.770><c> my</c><00:03:10.770><c> January</c><00:03:11.160><c> sheets</c><00:03:11.880><c> I</c><00:03:12.150><c> have</c><00:03:12.540><c> all</c><00:03:12.810><c> my</c>

00:03:12.830 --> 00:03:12.840 align:start position:0%
later on my January sheets I have all my
 

00:03:12.840 --> 00:03:15.710 align:start position:0%
later on my January sheets I have all my
inventory<00:03:13.800><c> information</c><00:03:13.920><c> for</c><00:03:14.550><c> that</c><00:03:14.580><c> month</c><00:03:15.120><c> but</c>

00:03:15.710 --> 00:03:15.720 align:start position:0%
inventory information for that month but
 

00:03:15.720 --> 00:03:18.680 align:start position:0%
inventory information for that month but
all<00:03:15.750><c> my</c><00:03:16.110><c> other</c><00:03:16.320><c> sheets</c><00:03:16.890><c> are</c><00:03:17.070><c> blank</c><00:03:17.430><c> I</c><00:03:17.790><c> want</c><00:03:18.510><c> to</c>

00:03:18.680 --> 00:03:18.690 align:start position:0%
all my other sheets are blank I want to
 

00:03:18.690 --> 00:03:21.320 align:start position:0%
all my other sheets are blank I want to
copy<00:03:18.930><c> all</c><00:03:19.350><c> this</c><00:03:19.710><c> information</c><00:03:20.430><c> to</c><00:03:20.580><c> my</c><00:03:20.700><c> February</c>

00:03:21.320 --> 00:03:21.330 align:start position:0%
copy all this information to my February
 

00:03:21.330 --> 00:03:25.480 align:start position:0%
copy all this information to my February
sheets<00:03:21.690><c> I</c><00:03:22.020><c> can</c><00:03:22.890><c> do</c><00:03:23.190><c> that</c><00:03:23.370><c> by</c><00:03:23.580><c> selecting</c><00:03:23.850><c> it</c><00:03:24.300><c> all</c>

00:03:25.480 --> 00:03:25.490 align:start position:0%
sheets I can do that by selecting it all
 

00:03:25.490 --> 00:03:29.180 align:start position:0%
sheets I can do that by selecting it all
selecting<00:03:26.490><c> the</c><00:03:26.640><c> copy</c><00:03:26.910><c> command</c><00:03:27.240><c> and</c><00:03:27.930><c> then</c><00:03:28.830><c> left</c>

00:03:29.180 --> 00:03:29.190 align:start position:0%
selecting the copy command and then left
 

00:03:29.190 --> 00:03:31.400 align:start position:0%
selecting the copy command and then left
clicking<00:03:29.490><c> the</c><00:03:29.730><c> February</c><00:03:30.270><c> sheet</c><00:03:30.630><c> to</c><00:03:30.810><c> select</c><00:03:31.170><c> it</c>

00:03:31.400 --> 00:03:31.410 align:start position:0%
clicking the February sheet to select it
 

00:03:31.410 --> 00:03:35.270 align:start position:0%
clicking the February sheet to select it
now<00:03:32.420><c> I</c><00:03:33.420><c> can</c><00:03:33.810><c> click</c><00:03:34.020><c> the</c><00:03:34.170><c> paste</c><00:03:34.440><c> command</c><00:03:34.740><c> and</c>

00:03:35.270 --> 00:03:35.280 align:start position:0%
now I can click the paste command and
 

00:03:35.280 --> 00:03:38.960 align:start position:0%
now I can click the paste command and
select<00:03:35.430><c> paste</c><00:03:36.120><c> from</c><00:03:36.570><c> the</c><00:03:36.750><c> list</c><00:03:36.990><c> and</c><00:03:37.790><c> all</c><00:03:38.790><c> the</c>

00:03:38.960 --> 00:03:38.970 align:start position:0%
select paste from the list and all the
 

00:03:38.970 --> 00:03:43.310 align:start position:0%
select paste from the list and all the
info<00:03:39.300><c> appears</c><00:03:39.660><c> on</c><00:03:39.840><c> the</c><00:03:39.930><c> sheet</c><00:03:41.810><c> this</c><00:03:42.810><c> is</c><00:03:43.020><c> a</c><00:03:43.050><c> lot</c>

00:03:43.310 --> 00:03:43.320 align:start position:0%
info appears on the sheet this is a lot
 

00:03:43.320 --> 00:03:44.930 align:start position:0%
info appears on the sheet this is a lot
easier<00:03:43.530><c> to</c><00:03:43.980><c> do</c><00:03:44.190><c> than</c><00:03:44.220><c> typing</c><00:03:44.820><c> this</c>

00:03:44.930 --> 00:03:44.940 align:start position:0%
easier to do than typing this
 

00:03:44.940 --> 00:03:47.600 align:start position:0%
easier to do than typing this
information<00:03:45.630><c> into</c><00:03:45.870><c> the</c><00:03:45.990><c> sheets</c><00:03:46.290><c> but</c><00:03:46.980><c> copying</c>

00:03:47.600 --> 00:03:47.610 align:start position:0%
information into the sheets but copying
 

00:03:47.610 --> 00:03:49.610 align:start position:0%
information into the sheets but copying
and<00:03:47.760><c> pasting</c><00:03:47.940><c> into</c><00:03:48.270><c> multiple</c><00:03:48.900><c> sheets</c><00:03:48.930><c> can</c><00:03:49.470><c> be</c>

00:03:49.610 --> 00:03:49.620 align:start position:0%
and pasting into multiple sheets can be
 

00:03:49.620 --> 00:03:52.130 align:start position:0%
and pasting into multiple sheets can be
time-consuming<00:03:49.890><c> also</c><00:03:50.810><c> this</c><00:03:51.810><c> is</c><00:03:52.020><c> where</c>

00:03:52.130 --> 00:03:52.140 align:start position:0%
time-consuming also this is where
 

00:03:52.140 --> 00:03:56.710 align:start position:0%
time-consuming also this is where
grouping<00:03:52.830><c> comes</c><00:03:53.100><c> in</c>

00:03:56.710 --> 00:03:56.720 align:start position:0%
 
 

00:03:56.720 --> 00:04:00.230 align:start position:0%
 
before<00:03:57.720><c> I</c><00:03:57.750><c> group</c><00:03:58.290><c> my</c><00:03:58.590><c> sheets</c><00:03:58.950><c> I</c><00:03:59.310><c> need</c><00:03:59.820><c> to</c><00:04:00.000><c> copy</c>

00:04:00.230 --> 00:04:00.240 align:start position:0%
before I group my sheets I need to copy
 

00:04:00.240 --> 00:04:02.180 align:start position:0%
before I group my sheets I need to copy
the<00:04:00.540><c> information</c><00:04:01.080><c> I</c><00:04:01.170><c> want</c><00:04:01.410><c> to</c><00:04:01.470><c> paste</c><00:04:01.770><c> I</c>

00:04:02.180 --> 00:04:02.190 align:start position:0%
the information I want to paste I
 

00:04:02.190 --> 00:04:04.850 align:start position:0%
the information I want to paste I
actually<00:04:02.820><c> just</c><00:04:03.390><c> want</c><00:04:03.750><c> to</c><00:04:03.900><c> paste</c><00:04:04.200><c> my</c><00:04:04.350><c> heading</c>

00:04:04.850 --> 00:04:04.860 align:start position:0%
actually just want to paste my heading
 

00:04:04.860 --> 00:04:07.190 align:start position:0%
actually just want to paste my heading
in<00:04:04.980><c> categories</c><00:04:05.580><c> to</c><00:04:05.700><c> the</c><00:04:05.790><c> remaining</c><00:04:06.180><c> months</c><00:04:06.450><c> so</c>

00:04:07.190 --> 00:04:07.200 align:start position:0%
in categories to the remaining months so
 

00:04:07.200 --> 00:04:09.200 align:start position:0%
in categories to the remaining months so
I<00:04:07.230><c> need</c><00:04:07.470><c> to</c><00:04:07.620><c> select</c><00:04:07.800><c> this</c><00:04:08.250><c> information</c><00:04:08.970><c> and</c>

00:04:09.200 --> 00:04:09.210 align:start position:0%
I need to select this information and
 

00:04:09.210 --> 00:04:13.250 align:start position:0%
I need to select this information and
click<00:04:09.420><c> the</c><00:04:09.570><c> copy</c><00:04:09.750><c> command</c><00:04:11.750><c> now</c><00:04:12.750><c> we're</c><00:04:13.050><c> ready</c>

00:04:13.250 --> 00:04:13.260 align:start position:0%
click the copy command now we're ready
 

00:04:13.260 --> 00:04:17.240 align:start position:0%
click the copy command now we're ready
to<00:04:13.320><c> group</c><00:04:14.120><c> 2</c><00:04:15.120><c> group</c><00:04:15.150><c> contiguous</c><00:04:16.140><c> sheets</c><00:04:16.290><c> or</c>

00:04:17.240 --> 00:04:17.250 align:start position:0%
to group 2 group contiguous sheets or
 

00:04:17.250 --> 00:04:19.970 align:start position:0%
to group 2 group contiguous sheets or
sheets<00:04:17.670><c> are</c><00:04:17.880><c> all</c><00:04:18.090><c> in</c><00:04:18.209><c> a</c><00:04:18.299><c> row</c><00:04:18.510><c> click</c><00:04:19.470><c> the</c><00:04:19.650><c> first</c>

00:04:19.970 --> 00:04:19.980 align:start position:0%
sheets are all in a row click the first
 

00:04:19.980 --> 00:04:23.810 align:start position:0%
sheets are all in a row click the first
sheet<00:04:20.430><c> once</c><00:04:20.760><c> a</c><00:04:20.910><c> group</c><00:04:21.830><c> then</c><00:04:22.830><c> press</c><00:04:23.340><c> and</c><00:04:23.580><c> hold</c>

00:04:23.810 --> 00:04:23.820 align:start position:0%
sheet once a group then press and hold
 

00:04:23.820 --> 00:04:27.740 align:start position:0%
sheet once a group then press and hold
the<00:04:24.090><c> shift</c><00:04:24.300><c> key</c><00:04:24.480><c> on</c><00:04:24.690><c> your</c><00:04:25.050><c> keyboard</c><00:04:26.330><c> now</c><00:04:27.330><c> click</c>

00:04:27.740 --> 00:04:27.750 align:start position:0%
the shift key on your keyboard now click
 

00:04:27.750 --> 00:04:31.520 align:start position:0%
the shift key on your keyboard now click
the<00:04:27.900><c> last</c><00:04:28.290><c> sheet</c><00:04:28.890><c> you</c><00:04:29.010><c> want</c><00:04:29.190><c> to</c><00:04:29.340><c> group</c><00:04:30.500><c> you</c><00:04:31.500><c> see</c>

00:04:31.520 --> 00:04:31.530 align:start position:0%
the last sheet you want to group you see
 

00:04:31.530 --> 00:04:34.610 align:start position:0%
the last sheet you want to group you see
how<00:04:31.920><c> March</c><00:04:32.340><c> April</c><00:04:32.670><c> and</c><00:04:33.180><c> May</c><00:04:33.390><c> all</c><00:04:33.750><c> change</c><00:04:34.230><c> color</c>

00:04:34.610 --> 00:04:34.620 align:start position:0%
how March April and May all change color
 

00:04:34.620 --> 00:04:37.640 align:start position:0%
how March April and May all change color
and<00:04:35.010><c> now</c><00:04:35.340><c> the</c><00:04:35.400><c> sheet</c><00:04:35.730><c> tabs</c><00:04:36.030><c> are</c><00:04:36.210><c> white</c><00:04:36.650><c> well</c>

00:04:37.640 --> 00:04:37.650 align:start position:0%
and now the sheet tabs are white well
 

00:04:37.650 --> 00:04:40.360 align:start position:0%
and now the sheet tabs are white well
these<00:04:37.920><c> sheets</c><00:04:38.310><c> are</c><00:04:38.550><c> now</c><00:04:38.790><c> grouped</c><00:04:39.240><c> together</c>

00:04:40.360 --> 00:04:40.370 align:start position:0%
these sheets are now grouped together
 

00:04:40.370 --> 00:04:42.470 align:start position:0%
these sheets are now grouped together
select<00:04:41.370><c> the</c><00:04:41.490><c> cell</c><00:04:41.790><c> where</c><00:04:42.030><c> you</c><00:04:42.060><c> want</c><00:04:42.180><c> the</c>

00:04:42.470 --> 00:04:42.480 align:start position:0%
select the cell where you want the
 

00:04:42.480 --> 00:04:46.730 align:start position:0%
select the cell where you want the
information<00:04:42.780><c> to</c><00:04:43.200><c> start</c><00:04:44.900><c> now</c><00:04:45.900><c> click</c><00:04:46.320><c> the</c><00:04:46.500><c> paste</c>

00:04:46.730 --> 00:04:46.740 align:start position:0%
information to start now click the paste
 

00:04:46.740 --> 00:04:52.430 align:start position:0%
information to start now click the paste
command<00:04:47.130><c> and</c><00:04:48.530><c> the</c><00:04:49.530><c> information</c><00:04:50.010><c> appears</c><00:04:51.440><c> but</c>

00:04:52.430 --> 00:04:52.440 align:start position:0%
command and the information appears but
 

00:04:52.440 --> 00:04:54.980 align:start position:0%
command and the information appears but
instead<00:04:52.920><c> of</c><00:04:53.130><c> pasting</c><00:04:53.580><c> it</c><00:04:53.730><c> to</c><00:04:53.940><c> just</c><00:04:54.270><c> one</c><00:04:54.570><c> sheet</c>

00:04:54.980 --> 00:04:54.990 align:start position:0%
instead of pasting it to just one sheet
 

00:04:54.990 --> 00:05:01.040 align:start position:0%
instead of pasting it to just one sheet
it<00:04:55.880><c> appears</c><00:04:56.880><c> on</c><00:04:57.090><c> all</c><00:04:57.240><c> three</c><00:04:57.660><c> sheets</c><00:04:59.840><c> we</c><00:05:00.840><c> can</c>

00:05:01.040 --> 00:05:01.050 align:start position:0%
it appears on all three sheets we can
 

00:05:01.050 --> 00:05:03.410 align:start position:0%
it appears on all three sheets we can
also<00:05:01.320><c> make</c><00:05:01.800><c> formatting</c><00:05:02.490><c> changes</c><00:05:03.000><c> when</c><00:05:03.150><c> sheets</c>

00:05:03.410 --> 00:05:03.420 align:start position:0%
also make formatting changes when sheets
 

00:05:03.420 --> 00:05:06.460 align:start position:0%
also make formatting changes when sheets
are<00:05:03.600><c> grouped</c><00:05:03.900><c> for</c><00:05:04.620><c> example</c><00:05:05.220><c> I</c><00:05:05.430><c> want</c><00:05:06.000><c> to</c><00:05:06.090><c> add</c>

00:05:06.460 --> 00:05:06.470 align:start position:0%
are grouped for example I want to add
 

00:05:06.470 --> 00:05:09.980 align:start position:0%
are grouped for example I want to add
2008<00:05:07.470><c> to</c><00:05:07.710><c> the</c><00:05:07.830><c> beginning</c><00:05:08.220><c> of</c><00:05:08.400><c> my</c><00:05:08.460><c> title</c><00:05:09.060><c> if</c><00:05:09.240><c> we</c>

00:05:09.980 --> 00:05:09.990 align:start position:0%
2008 to the beginning of my title if we
 

00:05:09.990 --> 00:05:12.740 align:start position:0%
2008 to the beginning of my title if we
do<00:05:10.140><c> it</c><00:05:10.290><c> once</c><00:05:10.620><c> the</c><00:05:11.430><c> change</c><00:05:11.730><c> will</c><00:05:11.970><c> appear</c><00:05:12.300><c> on</c><00:05:12.330><c> all</c>

00:05:12.740 --> 00:05:12.750 align:start position:0%
do it once the change will appear on all
 

00:05:12.750 --> 00:05:17.600 align:start position:0%
do it once the change will appear on all
three<00:05:13.290><c> sheets</c><00:05:13.680><c> that</c><00:05:13.890><c> are</c><00:05:14.040><c> grouped</c><00:05:15.680><c> it</c><00:05:16.680><c> looks</c>

00:05:17.600 --> 00:05:17.610 align:start position:0%
three sheets that are grouped it looks
 

00:05:17.610 --> 00:05:19.340 align:start position:0%
three sheets that are grouped it looks
like<00:05:17.820><c> I</c><00:05:17.970><c> need</c><00:05:18.150><c> to</c><00:05:18.180><c> change</c><00:05:18.600><c> the</c><00:05:18.810><c> width</c><00:05:19.080><c> of</c><00:05:19.290><c> my</c>

00:05:19.340 --> 00:05:19.350 align:start position:0%
like I need to change the width of my
 

00:05:19.350 --> 00:05:25.350 align:start position:0%
like I need to change the width of my
columns<00:05:19.950><c> as</c><00:05:20.130><c> well</c>

00:05:25.350 --> 00:05:25.360 align:start position:0%
 
 

00:05:25.360 --> 00:05:28.900 align:start position:0%
 
that<00:05:26.360><c> looks</c><00:05:26.600><c> a</c><00:05:26.750><c> lot</c><00:05:27.020><c> neater</c><00:05:27.410><c> as</c><00:05:27.800><c> you</c><00:05:28.490><c> can</c><00:05:28.640><c> see</c>

00:05:28.900 --> 00:05:28.910 align:start position:0%
that looks a lot neater as you can see
 

00:05:28.910 --> 00:05:31.300 align:start position:0%
that looks a lot neater as you can see
the<00:05:29.240><c> tabs</c><00:05:29.540><c> are</c><00:05:29.780><c> still</c><00:05:29.990><c> white</c><00:05:30.320><c> which</c><00:05:30.770><c> indicates</c>

00:05:31.300 --> 00:05:31.310 align:start position:0%
the tabs are still white which indicates
 

00:05:31.310 --> 00:05:33.460 align:start position:0%
the tabs are still white which indicates
they<00:05:31.460><c> are</c><00:05:31.580><c> all</c><00:05:31.730><c> grouped</c><00:05:32.150><c> to</c><00:05:32.900><c> ungroup</c><00:05:33.440><c> sheets</c>

00:05:33.460 --> 00:05:33.470 align:start position:0%
they are all grouped to ungroup sheets
 

00:05:33.470 --> 00:05:36.990 align:start position:0%
they are all grouped to ungroup sheets
just<00:05:34.340><c> right-click</c><00:05:35.210><c> one</c><00:05:35.720><c> of</c><00:05:35.780><c> the</c><00:05:35.870><c> sheets</c><00:05:36.290><c> and</c>

00:05:36.990 --> 00:05:37.000 align:start position:0%
just right-click one of the sheets and
 

00:05:37.000 --> 00:05:42.610 align:start position:0%
just right-click one of the sheets and
select<00:05:38.000><c> ungroup'</c><00:05:38.270><c> from</c><00:05:39.110><c> the</c><00:05:39.200><c> list</c><00:05:41.500><c> before</c><00:05:42.500><c> we</c>

00:05:42.610 --> 00:05:42.620 align:start position:0%
select ungroup' from the list before we
 

00:05:42.620 --> 00:05:44.470 align:start position:0%
select ungroup' from the list before we
finish<00:05:42.920><c> talking</c><00:05:43.370><c> about</c><00:05:43.580><c> grouping</c><00:05:44.060><c> let</c><00:05:44.330><c> me</c>

00:05:44.470 --> 00:05:44.480 align:start position:0%
finish talking about grouping let me
 

00:05:44.480 --> 00:05:47.890 align:start position:0%
finish talking about grouping let me
show<00:05:44.690><c> you</c><00:05:44.750><c> one</c><00:05:45.110><c> other</c><00:05:45.290><c> way</c><00:05:45.560><c> to</c><00:05:45.620><c> group</c><00:05:46.750><c> what</c><00:05:47.750><c> if</c>

00:05:47.890 --> 00:05:47.900 align:start position:0%
show you one other way to group what if
 

00:05:47.900 --> 00:05:50.410 align:start position:0%
show you one other way to group what if
I<00:05:48.020><c> want</c><00:05:48.290><c> to</c><00:05:48.350><c> make</c><00:05:48.590><c> a</c><00:05:48.620><c> change</c><00:05:49.040><c> only</c><00:05:49.460><c> to</c><00:05:49.670><c> two</c><00:05:50.150><c> or</c>

00:05:50.410 --> 00:05:50.420 align:start position:0%
I want to make a change only to two or
 

00:05:50.420 --> 00:05:52.420 align:start position:0%
I want to make a change only to two or
three<00:05:50.780><c> sheets</c><00:05:51.170><c> and</c><00:05:51.410><c> they</c><00:05:51.920><c> aren't</c>

00:05:52.420 --> 00:05:52.430 align:start position:0%
three sheets and they aren't
 

00:05:52.430 --> 00:05:55.450 align:start position:0%
three sheets and they aren't
side-by-side<00:05:53.420><c> you</c><00:05:53.870><c> can</c><00:05:54.560><c> do</c><00:05:54.920><c> this</c><00:05:55.100><c> using</c><00:05:55.310><c> the</c>

00:05:55.450 --> 00:05:55.460 align:start position:0%
side-by-side you can do this using the
 

00:05:55.460 --> 00:05:59.020 align:start position:0%
side-by-side you can do this using the
control<00:05:55.940><c> key</c><00:05:56.740><c> select</c><00:05:57.740><c> the</c><00:05:58.070><c> first</c><00:05:58.370><c> sheet</c><00:05:58.880><c> you</c>

00:05:59.020 --> 00:05:59.030 align:start position:0%
control key select the first sheet you
 

00:05:59.030 --> 00:06:02.770 align:start position:0%
control key select the first sheet you
want<00:05:59.210><c> to</c><00:05:59.360><c> group</c><00:06:00.580><c> then</c><00:06:01.580><c> press</c><00:06:02.060><c> and</c><00:06:02.360><c> hold</c><00:06:02.600><c> the</c>

00:06:02.770 --> 00:06:02.780 align:start position:0%
want to group then press and hold the
 

00:06:02.780 --> 00:06:07.720 align:start position:0%
want to group then press and hold the
control<00:06:03.169><c> key</c><00:06:03.200><c> on</c><00:06:03.620><c> your</c><00:06:03.950><c> keyboard</c><00:06:06.160><c> now</c><00:06:07.160><c> select</c>

00:06:07.720 --> 00:06:07.730 align:start position:0%
control key on your keyboard now select
 

00:06:07.730 --> 00:06:09.850 align:start position:0%
control key on your keyboard now select
any<00:06:08.060><c> of</c><00:06:08.360><c> the</c><00:06:08.690><c> other</c><00:06:08.720><c> sheets</c><00:06:09.290><c> you</c><00:06:09.500><c> want</c><00:06:09.680><c> to</c>

00:06:09.850 --> 00:06:09.860 align:start position:0%
any of the other sheets you want to
 

00:06:09.860 --> 00:06:13.380 align:start position:0%
any of the other sheets you want to
group<00:06:10.130><c> and</c><00:06:11.020><c> release</c><00:06:12.020><c> the</c><00:06:12.200><c> control</c><00:06:12.590><c> key</c><00:06:12.860><c> you</c>

00:06:13.380 --> 00:06:13.390 align:start position:0%
group and release the control key you
 

00:06:13.390 --> 00:06:16.120 align:start position:0%
group and release the control key you
can<00:06:14.390><c> see</c><00:06:14.630><c> that</c><00:06:14.810><c> the</c><00:06:14.900><c> sheets</c><00:06:15.260><c> you</c><00:06:15.380><c> selects</c><00:06:16.010><c> it</c>

00:06:16.120 --> 00:06:16.130 align:start position:0%
can see that the sheets you selects it
 

00:06:16.130 --> 00:06:18.790 align:start position:0%
can see that the sheets you selects it
now<00:06:16.520><c> appear</c><00:06:17.120><c> in</c><00:06:17.150><c> white</c><00:06:17.630><c> and</c><00:06:17.960><c> are</c><00:06:18.500><c> grouped</c>

00:06:18.790 --> 00:06:18.800 align:start position:0%
now appear in white and are grouped
 

00:06:18.800 --> 00:06:22.750 align:start position:0%
now appear in white and are grouped
together<00:06:19.130><c> if</c><00:06:19.900><c> I</c><00:06:20.900><c> make</c><00:06:21.140><c> a</c><00:06:21.169><c> change</c><00:06:21.530><c> now</c><00:06:21.980><c> to</c><00:06:22.040><c> one</c>

00:06:22.750 --> 00:06:22.760 align:start position:0%
together if I make a change now to one
 

00:06:22.760 --> 00:06:25.240 align:start position:0%
together if I make a change now to one
it<00:06:23.240><c> will</c><00:06:23.660><c> appear</c><00:06:24.080><c> in</c><00:06:24.200><c> all</c><00:06:24.470><c> the</c><00:06:24.650><c> grouped</c><00:06:24.890><c> sheets</c>

00:06:25.240 --> 00:06:25.250 align:start position:0%
it will appear in all the grouped sheets
 

00:06:25.250 --> 00:06:27.610 align:start position:0%
it will appear in all the grouped sheets
but<00:06:25.940><c> not</c><00:06:26.180><c> the</c><00:06:26.360><c> ones</c><00:06:26.600><c> that</c><00:06:26.750><c> were</c><00:06:27.020><c> not</c><00:06:27.230><c> grouped</c>

00:06:27.610 --> 00:06:27.620 align:start position:0%
but not the ones that were not grouped
 

00:06:27.620 --> 00:06:30.580 align:start position:0%
but not the ones that were not grouped
so<00:06:28.120><c> whatever</c><00:06:29.120><c> I</c><00:06:29.210><c> changed</c><00:06:29.750><c> will</c><00:06:29.870><c> only</c><00:06:30.050><c> appear</c>

00:06:30.580 --> 00:06:30.590 align:start position:0%
so whatever I changed will only appear
 

00:06:30.590 --> 00:06:35.110 align:start position:0%
so whatever I changed will only appear
in<00:06:30.830><c> March</c><00:06:31.370><c> and</c><00:06:31.700><c> May</c><00:06:33.190><c> there</c><00:06:34.190><c> is</c><00:06:34.340><c> one</c><00:06:34.610><c> more</c><00:06:34.850><c> thing</c>

00:06:35.110 --> 00:06:35.120 align:start position:0%
in March and May there is one more thing
 

00:06:35.120 --> 00:06:36.700 align:start position:0%
in March and May there is one more thing
about<00:06:35.330><c> working</c><00:06:35.840><c> with</c><00:06:35.870><c> worksheets</c><00:06:36.380><c> that</c><00:06:36.560><c> I</c>

00:06:36.700 --> 00:06:36.710 align:start position:0%
about working with worksheets that I
 

00:06:36.710 --> 00:06:38.380 align:start position:0%
about working with worksheets that I
want<00:06:36.950><c> to</c><00:06:37.100><c> show</c><00:06:37.340><c> you</c><00:06:37.400><c> because</c><00:06:37.700><c> I</c><00:06:37.940><c> find</c><00:06:38.240><c> it</c>

00:06:38.380 --> 00:06:38.390 align:start position:0%
want to show you because I find it
 

00:06:38.390 --> 00:06:41.320 align:start position:0%
want to show you because I find it
helpful<00:06:38.660><c> this</c><00:06:39.620><c> is</c><00:06:39.680><c> the</c><00:06:39.979><c> ability</c><00:06:40.250><c> to</c><00:06:40.520><c> freeze</c><00:06:40.970><c> or</c>

00:06:41.320 --> 00:06:41.330 align:start position:0%
helpful this is the ability to freeze or
 

00:06:41.330 --> 00:06:44.020 align:start position:0%
helpful this is the ability to freeze or
lock<00:06:41.660><c> specific</c><00:06:42.410><c> rows</c><00:06:42.710><c> or</c><00:06:43.100><c> columns</c><00:06:43.130><c> in</c><00:06:43.970><c> your</c>

00:06:44.020 --> 00:06:44.030 align:start position:0%
lock specific rows or columns in your
 

00:06:44.030 --> 00:06:48.150 align:start position:0%
lock specific rows or columns in your
spreadsheet<00:06:44.210><c> Excel</c><00:06:45.490><c> causes</c><00:06:46.490><c> freezing</c><00:06:46.970><c> panes</c>

00:06:48.150 --> 00:06:48.160 align:start position:0%
spreadsheet Excel causes freezing panes
 

00:06:48.160 --> 00:06:51.520 align:start position:0%
spreadsheet Excel causes freezing panes
when<00:06:49.160><c> you</c><00:06:49.310><c> freeze</c><00:06:49.640><c> panes</c><00:06:50.060><c> you</c><00:06:50.570><c> select</c><00:06:50.930><c> rows</c><00:06:51.260><c> or</c>

00:06:51.520 --> 00:06:51.530 align:start position:0%
when you freeze panes you select rows or
 

00:06:51.530 --> 00:06:53.770 align:start position:0%
when you freeze panes you select rows or
columns<00:06:51.560><c> that</c><00:06:52.220><c> will</c><00:06:52.370><c> remain</c><00:06:52.640><c> visible</c><00:06:53.060><c> all</c><00:06:53.540><c> the</c>

00:06:53.770 --> 00:06:53.780 align:start position:0%
columns that will remain visible all the
 

00:06:53.780 --> 00:06:57.610 align:start position:0%
columns that will remain visible all the
time<00:06:54.050><c> even</c><00:06:54.800><c> as</c><00:06:55.340><c> you</c><00:06:55.550><c> are</c><00:06:55.580><c> scrolling</c><00:06:56.350><c> you</c><00:06:57.350><c> see</c>

00:06:57.610 --> 00:06:57.620 align:start position:0%
time even as you are scrolling you see
 

00:06:57.620 --> 00:06:59.440 align:start position:0%
time even as you are scrolling you see
right<00:06:58.130><c> now</c><00:06:58.400><c> when</c><00:06:58.610><c> I</c><00:06:58.700><c> scroll</c><00:06:59.000><c> down</c><00:06:59.060><c> my</c>

00:06:59.440 --> 00:06:59.450 align:start position:0%
right now when I scroll down my
 

00:06:59.450 --> 00:07:01.330 align:start position:0%
right now when I scroll down my
spreadsheet<00:07:00.050><c> I</c><00:07:00.200><c> can't</c><00:07:00.560><c> see</c><00:07:00.800><c> the</c><00:07:00.950><c> column</c>

00:07:01.330 --> 00:07:01.340 align:start position:0%
spreadsheet I can't see the column
 

00:07:01.340 --> 00:07:03.310 align:start position:0%
spreadsheet I can't see the column
headings<00:07:01.820><c> that</c><00:07:02.060><c> let</c><00:07:02.300><c> me</c><00:07:02.330><c> know</c><00:07:02.720><c> what</c><00:07:03.050><c> type</c><00:07:03.290><c> of</c>

00:07:03.310 --> 00:07:03.320 align:start position:0%
headings that let me know what type of
 

00:07:03.320 --> 00:07:06.909 align:start position:0%
headings that let me know what type of
information<00:07:03.580><c> each</c><00:07:04.580><c> column</c><00:07:05.180><c> contains</c><00:07:05.630><c> if</c><00:07:06.080><c> I</c>

00:07:06.909 --> 00:07:06.919 align:start position:0%
information each column contains if I
 

00:07:06.919 --> 00:07:08.980 align:start position:0%
information each column contains if I
scroll<00:07:07.250><c> to</c><00:07:07.310><c> the</c><00:07:07.550><c> right</c><00:07:07.580><c> I</c><00:07:08.180><c> can't</c><00:07:08.660><c> see</c><00:07:08.840><c> the</c>

00:07:08.980 --> 00:07:08.990 align:start position:0%
scroll to the right I can't see the
 

00:07:08.990 --> 00:07:11.110 align:start position:0%
scroll to the right I can't see the
column<00:07:09.380><c> that</c><00:07:09.470><c> tells</c><00:07:09.770><c> me</c><00:07:10.040><c> what</c><00:07:10.340><c> item</c><00:07:10.700><c> all</c><00:07:10.910><c> this</c>

00:07:11.110 --> 00:07:11.120 align:start position:0%
column that tells me what item all this
 

00:07:11.120 --> 00:07:15.250 align:start position:0%
column that tells me what item all this
inventory<00:07:11.479><c> information</c><00:07:11.840><c> refers</c><00:07:12.470><c> to</c><00:07:14.260><c> to</c>

00:07:15.250 --> 00:07:15.260 align:start position:0%
inventory information refers to to
 

00:07:15.260 --> 00:07:19.780 align:start position:0%
inventory information refers to to
freeze<00:07:15.680><c> a</c><00:07:16.010><c> row</c><00:07:16.479><c> select</c><00:07:17.479><c> the</c><00:07:17.840><c> row</c><00:07:18.280><c> below</c><00:07:19.280><c> the</c>

00:07:19.780 --> 00:07:19.790 align:start position:0%
freeze a row select the row below the
 

00:07:19.790 --> 00:07:22.690 align:start position:0%
freeze a row select the row below the
one<00:07:20.060><c> that</c><00:07:20.270><c> you</c><00:07:20.419><c> want</c><00:07:20.630><c> to</c><00:07:20.720><c> freeze</c><00:07:21.160><c> since</c><00:07:22.160><c> I</c><00:07:22.340><c> want</c>

00:07:22.690 --> 00:07:22.700 align:start position:0%
one that you want to freeze since I want
 

00:07:22.700 --> 00:07:25.060 align:start position:0%
one that you want to freeze since I want
to<00:07:22.850><c> row</c><00:07:23.120><c> one</c><00:07:23.510><c> and</c><00:07:23.810><c> two</c><00:07:24.110><c> to</c><00:07:24.350><c> appear</c><00:07:24.740><c> at</c><00:07:24.890><c> the</c><00:07:25.040><c> top</c>

00:07:25.060 --> 00:07:25.070 align:start position:0%
to row one and two to appear at the top
 

00:07:25.070 --> 00:07:30.870 align:start position:0%
to row one and two to appear at the top
even<00:07:25.729><c> as</c><00:07:26.000><c> I</c><00:07:26.120><c> scroll</c><00:07:26.570><c> I'll</c><00:07:27.050><c> select</c><00:07:28.010><c> Row</c><00:07:28.490><c> three</c>

00:07:30.870 --> 00:07:30.880 align:start position:0%
even as I scroll I'll select Row three
 

00:07:30.880 --> 00:07:35.560 align:start position:0%
even as I scroll I'll select Row three
now<00:07:31.880><c> click</c><00:07:32.330><c> the</c><00:07:32.630><c> View</c><00:07:32.930><c> tab</c><00:07:33.200><c> in</c><00:07:34.090><c> the</c><00:07:35.090><c> window</c>

00:07:35.560 --> 00:07:35.570 align:start position:0%
now click the View tab in the window
 

00:07:35.570 --> 00:07:36.559 align:start position:0%
now click the View tab in the window
group

00:07:36.559 --> 00:07:36.569 align:start position:0%
group
 

00:07:36.569 --> 00:07:39.379 align:start position:0%
group
click<00:07:36.899><c> the</c><00:07:37.110><c> freeze</c><00:07:37.469><c> pain</c><00:07:37.949><c> command</c><00:07:38.520><c> to</c><00:07:39.149><c> view</c>

00:07:39.379 --> 00:07:39.389 align:start position:0%
click the freeze pain command to view
 

00:07:39.389 --> 00:07:43.929 align:start position:0%
click the freeze pain command to view
the<00:07:39.509><c> list</c><00:07:39.719><c> and</c><00:07:40.639><c> then</c><00:07:41.639><c> choose</c><00:07:42.029><c> freeze</c><00:07:42.449><c> pain</c>

00:07:43.929 --> 00:07:43.939 align:start position:0%
the list and then choose freeze pain
 

00:07:43.939 --> 00:07:46.999 align:start position:0%
the list and then choose freeze pain
everything<00:07:44.939><c> above</c><00:07:45.209><c> this</c><00:07:45.419><c> line</c><00:07:45.749><c> is</c><00:07:46.080><c> frozen</c><00:07:46.589><c> in</c>

00:07:46.999 --> 00:07:47.009 align:start position:0%
everything above this line is frozen in
 

00:07:47.009 --> 00:07:51.709 align:start position:0%
everything above this line is frozen in
place<00:07:48.709><c> when</c><00:07:49.709><c> I</c><00:07:49.740><c> scroll</c><00:07:50.279><c> in</c><00:07:50.639><c> the</c><00:07:50.759><c> worksheet</c><00:07:51.209><c> the</c>

00:07:51.709 --> 00:07:51.719 align:start position:0%
place when I scroll in the worksheet the
 

00:07:51.719 --> 00:07:55.279 align:start position:0%
place when I scroll in the worksheet the
first<00:07:52.110><c> two</c><00:07:52.529><c> rows</c><00:07:52.919><c> stay</c><00:07:53.520><c> pins</c><00:07:53.939><c> at</c><00:07:54.270><c> the</c><00:07:54.300><c> top</c><00:07:54.419><c> so</c><00:07:55.259><c> I</c>

00:07:55.279 --> 00:07:55.289 align:start position:0%
first two rows stay pins at the top so I
 

00:07:55.289 --> 00:07:59.299 align:start position:0%
first two rows stay pins at the top so I
can<00:07:55.529><c> always</c><00:07:55.770><c> see</c><00:07:56.129><c> the</c><00:07:56.249><c> column</c><00:07:56.610><c> headings</c><00:07:58.309><c> to</c>

00:07:59.299 --> 00:07:59.309 align:start position:0%
can always see the column headings to
 

00:07:59.309 --> 00:08:01.969 align:start position:0%
can always see the column headings to
unfreeze<00:07:59.849><c> the</c><00:08:00.029><c> pain</c><00:08:00.300><c> just</c><00:08:00.959><c> select</c><00:08:01.379><c> the</c><00:08:01.679><c> freeze</c>

00:08:01.969 --> 00:08:01.979 align:start position:0%
unfreeze the pain just select the freeze
 

00:08:01.979 --> 00:08:04.790 align:start position:0%
unfreeze the pain just select the freeze
pain<00:08:02.339><c> command</c><00:08:02.789><c> and</c><00:08:03.089><c> select</c><00:08:03.719><c> the</c><00:08:04.259><c> unfreeze</c>

00:08:04.790 --> 00:08:04.800 align:start position:0%
pain command and select the unfreeze
 

00:08:04.800 --> 00:08:08.779 align:start position:0%
pain command and select the unfreeze
command<00:08:05.990><c> now</c><00:08:06.990><c> you</c><00:08:07.679><c> can</c><00:08:07.830><c> do</c><00:08:07.949><c> the</c><00:08:08.069><c> same</c><00:08:08.339><c> thing</c>

00:08:08.779 --> 00:08:08.789 align:start position:0%
command now you can do the same thing
 

00:08:08.789 --> 00:08:11.119 align:start position:0%
command now you can do the same thing
with<00:08:08.999><c> columns</c><00:08:09.509><c> let's</c><00:08:10.259><c> say</c><00:08:10.529><c> we</c><00:08:10.740><c> want</c><00:08:11.009><c> the</c><00:08:11.099><c> first</c>

00:08:11.119 --> 00:08:11.129 align:start position:0%
with columns let's say we want the first
 

00:08:11.129 --> 00:08:14.089 align:start position:0%
with columns let's say we want the first
two<00:08:11.789><c> columns</c><00:08:12.360><c> to</c><00:08:12.569><c> always</c><00:08:13.050><c> appear</c><00:08:13.469><c> on</c><00:08:13.649><c> the</c><00:08:13.800><c> left</c>

00:08:14.089 --> 00:08:14.099 align:start position:0%
two columns to always appear on the left
 

00:08:14.099 --> 00:08:17.869 align:start position:0%
two columns to always appear on the left
just<00:08:15.139><c> select</c><00:08:16.139><c> the</c><00:08:16.439><c> column</c><00:08:16.860><c> to</c><00:08:17.009><c> the</c><00:08:17.129><c> right</c><00:08:17.159><c> of</c>

00:08:17.869 --> 00:08:17.879 align:start position:0%
just select the column to the right of
 

00:08:17.879 --> 00:08:21.920 align:start position:0%
just select the column to the right of
the<00:08:18.330><c> columns</c><00:08:18.839><c> you</c><00:08:18.930><c> want</c><00:08:19.229><c> frozen</c><00:08:20.189><c> and</c><00:08:20.930><c> then</c>

00:08:21.920 --> 00:08:21.930 align:start position:0%
the columns you want frozen and then
 

00:08:21.930 --> 00:08:26.230 align:start position:0%
the columns you want frozen and then
click<00:08:22.349><c> freeze</c><00:08:22.860><c> pain</c><00:08:23.369><c> and</c><00:08:23.819><c> freeze</c><00:08:24.360><c> pain</c><00:08:24.719><c> again</c>

00:08:26.230 --> 00:08:26.240 align:start position:0%
click freeze pain and freeze pain again
 

00:08:26.240 --> 00:08:29.059 align:start position:0%
click freeze pain and freeze pain again
now<00:08:27.240><c> as</c><00:08:27.479><c> we</c><00:08:27.599><c> scroll</c><00:08:27.930><c> to</c><00:08:27.959><c> the</c><00:08:28.259><c> right</c><00:08:28.529><c> those</c>

00:08:29.059 --> 00:08:29.069 align:start position:0%
now as we scroll to the right those
 

00:08:29.069 --> 00:08:31.879 align:start position:0%
now as we scroll to the right those
columns<00:08:29.699><c> stay</c><00:08:29.879><c> rates</c><00:08:30.240><c> in</c><00:08:30.479><c> place</c><00:08:30.889><c> freezing</c>

00:08:31.879 --> 00:08:31.889 align:start position:0%
columns stay rates in place freezing
 

00:08:31.889 --> 00:08:33.740 align:start position:0%
columns stay rates in place freezing
rows<00:08:32.310><c> and</c><00:08:32.550><c> columns</c><00:08:32.969><c> can</c><00:08:33.329><c> be</c><00:08:33.360><c> especially</c>

00:08:33.740 --> 00:08:33.750 align:start position:0%
rows and columns can be especially
 

00:08:33.750 --> 00:08:35.209 align:start position:0%
rows and columns can be especially
helpful<00:08:34.079><c> when</c><00:08:34.620><c> dealing</c><00:08:34.919><c> with</c><00:08:35.069><c> large</c>

00:08:35.209 --> 00:08:35.219 align:start position:0%
helpful when dealing with large
 

00:08:35.219 --> 00:08:37.819 align:start position:0%
helpful when dealing with large
spreadsheets<00:08:36.180><c> so</c><00:08:36.719><c> this</c><00:08:36.930><c> is</c><00:08:37.050><c> a</c><00:08:37.079><c> good</c><00:08:37.380><c> thing</c><00:08:37.440><c> to</c>

00:08:37.819 --> 00:08:37.829 align:start position:0%
spreadsheets so this is a good thing to
 

00:08:37.829 --> 00:08:40.249 align:start position:0%
spreadsheets so this is a good thing to
know<00:08:38.009><c> how</c><00:08:38.190><c> to</c><00:08:38.250><c> do</c><00:08:38.550><c> it</c><00:08:38.849><c> doesn't</c><00:08:39.630><c> change</c><00:08:39.839><c> how</c><00:08:40.199><c> the</c>

00:08:40.249 --> 00:08:40.259 align:start position:0%
know how to do it doesn't change how the
 

00:08:40.259 --> 00:08:42.469 align:start position:0%
know how to do it doesn't change how the
spreadsheet<00:08:40.709><c> looks</c><00:08:41.099><c> printed</c><00:08:41.699><c> but</c><00:08:42.089><c> it</c><00:08:42.209><c> does</c>

00:08:42.469 --> 00:08:42.479 align:start position:0%
spreadsheet looks printed but it does
 

00:08:42.479 --> 00:08:44.600 align:start position:0%
spreadsheet looks printed but it does
make<00:08:42.719><c> working</c><00:08:43.289><c> with</c><00:08:43.560><c> it</c><00:08:43.800><c> electronically</c><00:08:44.490><c> a</c>

00:08:44.600 --> 00:08:44.610 align:start position:0%
make working with it electronically a
 

00:08:44.610 --> 00:08:47.840 align:start position:0%
make working with it electronically a
lot<00:08:44.970><c> easier</c><00:08:45.420><c> we've</c><00:08:46.199><c> gone</c><00:08:46.410><c> over</c><00:08:46.470><c> a</c><00:08:46.769><c> lot</c><00:08:46.889><c> but</c><00:08:47.730><c> it</c>

00:08:47.840 --> 00:08:47.850 align:start position:0%
lot easier we've gone over a lot but it
 

00:08:47.850 --> 00:08:49.910 align:start position:0%
lot easier we've gone over a lot but it
really<00:08:48.089><c> is</c><00:08:48.329><c> important</c><00:08:48.870><c> to</c><00:08:48.930><c> know</c><00:08:49.139><c> how</c><00:08:49.380><c> to</c><00:08:49.439><c> work</c>

00:08:49.910 --> 00:08:49.920 align:start position:0%
really is important to know how to work
 

00:08:49.920 --> 00:08:51.889 align:start position:0%
really is important to know how to work
with<00:08:50.100><c> worksheets</c><00:08:50.579><c> so</c><00:08:51.120><c> that</c><00:08:51.300><c> you</c><00:08:51.449><c> can</c><00:08:51.630><c> easily</c>

00:08:51.889 --> 00:08:51.899 align:start position:0%
with worksheets so that you can easily
 

00:08:51.899 --> 00:08:54.620 align:start position:0%
with worksheets so that you can easily
navigate<00:08:52.290><c> your</c><00:08:52.740><c> workbook</c><00:08:53.279><c> and</c><00:08:53.490><c> use</c><00:08:54.089><c> it</c><00:08:54.269><c> most</c>

00:08:54.620 --> 00:08:54.630 align:start position:0%
navigate your workbook and use it most
 

00:08:54.630 --> 00:08:57.259 align:start position:0%
navigate your workbook and use it most
efficiently<00:08:55.290><c> take</c><00:08:56.279><c> some</c><00:08:56.490><c> time</c><00:08:56.730><c> to</c><00:08:56.910><c> explore</c>

00:08:57.259 --> 00:08:57.269 align:start position:0%
efficiently take some time to explore
 

00:08:57.269 --> 00:09:00.439 align:start position:0%
efficiently take some time to explore
worksheets<00:08:57.839><c> on</c><00:08:58.050><c> your</c><00:08:58.259><c> own</c>