WEBVTT
Kind: captions
Language: en

00:00:09.590 --> 00:00:12.259 align:start position:0%
 
when<00:00:10.590><c> working</c><00:00:10.830><c> with</c><00:00:11.010><c> large</c><00:00:11.190><c> spreadsheets</c><00:00:12.059><c> in</c>

00:00:12.259 --> 00:00:12.269 align:start position:0%
when working with large spreadsheets in
 

00:00:12.269 --> 00:00:14.570 align:start position:0%
when working with large spreadsheets in
Excel<00:00:12.630><c> the</c><00:00:12.990><c> ability</c><00:00:13.380><c> to</c><00:00:13.530><c> freeze</c><00:00:13.769><c> panes</c><00:00:14.130><c> can</c><00:00:14.460><c> be</c>

00:00:14.570 --> 00:00:14.580 align:start position:0%
Excel the ability to freeze panes can be
 

00:00:14.580 --> 00:00:16.580 align:start position:0%
Excel the ability to freeze panes can be
very<00:00:14.880><c> helpful</c><00:00:15.150><c> it</c><00:00:15.839><c> works</c><00:00:16.080><c> just</c><00:00:16.320><c> like</c><00:00:16.440><c> it</c>

00:00:16.580 --> 00:00:16.590 align:start position:0%
very helpful it works just like it
 

00:00:16.590 --> 00:00:19.429 align:start position:0%
very helpful it works just like it
sounds<00:00:17.240><c> certain</c><00:00:18.240><c> columns</c><00:00:18.630><c> or</c><00:00:18.779><c> rows</c><00:00:18.810><c> become</c>

00:00:19.429 --> 00:00:19.439 align:start position:0%
sounds certain columns or rows become
 

00:00:19.439 --> 00:00:21.830 align:start position:0%
sounds certain columns or rows become
frozen<00:00:19.680><c> or</c><00:00:20.070><c> fixed</c><00:00:20.400><c> in</c><00:00:20.520><c> place</c><00:00:20.760><c> allowing</c><00:00:21.570><c> you</c><00:00:21.750><c> to</c>

00:00:21.830 --> 00:00:21.840 align:start position:0%
frozen or fixed in place allowing you to
 

00:00:21.840 --> 00:00:23.540 align:start position:0%
frozen or fixed in place allowing you to
scroll<00:00:22.230><c> the</c><00:00:22.439><c> length</c><00:00:22.650><c> of</c><00:00:22.830><c> your</c><00:00:22.949><c> worksheet</c><00:00:23.400><c> and</c>

00:00:23.540 --> 00:00:23.550 align:start position:0%
scroll the length of your worksheet and
 

00:00:23.550 --> 00:00:25.189 align:start position:0%
scroll the length of your worksheet and
still<00:00:23.970><c> see</c><00:00:24.150><c> important</c><00:00:24.600><c> data</c><00:00:24.750><c> like</c><00:00:25.019><c> your</c>

00:00:25.189 --> 00:00:25.199 align:start position:0%
still see important data like your
 

00:00:25.199 --> 00:00:28.250 align:start position:0%
still see important data like your
header<00:00:25.380><c> cells</c><00:00:25.880><c> to</c><00:00:26.880><c> freeze</c><00:00:27.150><c> any</c><00:00:27.420><c> row</c><00:00:27.689><c> all</c><00:00:27.990><c> you</c>

00:00:28.250 --> 00:00:28.260 align:start position:0%
header cells to freeze any row all you
 

00:00:28.260 --> 00:00:30.140 align:start position:0%
header cells to freeze any row all you
have<00:00:28.439><c> to</c><00:00:28.590><c> do</c><00:00:28.740><c> is</c><00:00:28.949><c> select</c><00:00:29.099><c> the</c><00:00:29.369><c> one</c><00:00:29.460><c> below</c><00:00:29.970><c> the</c>

00:00:30.140 --> 00:00:30.150 align:start position:0%
have to do is select the one below the
 

00:00:30.150 --> 00:00:31.250 align:start position:0%
have to do is select the one below the
row<00:00:30.300><c> you</c><00:00:30.359><c> want</c><00:00:30.480><c> to</c><00:00:30.689><c> freeze</c>

00:00:31.250 --> 00:00:31.260 align:start position:0%
row you want to freeze
 

00:00:31.260 --> 00:00:35.360 align:start position:0%
row you want to freeze
I<00:00:31.289><c> want</c><00:00:32.040><c> to</c><00:00:32.130><c> freeze</c><00:00:32.340><c> rows</c><00:00:32.700><c> 1</c><00:00:33.090><c> 2</c><00:00:33.780><c> &amp;</c><00:00:34.110><c> 3</c><00:00:34.140><c> so</c><00:00:34.739><c> they</c>

00:00:35.360 --> 00:00:35.370 align:start position:0%
I want to freeze rows 1 2 &amp; 3 so they
 

00:00:35.370 --> 00:00:37.190 align:start position:0%
I want to freeze rows 1 2 &amp; 3 so they
stay<00:00:35.670><c> at</c><00:00:35.790><c> the</c><00:00:35.910><c> top</c><00:00:36.120><c> of</c><00:00:36.149><c> the</c><00:00:36.360><c> worksheet</c><00:00:36.570><c> even</c>

00:00:37.190 --> 00:00:37.200 align:start position:0%
stay at the top of the worksheet even
 

00:00:37.200 --> 00:00:39.770 align:start position:0%
stay at the top of the worksheet even
when<00:00:37.350><c> I</c><00:00:37.380><c> scroll</c><00:00:37.770><c> down</c><00:00:37.910><c> that</c><00:00:38.910><c> means</c><00:00:39.120><c> the</c><00:00:39.420><c> row</c><00:00:39.540><c> I</c>

00:00:39.770 --> 00:00:39.780 align:start position:0%
when I scroll down that means the row I
 

00:00:39.780 --> 00:00:42.770 align:start position:0%
when I scroll down that means the row I
need<00:00:39.989><c> to</c><00:00:40.140><c> select</c><00:00:40.469><c> is</c><00:00:40.680><c> row</c><00:00:40.890><c> 4</c><00:00:41.270><c> now</c><00:00:42.270><c> go</c><00:00:42.570><c> to</c><00:00:42.629><c> the</c>

00:00:42.770 --> 00:00:42.780 align:start position:0%
need to select is row 4 now go to the
 

00:00:42.780 --> 00:00:46.850 align:start position:0%
need to select is row 4 now go to the
ribbon<00:00:43.110><c> and</c><00:00:43.140><c> select</c><00:00:43.860><c> the</c><00:00:44.129><c> View</c><00:00:44.370><c> tab</c><00:00:45.739><c> here</c><00:00:46.739><c> we</c>

00:00:46.850 --> 00:00:46.860 align:start position:0%
ribbon and select the View tab here we
 

00:00:46.860 --> 00:00:49.729 align:start position:0%
ribbon and select the View tab here we
have<00:00:47.100><c> the</c><00:00:47.340><c> freeze</c><00:00:47.610><c> panes</c><00:00:47.910><c> command</c><00:00:48.440><c> just</c><00:00:49.440><c> click</c>

00:00:49.729 --> 00:00:49.739 align:start position:0%
have the freeze panes command just click
 

00:00:49.739 --> 00:00:51.920 align:start position:0%
have the freeze panes command just click
and<00:00:49.980><c> choose</c><00:00:50.579><c> freeze</c><00:00:50.969><c> panes</c><00:00:51.300><c> from</c><00:00:51.600><c> the</c><00:00:51.719><c> drop</c>

00:00:51.920 --> 00:00:51.930 align:start position:0%
and choose freeze panes from the drop
 

00:00:51.930 --> 00:00:55.310 align:start position:0%
and choose freeze panes from the drop
down<00:00:51.960><c> menu</c><00:00:52.170><c> a</c><00:00:53.000><c> black</c><00:00:54.000><c> line</c><00:00:54.329><c> appears</c><00:00:54.750><c> below</c><00:00:55.020><c> the</c>

00:00:55.310 --> 00:00:55.320 align:start position:0%
down menu a black line appears below the
 

00:00:55.320 --> 00:00:57.500 align:start position:0%
down menu a black line appears below the
rows<00:00:55.530><c> that</c><00:00:55.559><c> are</c><00:00:55.890><c> frozen</c><00:00:56.160><c> sectioning</c><00:00:57.090><c> off</c><00:00:57.239><c> what</c>

00:00:57.500 --> 00:00:57.510 align:start position:0%
rows that are frozen sectioning off what
 

00:00:57.510 --> 00:00:59.389 align:start position:0%
rows that are frozen sectioning off what
moves<00:00:57.780><c> and</c><00:00:58.050><c> what</c><00:00:58.260><c> stays</c><00:00:58.500><c> in</c><00:00:58.710><c> place</c><00:00:58.949><c> when</c><00:00:59.280><c> you</c>

00:00:59.389 --> 00:00:59.399 align:start position:0%
moves and what stays in place when you
 

00:00:59.399 --> 00:01:00.470 align:start position:0%
moves and what stays in place when you
scroll<00:00:59.670><c> through</c><00:00:59.910><c> the</c><00:01:00.000><c> data</c><00:01:00.149><c> in</c><00:01:00.449><c> your</c>

00:01:00.470 --> 00:01:00.480 align:start position:0%
scroll through the data in your
 

00:01:00.480 --> 00:01:05.179 align:start position:0%
scroll through the data in your
worksheet<00:01:00.989><c> let's</c><00:01:03.260><c> try</c><00:01:04.260><c> freezing</c><00:01:04.710><c> a</c><00:01:04.830><c> column</c>

00:01:05.179 --> 00:01:05.189 align:start position:0%
worksheet let's try freezing a column
 

00:01:05.189 --> 00:01:07.490 align:start position:0%
worksheet let's try freezing a column
now<00:01:05.369><c> for</c><00:01:06.060><c> example</c><00:01:06.150><c> when</c><00:01:06.689><c> I</c><00:01:06.720><c> scroll</c><00:01:07.049><c> from</c><00:01:07.290><c> left</c>

00:01:07.490 --> 00:01:07.500 align:start position:0%
now for example when I scroll from left
 

00:01:07.500 --> 00:01:09.320 align:start position:0%
now for example when I scroll from left
to<00:01:07.590><c> right</c><00:01:07.830><c> it</c><00:01:08.130><c> would</c><00:01:08.400><c> help</c><00:01:08.549><c> to</c><00:01:08.760><c> be</c><00:01:08.880><c> able</c><00:01:08.970><c> to</c><00:01:09.119><c> see</c>

00:01:09.320 --> 00:01:09.330 align:start position:0%
to right it would help to be able to see
 

00:01:09.330 --> 00:01:11.240 align:start position:0%
to right it would help to be able to see
the<00:01:09.479><c> names</c><00:01:09.689><c> of</c><00:01:09.869><c> all</c><00:01:10.049><c> these</c><00:01:10.170><c> expenses</c><00:01:10.799><c> which</c><00:01:11.070><c> I</c>

00:01:11.240 --> 00:01:11.250 align:start position:0%
the names of all these expenses which I
 

00:01:11.250 --> 00:01:13.910 align:start position:0%
the names of all these expenses which I
have<00:01:11.400><c> listed</c><00:01:11.580><c> back</c><00:01:11.909><c> in</c><00:01:12.090><c> column</c><00:01:12.450><c> a</c><00:01:12.710><c> first</c><00:01:13.710><c> I</c>

00:01:13.910 --> 00:01:13.920 align:start position:0%
have listed back in column a first I
 

00:01:13.920 --> 00:01:15.950 align:start position:0%
have listed back in column a first I
need<00:01:14.100><c> to</c><00:01:14.250><c> unfreeze</c><00:01:14.640><c> my</c><00:01:14.880><c> rows</c><00:01:15.150><c> by</c><00:01:15.450><c> going</c><00:01:15.750><c> back</c>

00:01:15.950 --> 00:01:15.960 align:start position:0%
need to unfreeze my rows by going back
 

00:01:15.960 --> 00:01:17.450 align:start position:0%
need to unfreeze my rows by going back
to<00:01:16.140><c> the</c><00:01:16.259><c> freeze</c><00:01:16.470><c> panes</c><00:01:16.710><c> command</c><00:01:16.890><c> and</c>

00:01:17.450 --> 00:01:17.460 align:start position:0%
to the freeze panes command and
 

00:01:17.460 --> 00:01:21.920 align:start position:0%
to the freeze panes command and
selecting<00:01:18.420><c> unfreeze</c><00:01:19.140><c> panes</c><00:01:20.420><c> now</c><00:01:21.420><c> remember</c>

00:01:21.920 --> 00:01:21.930 align:start position:0%
selecting unfreeze panes now remember
 

00:01:21.930 --> 00:01:23.510 align:start position:0%
selecting unfreeze panes now remember
there's<00:01:22.140><c> a</c><00:01:22.200><c> trick</c><00:01:22.470><c> to</c><00:01:22.619><c> the</c><00:01:22.740><c> cells</c><00:01:22.979><c> you</c><00:01:23.189><c> need</c><00:01:23.340><c> to</c>

00:01:23.510 --> 00:01:23.520 align:start position:0%
there's a trick to the cells you need to
 

00:01:23.520 --> 00:01:25.880 align:start position:0%
there's a trick to the cells you need to
select<00:01:23.700><c> when</c><00:01:24.090><c> freezing</c><00:01:24.650><c> instead</c><00:01:25.650><c> of</c><00:01:25.770><c> the</c>

00:01:25.880 --> 00:01:25.890 align:start position:0%
select when freezing instead of the
 

00:01:25.890 --> 00:01:27.800 align:start position:0%
select when freezing instead of the
column<00:01:26.250><c> you</c><00:01:26.280><c> want</c><00:01:26.490><c> to</c><00:01:26.700><c> freeze</c><00:01:26.970><c> in</c><00:01:27.299><c> my</c><00:01:27.509><c> case</c>

00:01:27.800 --> 00:01:27.810 align:start position:0%
column you want to freeze in my case
 

00:01:27.810 --> 00:01:30.410 align:start position:0%
column you want to freeze in my case
column<00:01:28.229><c> a</c><00:01:28.439><c> you</c><00:01:28.710><c> need</c><00:01:29.340><c> to</c><00:01:29.460><c> select</c><00:01:29.640><c> the</c><00:01:29.909><c> one</c><00:01:30.180><c> to</c>

00:01:30.410 --> 00:01:30.420 align:start position:0%
column a you need to select the one to
 

00:01:30.420 --> 00:01:33.380 align:start position:0%
column a you need to select the one to
the<00:01:30.540><c> right</c><00:01:31.159><c> use</c><00:01:32.159><c> the</c><00:01:32.369><c> freeze</c><00:01:32.610><c> panes</c><00:01:32.880><c> command</c>

00:01:33.380 --> 00:01:33.390 align:start position:0%
the right use the freeze panes command
 

00:01:33.390 --> 00:01:35.780 align:start position:0%
the right use the freeze panes command
just<00:01:33.630><c> like</c><00:01:33.750><c> before</c><00:01:34.049><c> and</c><00:01:34.530><c> a</c><00:01:35.310><c> black</c><00:01:35.520><c> line</c>

00:01:35.780 --> 00:01:35.790 align:start position:0%
just like before and a black line
 

00:01:35.790 --> 00:01:37.569 align:start position:0%
just like before and a black line
appears<00:01:36.210><c> to</c><00:01:36.299><c> the</c><00:01:36.570><c> right</c><00:01:36.600><c> of</c><00:01:36.780><c> the</c><00:01:36.990><c> frozen</c><00:01:37.409><c> area</c>

00:01:37.569 --> 00:01:37.579 align:start position:0%
appears to the right of the frozen area
 

00:01:37.579 --> 00:01:39.890 align:start position:0%
appears to the right of the frozen area
now<00:01:38.579><c> we</c><00:01:38.640><c> can</c><00:01:38.909><c> scroll</c><00:01:39.210><c> from</c><00:01:39.540><c> month</c><00:01:39.720><c> to</c><00:01:39.780><c> month</c>

00:01:39.890 --> 00:01:39.900 align:start position:0%
now we can scroll from month to month
 

00:01:39.900 --> 00:01:42.050 align:start position:0%
now we can scroll from month to month
and<00:01:40.229><c> the</c><00:01:40.619><c> column</c><00:01:40.950><c> of</c><00:01:41.070><c> expenses</c><00:01:41.610><c> stays</c><00:01:41.880><c> in</c>

00:01:42.050 --> 00:01:42.060 align:start position:0%
and the column of expenses stays in
 

00:01:42.060 --> 00:01:44.990 align:start position:0%
and the column of expenses stays in
place<00:01:42.740><c> freezing</c><00:01:43.740><c> panes</c><00:01:43.920><c> really</c><00:01:44.430><c> goes</c><00:01:44.610><c> a</c><00:01:44.640><c> long</c>

00:01:44.990 --> 00:01:45.000 align:start position:0%
place freezing panes really goes a long
 

00:01:45.000 --> 00:01:46.940 align:start position:0%
place freezing panes really goes a long
way<00:01:45.240><c> in</c><00:01:45.479><c> making</c><00:01:45.600><c> your</c><00:01:45.869><c> worksheet</c><00:01:46.320><c> easier</c><00:01:46.829><c> to</c>

00:01:46.940 --> 00:01:46.950 align:start position:0%
way in making your worksheet easier to
 

00:01:46.950 --> 00:01:51.539 align:start position:0%
way in making your worksheet easier to
navigate<00:01:47.100><c> and</c><00:01:47.430><c> easier</c><00:01:48.030><c> to</c><00:01:48.060><c> understand</c>

00:01:51.539 --> 00:01:51.549 align:start position:0%
 
 

00:01:51.549 --> 00:01:55.510 align:start position:0%
 
like<00:01:52.549><c> what</c><00:01:52.729><c> you</c><00:01:52.880><c> just</c><00:01:52.909><c> saw</c><00:01:53.770><c> rate</c><00:01:54.770><c> it</c><00:01:54.950><c> at</c><00:01:55.460><c> a</c>

00:01:55.510 --> 00:01:55.520 align:start position:0%
like what you just saw rate it at a
 

00:01:55.520 --> 00:01:58.600 align:start position:0%
like what you just saw rate it at a
comment<00:01:56.060><c> subscribe</c><00:01:56.570><c> to</c><00:01:56.899><c> our</c><00:01:57.140><c> chill</c><00:01:57.610><c> the</c>

00:01:58.600 --> 00:01:58.610 align:start position:0%
comment subscribe to our chill the
 

00:01:58.610 --> 00:02:02.889 align:start position:0%
comment subscribe to our chill the
freedom<00:01:59.060><c> to</c><00:01:59.090><c> learn</c><00:01:59.979><c> what</c><00:02:00.979><c> you</c><00:02:01.189><c> want</c><00:02:01.689><c> when</c><00:02:02.689><c> you</c>

00:02:02.889 --> 00:02:02.899 align:start position:0%
freedom to learn what you want when you
 

00:02:02.899 --> 00:02:09.250 align:start position:0%
freedom to learn what you want when you
want<00:02:04.090><c> absolutely</c><00:02:05.090><c> free</c>

00:02:09.250 --> 00:02:09.260 align:start position:0%
 
 

00:02:09.260 --> 00:02:12.890 align:start position:0%
 
GCF<00:02:10.260><c> learn</c><00:02:10.860><c> free.org</c>