WEBVTT
Kind: captions
Language: en

00:00:01.169 --> 00:00:03.749 align:start position:0%
 
Goodwill<00:00:02.169><c> Community</c><00:00:02.620><c> Foundation</c><00:00:03.279><c> creating</c>

00:00:03.749 --> 00:00:03.759 align:start position:0%
Goodwill Community Foundation creating
 

00:00:03.759 --> 00:00:09.270 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:04.330><c> for</c><00:00:04.360><c> a</c><00:00:04.630><c> better</c><00:00:04.660><c> life</c><00:00:08.280><c> Excel</c>

00:00:09.270 --> 00:00:09.280 align:start position:0%
opportunities for a better life Excel
 

00:00:09.280 --> 00:00:11.310 align:start position:0%
opportunities for a better life Excel
worksheets<00:00:09.850><c> can</c><00:00:10.000><c> have</c><00:00:10.300><c> a</c><00:00:10.330><c> lot</c><00:00:10.600><c> of</c><00:00:10.780><c> cells</c><00:00:11.019><c> and</c>

00:00:11.310 --> 00:00:11.320 align:start position:0%
worksheets can have a lot of cells and
 

00:00:11.320 --> 00:00:13.230 align:start position:0%
worksheets can have a lot of cells and
sometimes<00:00:11.980><c> you</c><00:00:12.130><c> may</c><00:00:12.340><c> find</c><00:00:12.610><c> that</c><00:00:12.790><c> you</c><00:00:12.940><c> want</c><00:00:12.970><c> to</c>

00:00:13.230 --> 00:00:13.240 align:start position:0%
sometimes you may find that you want to
 

00:00:13.240 --> 00:00:14.820 align:start position:0%
sometimes you may find that you want to
view<00:00:13.480><c> two</c><00:00:13.720><c> different</c><00:00:14.260><c> parts</c><00:00:14.559><c> of</c><00:00:14.680><c> the</c>

00:00:14.820 --> 00:00:14.830 align:start position:0%
view two different parts of the
 

00:00:14.830 --> 00:00:17.460 align:start position:0%
view two different parts of the
spreadsheet<00:00:15.130><c> at</c><00:00:15.460><c> the</c><00:00:15.610><c> same</c><00:00:15.820><c> time</c><00:00:16.350><c> for</c><00:00:17.350><c> example</c>

00:00:17.460 --> 00:00:17.470 align:start position:0%
spreadsheet at the same time for example
 

00:00:17.470 --> 00:00:19.650 align:start position:0%
spreadsheet at the same time for example
in<00:00:18.010><c> this</c><00:00:18.369><c> spreadsheet</c><00:00:18.940><c> I</c><00:00:18.970><c> have</c><00:00:19.210><c> a</c><00:00:19.300><c> list</c><00:00:19.539><c> of</c>

00:00:19.650 --> 00:00:19.660 align:start position:0%
in this spreadsheet I have a list of
 

00:00:19.660 --> 00:00:21.870 align:start position:0%
in this spreadsheet I have a list of
salespeople<00:00:20.199><c> in</c><00:00:20.440><c> the</c><00:00:20.590><c> first</c><00:00:20.800><c> column</c><00:00:21.070><c> but</c><00:00:21.760><c> when</c>

00:00:21.870 --> 00:00:21.880 align:start position:0%
salespeople in the first column but when
 

00:00:21.880 --> 00:00:23.640 align:start position:0%
salespeople in the first column but when
I<00:00:21.910><c> scroll</c><00:00:22.330><c> to</c><00:00:22.360><c> the</c><00:00:22.630><c> right</c><00:00:22.869><c> those</c><00:00:23.380><c> names</c>

00:00:23.640 --> 00:00:23.650 align:start position:0%
I scroll to the right those names
 

00:00:23.650 --> 00:00:26.010 align:start position:0%
I scroll to the right those names
disappear<00:00:24.340><c> which</c><00:00:24.880><c> makes</c><00:00:25.119><c> it</c><00:00:25.270><c> really</c><00:00:25.300><c> hard</c><00:00:25.900><c> to</c>

00:00:26.010 --> 00:00:26.020 align:start position:0%
disappear which makes it really hard to
 

00:00:26.020 --> 00:00:29.130 align:start position:0%
disappear which makes it really hard to
see<00:00:26.109><c> who</c><00:00:26.470><c> the</c><00:00:26.619><c> sales</c><00:00:26.859><c> data</c><00:00:27.100><c> belongs</c><00:00:27.550><c> to</c><00:00:27.960><c> we</c><00:00:28.960><c> can</c>

00:00:29.130 --> 00:00:29.140 align:start position:0%
see who the sales data belongs to we can
 

00:00:29.140 --> 00:00:31.769 align:start position:0%
see who the sales data belongs to we can
fix<00:00:29.410><c> this</c><00:00:29.680><c> by</c><00:00:29.980><c> freezing</c><00:00:30.609><c> the</c><00:00:30.699><c> first</c><00:00:30.970><c> column</c><00:00:31.449><c> so</c>

00:00:31.769 --> 00:00:31.779 align:start position:0%
fix this by freezing the first column so
 

00:00:31.779 --> 00:00:35.280 align:start position:0%
fix this by freezing the first column so
we'll<00:00:32.050><c> always</c><00:00:32.259><c> say</c><00:00:32.590><c> visible</c><00:00:33.360><c> first</c><00:00:34.360><c> go</c><00:00:35.079><c> to</c><00:00:35.110><c> the</c>

00:00:35.280 --> 00:00:35.290 align:start position:0%
we'll always say visible first go to the
 

00:00:35.290 --> 00:00:39.780 align:start position:0%
we'll always say visible first go to the
View<00:00:35.530><c> tab</c><00:00:35.710><c> and</c><00:00:36.149><c> click</c><00:00:37.149><c> freeze</c><00:00:37.570><c> panes</c><00:00:37.600><c> and</c><00:00:38.790><c> you</c>

00:00:39.780 --> 00:00:39.790 align:start position:0%
View tab and click freeze panes and you
 

00:00:39.790 --> 00:00:41.910 align:start position:0%
View tab and click freeze panes and you
have<00:00:39.910><c> a</c><00:00:39.940><c> few</c><00:00:40.270><c> different</c><00:00:40.360><c> options</c><00:00:40.600><c> but</c><00:00:41.290><c> we</c><00:00:41.739><c> just</c>

00:00:41.910 --> 00:00:41.920 align:start position:0%
have a few different options but we just
 

00:00:41.920 --> 00:00:44.450 align:start position:0%
have a few different options but we just
want<00:00:42.070><c> to</c><00:00:42.130><c> freeze</c><00:00:42.340><c> the</c><00:00:42.370><c> first</c><00:00:42.579><c> column</c>

00:00:44.450 --> 00:00:44.460 align:start position:0%
want to freeze the first column
 

00:00:44.460 --> 00:00:47.480 align:start position:0%
want to freeze the first column
now<00:00:45.240><c> when</c><00:00:45.540><c> we</c><00:00:45.660><c> scroll</c><00:00:45.990><c> we</c><00:00:46.440><c> can</c><00:00:46.590><c> easily</c><00:00:46.950><c> see</c><00:00:47.370><c> the</c>

00:00:47.480 --> 00:00:47.490 align:start position:0%
now when we scroll we can easily see the
 

00:00:47.490 --> 00:00:49.580 align:start position:0%
now when we scroll we can easily see the
names<00:00:47.700><c> of</c><00:00:47.880><c> each</c><00:00:48.180><c> salesperson</c><00:00:48.720><c> no</c><00:00:49.410><c> matter</c>

00:00:49.580 --> 00:00:49.590 align:start position:0%
names of each salesperson no matter
 

00:00:49.590 --> 00:00:51.250 align:start position:0%
names of each salesperson no matter
where<00:00:49.890><c> we</c><00:00:50.100><c> are</c><00:00:50.130><c> in</c><00:00:50.280><c> the</c><00:00:50.460><c> spreadsheet</c>

00:00:51.250 --> 00:00:51.260 align:start position:0%
where we are in the spreadsheet
 

00:00:51.260 --> 00:00:54.140 align:start position:0%
where we are in the spreadsheet
this<00:00:52.260><c> one</c><00:00:52.530><c> she</c><00:00:52.710><c> also</c><00:00:52.980><c> has</c><00:00:53.340><c> dates</c><00:00:53.760><c> in</c><00:00:54.060><c> the</c>

00:00:54.140 --> 00:00:54.150 align:start position:0%
this one she also has dates in the
 

00:00:54.150 --> 00:00:56.030 align:start position:0%
this one she also has dates in the
second<00:00:54.510><c> row</c><00:00:54.630><c> and</c><00:00:54.840><c> I'd</c><00:00:55.110><c> like</c><00:00:55.320><c> to</c><00:00:55.440><c> freeze</c><00:00:55.680><c> them</c>

00:00:56.030 --> 00:00:56.040 align:start position:0%
second row and I'd like to freeze them
 

00:00:56.040 --> 00:00:57.680 align:start position:0%
second row and I'd like to freeze them
so<00:00:56.370><c> they'll</c><00:00:56.550><c> stay</c><00:00:56.730><c> visible</c><00:00:56.940><c> when</c><00:00:57.330><c> I</c><00:00:57.360><c> scroll</c>

00:00:57.680 --> 00:00:57.690 align:start position:0%
so they'll stay visible when I scroll
 

00:00:57.690 --> 00:01:00.229 align:start position:0%
so they'll stay visible when I scroll
down<00:00:57.750><c> but</c><00:00:58.500><c> in</c><00:00:58.710><c> this</c><00:00:58.980><c> example</c><00:00:59.400><c> it's</c><00:00:59.880><c> going</c><00:01:00.150><c> to</c>

00:01:00.229 --> 00:01:00.239 align:start position:0%
down but in this example it's going to
 

00:01:00.239 --> 00:01:02.030 align:start position:0%
down but in this example it's going to
work<00:01:00.360><c> a</c><00:01:00.510><c> bit</c><00:01:00.900><c> differently</c><00:01:00.960><c> and</c><00:01:01.860><c> that's</c>

00:01:02.030 --> 00:01:02.040 align:start position:0%
work a bit differently and that's
 

00:01:02.040 --> 00:01:05.119 align:start position:0%
work a bit differently and that's
because<00:01:02.489><c> it's</c><00:01:02.670><c> Row</c><00:01:02.910><c> two</c><00:01:02.970><c> and</c><00:01:03.660><c> you</c><00:01:04.500><c> can</c><00:01:04.680><c> see</c><00:01:04.890><c> why</c>

00:01:05.119 --> 00:01:05.129 align:start position:0%
because it's Row two and you can see why
 

00:01:05.129 --> 00:01:07.030 align:start position:0%
because it's Row two and you can see why
if<00:01:05.400><c> I</c><00:01:05.489><c> go</c><00:01:05.670><c> to</c><00:01:05.729><c> the</c><00:01:05.880><c> freeze</c><00:01:06.180><c> panes</c><00:01:06.450><c> command</c>

00:01:07.030 --> 00:01:07.040 align:start position:0%
if I go to the freeze panes command
 

00:01:07.040 --> 00:01:09.590 align:start position:0%
if I go to the freeze panes command
there's<00:01:08.040><c> an</c><00:01:08.220><c> option</c><00:01:08.550><c> to</c><00:01:08.640><c> freeze</c><00:01:08.880><c> the</c><00:01:09.030><c> top</c><00:01:09.270><c> row</c>

00:01:09.590 --> 00:01:09.600 align:start position:0%
there's an option to freeze the top row
 

00:01:09.600 --> 00:01:11.870 align:start position:0%
there's an option to freeze the top row
but<00:01:10.229><c> there</c><00:01:10.350><c> isn't</c><00:01:10.590><c> an</c><00:01:10.650><c> option</c><00:01:10.830><c> to</c><00:01:11.070><c> freeze</c><00:01:11.310><c> just</c>

00:01:11.870 --> 00:01:11.880 align:start position:0%
but there isn't an option to freeze just
 

00:01:11.880 --> 00:01:14.690 align:start position:0%
but there isn't an option to freeze just
the<00:01:12.000><c> second</c><00:01:12.360><c> row</c><00:01:12.479><c> by</c><00:01:12.690><c> itself</c><00:01:13.310><c> instead</c><00:01:14.310><c> we'll</c>

00:01:14.690 --> 00:01:14.700 align:start position:0%
the second row by itself instead we'll
 

00:01:14.700 --> 00:01:17.660 align:start position:0%
the second row by itself instead we'll
need<00:01:14.850><c> to</c><00:01:14.970><c> freeze</c><00:01:15.240><c> the</c><00:01:15.450><c> top</c><00:01:15.660><c> two</c><00:01:16.020><c> rows</c><00:01:16.670><c> since</c>

00:01:17.660 --> 00:01:17.670 align:start position:0%
need to freeze the top two rows since
 

00:01:17.670 --> 00:01:19.340 align:start position:0%
need to freeze the top two rows since
we've<00:01:17.820><c> already</c><00:01:18.030><c> frozen</c><00:01:18.420><c> the</c><00:01:18.690><c> first</c><00:01:18.899><c> column</c>

00:01:19.340 --> 00:01:19.350 align:start position:0%
we've already frozen the first column
 

00:01:19.350 --> 00:01:21.590 align:start position:0%
we've already frozen the first column
will<00:01:19.770><c> first</c><00:01:20.100><c> need</c><00:01:20.310><c> to</c><00:01:20.369><c> reset</c><00:01:20.940><c> the</c><00:01:20.970><c> spreadsheet</c>

00:01:21.590 --> 00:01:21.600 align:start position:0%
will first need to reset the spreadsheet
 

00:01:21.600 --> 00:01:24.830 align:start position:0%
will first need to reset the spreadsheet
by<00:01:21.840><c> selecting</c><00:01:22.410><c> unfreeze</c><00:01:23.130><c> panes</c><00:01:23.160><c> and</c><00:01:23.850><c> now</c><00:01:24.780><c> you</c>

00:01:24.830 --> 00:01:24.840 align:start position:0%
by selecting unfreeze panes and now you
 

00:01:24.840 --> 00:01:27.859 align:start position:0%
by selecting unfreeze panes and now you
have<00:01:25.170><c> two</c><00:01:25.380><c> options</c><00:01:25.590><c> you</c><00:01:26.210><c> can</c><00:01:27.210><c> either</c><00:01:27.540><c> select</c>

00:01:27.859 --> 00:01:27.869 align:start position:0%
have two options you can either select
 

00:01:27.869 --> 00:01:29.900 align:start position:0%
have two options you can either select
the<00:01:28.140><c> row</c><00:01:28.380><c> below</c><00:01:28.649><c> the</c><00:01:29.070><c> rows</c><00:01:29.280><c> that</c><00:01:29.310><c> you</c><00:01:29.610><c> want</c><00:01:29.820><c> to</c>

00:01:29.900 --> 00:01:29.910 align:start position:0%
the row below the rows that you want to
 

00:01:29.910 --> 00:01:32.510 align:start position:0%
the row below the rows that you want to
freeze<00:01:30.270><c> as</c><00:01:30.600><c> we're</c><00:01:31.320><c> three</c><00:01:31.649><c> in</c><00:01:31.800><c> this</c><00:01:31.920><c> case</c><00:01:32.220><c> or</c>

00:01:32.510 --> 00:01:32.520 align:start position:0%
freeze as we're three in this case or
 

00:01:32.520 --> 00:01:35.600 align:start position:0%
freeze as we're three in this case or
you<00:01:33.270><c> can</c><00:01:33.450><c> select</c><00:01:33.660><c> a</c><00:01:33.930><c> single</c><00:01:34.170><c> cell</c><00:01:34.560><c> such</c><00:01:35.220><c> as</c><00:01:35.250><c> b3</c>

00:01:35.600 --> 00:01:35.610 align:start position:0%
you can select a single cell such as b3
 

00:01:35.610 --> 00:01:38.930 align:start position:0%
you can select a single cell such as b3
if<00:01:36.090><c> you</c><00:01:37.080><c> select</c><00:01:37.410><c> only</c><00:01:37.590><c> one</c><00:01:37.740><c> cell</c><00:01:38.310><c> it</c><00:01:38.610><c> will</c>

00:01:38.930 --> 00:01:38.940 align:start position:0%
if you select only one cell it will
 

00:01:38.940 --> 00:01:41.180 align:start position:0%
if you select only one cell it will
freeze<00:01:39.240><c> the</c><00:01:39.270><c> rows</c><00:01:39.660><c> above</c><00:01:39.960><c> it</c><00:01:40.140><c> and</c><00:01:40.290><c> also</c><00:01:41.009><c> any</c>

00:01:41.180 --> 00:01:41.190 align:start position:0%
freeze the rows above it and also any
 

00:01:41.190 --> 00:01:43.520 align:start position:0%
freeze the rows above it and also any
columns<00:01:41.610><c> to</c><00:01:41.790><c> the</c><00:01:41.910><c> left</c><00:01:41.940><c> and</c><00:01:42.539><c> that's</c><00:01:43.110><c> exactly</c>

00:01:43.520 --> 00:01:43.530 align:start position:0%
columns to the left and that's exactly
 

00:01:43.530 --> 00:01:47.270 align:start position:0%
columns to the left and that's exactly
what<00:01:43.890><c> we</c><00:01:44.009><c> want</c><00:01:44.280><c> here</c><00:01:45.259><c> next</c><00:01:46.259><c> go</c><00:01:46.830><c> to</c><00:01:46.860><c> the</c><00:01:47.009><c> freeze</c>

00:01:47.270 --> 00:01:47.280 align:start position:0%
what we want here next go to the freeze
 

00:01:47.280 --> 00:01:51.179 align:start position:0%
what we want here next go to the freeze
panes<00:01:47.490><c> command</c><00:01:47.700><c> and</c><00:01:48.270><c> select</c><00:01:48.659><c> freeze</c><00:01:49.530><c> panes</c>

00:01:51.179 --> 00:01:51.189 align:start position:0%
panes command and select freeze panes
 

00:01:51.189 --> 00:01:53.459 align:start position:0%
panes command and select freeze panes
and<00:01:51.820><c> now</c><00:01:51.969><c> you</c><00:01:52.030><c> can</c><00:01:52.240><c> see</c><00:01:52.450><c> a</c><00:01:52.479><c> thin</c><00:01:52.899><c> line</c><00:01:53.200><c> in</c>

00:01:53.459 --> 00:01:53.469 align:start position:0%
and now you can see a thin line in
 

00:01:53.469 --> 00:01:56.069 align:start position:0%
and now you can see a thin line in
between<00:01:53.829><c> rows</c><00:01:54.039><c> 2</c><00:01:54.369><c> &amp;</c><00:01:54.549><c> 3</c><00:01:54.579><c> and</c><00:01:55.060><c> also</c><00:01:55.749><c> a</c><00:01:55.780><c> line</c>

00:01:56.069 --> 00:01:56.079 align:start position:0%
between rows 2 &amp; 3 and also a line
 

00:01:56.079 --> 00:01:59.429 align:start position:0%
between rows 2 &amp; 3 and also a line
between<00:01:56.319><c> columns</c><00:01:56.950><c> a</c><00:01:57.100><c> and</c><00:01:57.159><c> B</c><00:01:57.630><c> when</c><00:01:58.630><c> I</c><00:01:58.659><c> scroll</c><00:01:59.170><c> I</c>

00:01:59.429 --> 00:01:59.439 align:start position:0%
between columns a and B when I scroll I
 

00:01:59.439 --> 00:02:01.380 align:start position:0%
between columns a and B when I scroll I
can<00:01:59.890><c> see</c><00:02:00.069><c> all</c><00:02:00.250><c> of</c><00:02:00.280><c> my</c><00:02:00.670><c> header</c><00:02:00.880><c> rows</c><00:02:01.119><c> and</c>

00:02:01.380 --> 00:02:01.390 align:start position:0%
can see all of my header rows and
 

00:02:01.390 --> 00:02:03.059 align:start position:0%
can see all of my header rows and
columns<00:02:01.780><c> no</c><00:02:02.049><c> matter</c><00:02:02.200><c> where</c><00:02:02.469><c> I</c><00:02:02.500><c> am</c><00:02:02.829><c> in</c><00:02:02.979><c> the</c>

00:02:03.059 --> 00:02:03.069 align:start position:0%
columns no matter where I am in the
 

00:02:03.069 --> 00:02:06.330 align:start position:0%
columns no matter where I am in the
spreadsheet<00:02:04.740><c> sometimes</c><00:02:05.740><c> you</c><00:02:05.890><c> may</c><00:02:06.039><c> need</c><00:02:06.189><c> to</c>

00:02:06.330 --> 00:02:06.340 align:start position:0%
spreadsheet sometimes you may need to
 

00:02:06.340 --> 00:02:07.649 align:start position:0%
spreadsheet sometimes you may need to
work<00:02:06.490><c> with</c><00:02:06.729><c> different</c><00:02:06.969><c> parts</c><00:02:07.450><c> of</c><00:02:07.539><c> the</c>

00:02:07.649 --> 00:02:07.659 align:start position:0%
work with different parts of the
 

00:02:07.659 --> 00:02:09.960 align:start position:0%
work with different parts of the
spreadsheet<00:02:08.140><c> at</c><00:02:08.229><c> the</c><00:02:08.349><c> same</c><00:02:08.590><c> time</c><00:02:08.860><c> there</c><00:02:09.789><c> are</c><00:02:09.819><c> a</c>

00:02:09.960 --> 00:02:09.970 align:start position:0%
spreadsheet at the same time there are a
 

00:02:09.970 --> 00:02:12.270 align:start position:0%
spreadsheet at the same time there are a
couple<00:02:10.149><c> of</c><00:02:10.360><c> ways</c><00:02:10.539><c> to</c><00:02:10.720><c> do</c><00:02:10.869><c> this</c><00:02:10.899><c> one</c><00:02:11.290><c> is</c><00:02:12.129><c> to</c>

00:02:12.270 --> 00:02:12.280 align:start position:0%
couple of ways to do this one is to
 

00:02:12.280 --> 00:02:14.160 align:start position:0%
couple of ways to do this one is to
click<00:02:12.430><c> the</c><00:02:12.700><c> new</c><00:02:12.730><c> window</c><00:02:13.269><c> command</c><00:02:13.660><c> on</c><00:02:13.810><c> the</c><00:02:13.930><c> View</c>

00:02:14.160 --> 00:02:14.170 align:start position:0%
click the new window command on the View
 

00:02:14.170 --> 00:02:16.199 align:start position:0%
click the new window command on the View
tab<00:02:14.319><c> this</c><00:02:15.010><c> will</c><00:02:15.069><c> give</c><00:02:15.430><c> you</c><00:02:15.549><c> two</c><00:02:15.790><c> separate</c>

00:02:16.199 --> 00:02:16.209 align:start position:0%
tab this will give you two separate
 

00:02:16.209 --> 00:02:17.910 align:start position:0%
tab this will give you two separate
windows<00:02:16.330><c> and</c><00:02:16.900><c> you</c><00:02:17.049><c> may</c><00:02:17.200><c> need</c><00:02:17.349><c> to</c><00:02:17.410><c> rearrange</c>

00:02:17.910 --> 00:02:17.920 align:start position:0%
windows and you may need to rearrange
 

00:02:17.920 --> 00:02:19.830 align:start position:0%
windows and you may need to rearrange
them<00:02:18.370><c> so</c><00:02:18.430><c> that</c><00:02:18.700><c> you</c><00:02:18.790><c> can</c><00:02:19.000><c> view</c><00:02:19.209><c> both</c><00:02:19.420><c> at</c><00:02:19.690><c> the</c>

00:02:19.830 --> 00:02:19.840 align:start position:0%
them so that you can view both at the
 

00:02:19.840 --> 00:02:23.580 align:start position:0%
them so that you can view both at the
same<00:02:20.080><c> time</c><00:02:21.720><c> both</c><00:02:22.720><c> of</c><00:02:22.780><c> these</c><00:02:23.080><c> windows</c><00:02:23.440><c> are</c>

00:02:23.580 --> 00:02:23.590 align:start position:0%
same time both of these windows are
 

00:02:23.590 --> 00:02:25.770 align:start position:0%
same time both of these windows are
showing<00:02:23.920><c> the</c><00:02:24.010><c> same</c><00:02:24.280><c> file</c><00:02:24.640><c> and</c><00:02:24.970><c> we</c><00:02:25.269><c> can</c><00:02:25.450><c> use</c><00:02:25.599><c> it</c>

00:02:25.770 --> 00:02:25.780 align:start position:0%
showing the same file and we can use it
 

00:02:25.780 --> 00:02:27.420 align:start position:0%
showing the same file and we can use it
to<00:02:25.900><c> view</c><00:02:26.110><c> two</c><00:02:26.470><c> different</c><00:02:26.890><c> parts</c><00:02:27.190><c> of</c><00:02:27.310><c> the</c>

00:02:27.420 --> 00:02:27.430 align:start position:0%
to view two different parts of the
 

00:02:27.430 --> 00:02:29.670 align:start position:0%
to view two different parts of the
worksheet<00:02:27.879><c> or</c><00:02:28.239><c> if</c><00:02:28.780><c> the</c><00:02:29.140><c> workbook</c><00:02:29.530><c> has</c>

00:02:29.670 --> 00:02:29.680 align:start position:0%
worksheet or if the workbook has
 

00:02:29.680 --> 00:02:31.979 align:start position:0%
worksheet or if the workbook has
multiple<00:02:30.280><c> sheets</c><00:02:30.579><c> you</c><00:02:31.060><c> can</c><00:02:31.239><c> view</c><00:02:31.450><c> two</c><00:02:31.510><c> of</c><00:02:31.810><c> them</c>

00:02:31.979 --> 00:02:31.989 align:start position:0%
multiple sheets you can view two of them
 

00:02:31.989 --> 00:02:34.800 align:start position:0%
multiple sheets you can view two of them
side<00:02:32.230><c> by</c><00:02:32.260><c> side</c><00:02:32.440><c> so</c><00:02:33.400><c> I</c><00:02:33.430><c> could</c><00:02:33.760><c> view</c><00:02:33.910><c> the</c><00:02:34.060><c> 2013</c>

00:02:34.800 --> 00:02:34.810 align:start position:0%
side by side so I could view the 2013
 

00:02:34.810 --> 00:02:37.860 align:start position:0%
side by side so I could view the 2013
sales<00:02:35.200><c> in</c><00:02:35.349><c> one</c><00:02:35.530><c> window</c><00:02:35.769><c> and</c><00:02:36.099><c> the</c><00:02:36.819><c> 2014</c><00:02:37.269><c> sales</c>

00:02:37.860 --> 00:02:37.870 align:start position:0%
sales in one window and the 2014 sales
 

00:02:37.870 --> 00:02:40.140 align:start position:0%
sales in one window and the 2014 sales
another<00:02:38.260><c> which</c><00:02:39.040><c> makes</c><00:02:39.280><c> it</c><00:02:39.400><c> very</c><00:02:39.610><c> easy</c><00:02:39.790><c> to</c>

00:02:40.140 --> 00:02:40.150 align:start position:0%
another which makes it very easy to
 

00:02:40.150 --> 00:02:42.900 align:start position:0%
another which makes it very easy to
compare<00:02:40.599><c> the</c><00:02:40.750><c> two</c><00:02:40.930><c> years</c><00:02:41.260><c> if</c><00:02:41.650><c> you</c><00:02:42.549><c> want</c><00:02:42.730><c> to</c><00:02:42.819><c> go</c>

00:02:42.900 --> 00:02:42.910 align:start position:0%
compare the two years if you want to go
 

00:02:42.910 --> 00:02:45.270 align:start position:0%
compare the two years if you want to go
back<00:02:43.090><c> to</c><00:02:43.239><c> just</c><00:02:43.480><c> one</c><00:02:43.750><c> window</c><00:02:44.170><c> you</c><00:02:44.859><c> can</c><00:02:45.040><c> close</c>

00:02:45.270 --> 00:02:45.280 align:start position:0%
back to just one window you can close
 

00:02:45.280 --> 00:02:46.920 align:start position:0%
back to just one window you can close
either<00:02:45.609><c> one</c><00:02:45.910><c> by</c><00:02:46.090><c> clicking</c><00:02:46.150><c> the</c><00:02:46.569><c> close</c><00:02:46.870><c> button</c>

00:02:46.920 --> 00:02:46.930 align:start position:0%
either one by clicking the close button
 

00:02:46.930 --> 00:02:49.650 align:start position:0%
either one by clicking the close button
in<00:02:47.470><c> the</c><00:02:47.560><c> upper</c><00:02:47.890><c> right</c><00:02:48.040><c> corner</c><00:02:48.329><c> you</c><00:02:49.329><c> can</c><00:02:49.540><c> then</c>

00:02:49.650 --> 00:02:49.660 align:start position:0%
in the upper right corner you can then
 

00:02:49.660 --> 00:02:51.930 align:start position:0%
in the upper right corner you can then
resize<00:02:49.930><c> the</c><00:02:50.349><c> window</c><00:02:50.650><c> as</c><00:02:50.829><c> needed</c><00:02:51.190><c> or</c><00:02:51.370><c> just</c>

00:02:51.930 --> 00:02:51.940 align:start position:0%
resize the window as needed or just
 

00:02:51.940 --> 00:02:54.509 align:start position:0%
resize the window as needed or just
click<00:02:52.090><c> the</c><00:02:52.239><c> maximize</c><00:02:52.420><c> button</c><00:02:53.250><c> another</c><00:02:54.250><c> way</c><00:02:54.459><c> to</c>

00:02:54.509 --> 00:02:54.519 align:start position:0%
click the maximize button another way to
 

00:02:54.519 --> 00:02:56.309 align:start position:0%
click the maximize button another way to
view<00:02:54.640><c> two</c><00:02:55.030><c> different</c><00:02:55.420><c> parts</c><00:02:55.690><c> of</c><00:02:55.780><c> a</c><00:02:55.870><c> worksheet</c>

00:02:56.309 --> 00:02:56.319 align:start position:0%
view two different parts of a worksheet
 

00:02:56.319 --> 00:02:59.190 align:start position:0%
view two different parts of a worksheet
is<00:02:56.500><c> to</c><00:02:56.799><c> use</c><00:02:56.950><c> the</c><00:02:57.130><c> split</c><00:02:57.400><c> feature</c><00:02:57.930><c> this</c><00:02:58.930><c> is</c><00:02:59.170><c> a</c>

00:02:59.190 --> 00:02:59.200 align:start position:0%
is to use the split feature this is a
 

00:02:59.200 --> 00:03:01.500 align:start position:0%
is to use the split feature this is a
little<00:02:59.650><c> bit</c><00:02:59.769><c> like</c><00:03:00.040><c> freezing</c><00:03:00.489><c> panes</c><00:03:00.700><c> except</c>

00:03:01.500 --> 00:03:01.510 align:start position:0%
little bit like freezing panes except
 

00:03:01.510 --> 00:03:03.210 align:start position:0%
little bit like freezing panes except
instead<00:03:01.750><c> of</c><00:03:01.840><c> freezing</c><00:03:02.200><c> them</c><00:03:02.500><c> you</c><00:03:03.069><c> can</c>

00:03:03.210 --> 00:03:03.220 align:start position:0%
instead of freezing them you can
 

00:03:03.220 --> 00:03:04.710 align:start position:0%
instead of freezing them you can
actually<00:03:03.639><c> scroll</c><00:03:03.970><c> each</c><00:03:04.239><c> section</c>

00:03:04.710 --> 00:03:04.720 align:start position:0%
actually scroll each section
 

00:03:04.720 --> 00:03:08.220 align:start position:0%
actually scroll each section
independently<00:03:06.419><c> first</c><00:03:07.419><c> if</c><00:03:07.750><c> you</c><00:03:08.049><c> have</c><00:03:08.200><c> any</c>

00:03:08.220 --> 00:03:08.230 align:start position:0%
independently first if you have any
 

00:03:08.230 --> 00:03:10.740 align:start position:0%
independently first if you have any
frozen<00:03:08.709><c> panes</c><00:03:09.220><c> you'll</c><00:03:09.910><c> need</c><00:03:10.090><c> to</c><00:03:10.209><c> go</c><00:03:10.359><c> back</c><00:03:10.389><c> to</c>

00:03:10.740 --> 00:03:10.750 align:start position:0%
frozen panes you'll need to go back to
 

00:03:10.750 --> 00:03:12.589 align:start position:0%
frozen panes you'll need to go back to
the<00:03:10.870><c> freeze</c><00:03:11.109><c> panes</c><00:03:11.380><c> command</c><00:03:11.950><c> then</c><00:03:12.549><c> choose</c>

00:03:12.589 --> 00:03:12.599 align:start position:0%
the freeze panes command then choose
 

00:03:12.599 --> 00:03:16.500 align:start position:0%
the freeze panes command then choose
unfreeze<00:03:13.599><c> panes</c><00:03:14.400><c> then</c><00:03:15.400><c> select</c><00:03:16.150><c> the</c><00:03:16.269><c> cell</c>

00:03:16.500 --> 00:03:16.510 align:start position:0%
unfreeze panes then select the cell
 

00:03:16.510 --> 00:03:17.940 align:start position:0%
unfreeze panes then select the cell
where<00:03:16.750><c> you</c><00:03:16.780><c> want</c><00:03:16.870><c> the</c><00:03:17.109><c> split</c><00:03:17.349><c> to</c><00:03:17.530><c> appear</c>

00:03:17.940 --> 00:03:17.950 align:start position:0%
where you want the split to appear
 

00:03:17.950 --> 00:03:19.770 align:start position:0%
where you want the split to appear
usually<00:03:18.519><c> somewhere</c><00:03:19.090><c> near</c><00:03:19.299><c> the</c><00:03:19.419><c> middle</c><00:03:19.660><c> of</c>

00:03:19.770 --> 00:03:19.780 align:start position:0%
usually somewhere near the middle of
 

00:03:19.780 --> 00:03:21.839 align:start position:0%
usually somewhere near the middle of
your<00:03:19.930><c> spreadsheet</c><00:03:20.280><c> and</c><00:03:21.280><c> then</c><00:03:21.430><c> click</c><00:03:21.700><c> the</c>

00:03:21.839 --> 00:03:21.849 align:start position:0%
your spreadsheet and then click the
 

00:03:21.849 --> 00:03:24.449 align:start position:0%
your spreadsheet and then click the
split<00:03:22.120><c> command</c><00:03:22.359><c> and</c><00:03:22.859><c> now</c><00:03:23.859><c> you</c><00:03:23.919><c> can</c><00:03:24.160><c> see</c><00:03:24.340><c> that</c>

00:03:24.449 --> 00:03:24.459 align:start position:0%
split command and now you can see that
 

00:03:24.459 --> 00:03:25.409 align:start position:0%
split command and now you can see that
there<00:03:24.639><c> are</c><00:03:24.669><c> vertical</c><00:03:25.209><c> and</c><00:03:25.389><c> horizontal</c>

00:03:25.409 --> 00:03:25.419 align:start position:0%
there are vertical and horizontal
 

00:03:25.419 --> 00:03:28.949 align:start position:0%
there are vertical and horizontal
dividers<00:03:26.639><c> there</c><00:03:27.639><c> are</c><00:03:27.760><c> also</c><00:03:27.880><c> four</c><00:03:28.269><c> scroll</c><00:03:28.660><c> bars</c>

00:03:28.949 --> 00:03:28.959 align:start position:0%
dividers there are also four scroll bars
 

00:03:28.959 --> 00:03:30.990 align:start position:0%
dividers there are also four scroll bars
which<00:03:29.410><c> we</c><00:03:29.560><c> can</c><00:03:29.769><c> use</c><00:03:30.010><c> to</c><00:03:30.040><c> scroll</c><00:03:30.489><c> the</c><00:03:30.669><c> different</c>

00:03:30.990 --> 00:03:31.000 align:start position:0%
which we can use to scroll the different
 

00:03:31.000 --> 00:03:34.110 align:start position:0%
which we can use to scroll the different
sections<00:03:31.950><c> now</c><00:03:32.950><c> if</c><00:03:33.130><c> you</c><00:03:33.250><c> find</c><00:03:33.459><c> that</c><00:03:33.639><c> this</c><00:03:33.819><c> view</c>

00:03:34.110 --> 00:03:34.120 align:start position:0%
sections now if you find that this view
 

00:03:34.120 --> 00:03:36.030 align:start position:0%
sections now if you find that this view
is<00:03:34.269><c> a</c><00:03:34.299><c> little</c><00:03:34.419><c> bit</c><00:03:34.840><c> too</c><00:03:35.019><c> cluttered</c><00:03:35.410><c> you</c><00:03:35.739><c> can</c>

00:03:36.030 --> 00:03:36.040 align:start position:0%
is a little bit too cluttered you can
 

00:03:36.040 --> 00:03:37.830 align:start position:0%
is a little bit too cluttered you can
make<00:03:36.190><c> it</c><00:03:36.310><c> simpler</c><00:03:36.700><c> by</c><00:03:36.970><c> removing</c><00:03:37.540><c> one</c><00:03:37.569><c> of</c><00:03:37.750><c> the</c>

00:03:37.830 --> 00:03:37.840 align:start position:0%
make it simpler by removing one of the
 

00:03:37.840 --> 00:03:40.470 align:start position:0%
make it simpler by removing one of the
dividers<00:03:38.380><c> if</c><00:03:38.680><c> you</c><00:03:39.669><c> drag</c><00:03:39.910><c> the</c><00:03:40.060><c> vertical</c>

00:03:40.470 --> 00:03:40.480 align:start position:0%
dividers if you drag the vertical
 

00:03:40.480 --> 00:03:42.809 align:start position:0%
dividers if you drag the vertical
divider<00:03:40.810><c> all</c><00:03:41.079><c> the</c><00:03:41.260><c> way</c><00:03:41.380><c> to</c><00:03:41.440><c> the</c><00:03:41.650><c> left</c><00:03:41.980><c> it</c><00:03:42.370><c> will</c>

00:03:42.809 --> 00:03:42.819 align:start position:0%
divider all the way to the left it will
 

00:03:42.819 --> 00:03:44.909 align:start position:0%
divider all the way to the left it will
disappear<00:03:43.510><c> and</c><00:03:43.690><c> you</c><00:03:43.750><c> just</c><00:03:44.290><c> have</c><00:03:44.500><c> a</c><00:03:44.530><c> horizontal</c>

00:03:44.909 --> 00:03:44.919 align:start position:0%
disappear and you just have a horizontal
 

00:03:44.919 --> 00:03:47.819 align:start position:0%
disappear and you just have a horizontal
divider<00:03:45.630><c> now</c><00:03:46.630><c> by</c><00:03:46.810><c> scrolling</c><00:03:47.230><c> the</c><00:03:47.260><c> top</c><00:03:47.590><c> and</c>

00:03:47.819 --> 00:03:47.829 align:start position:0%
divider now by scrolling the top and
 

00:03:47.829 --> 00:03:50.039 align:start position:0%
divider now by scrolling the top and
bottom<00:03:47.950><c> sections</c><00:03:48.549><c> we</c><00:03:49.150><c> can</c><00:03:49.180><c> compare</c><00:03:49.750><c> the</c><00:03:49.900><c> data</c>

00:03:50.039 --> 00:03:50.049 align:start position:0%
bottom sections we can compare the data
 

00:03:50.049 --> 00:03:52.280 align:start position:0%
bottom sections we can compare the data
for<00:03:50.349><c> any</c><00:03:50.379><c> two</c><00:03:50.709><c> salespeople</c><00:03:51.340><c> really</c><00:03:51.879><c> easily</c>

00:03:52.280 --> 00:03:52.290 align:start position:0%
for any two salespeople really easily
 

00:03:52.290 --> 00:03:55.940 align:start position:0%
for any two salespeople really easily
for<00:03:53.290><c> example</c><00:03:53.319><c> how</c><00:03:54.250><c> about</c><00:03:54.459><c> David</c><00:03:55.000><c> Carlson</c><00:03:55.239><c> and</c>

00:03:55.940 --> 00:03:55.950 align:start position:0%
for example how about David Carlson and
 

00:03:55.950 --> 00:03:58.559 align:start position:0%
for example how about David Carlson and
Moe<00:03:56.950><c> as</c><00:03:57.099><c> a</c><00:03:57.190><c> post</c>

00:03:58.559 --> 00:03:58.569 align:start position:0%
Moe as a post
 

00:03:58.569 --> 00:04:00.899 align:start position:0%
Moe as a post
depending<00:03:59.560><c> on</c><00:03:59.620><c> your</c><00:03:59.680><c> spreadsheet</c><00:04:00.040><c> some</c><00:04:00.819><c> of</c>

00:04:00.899 --> 00:04:00.909 align:start position:0%
depending on your spreadsheet some of
 

00:04:00.909 --> 00:04:02.459 align:start position:0%
depending on your spreadsheet some of
these<00:04:01.030><c> view</c><00:04:01.269><c> options</c><00:04:01.659><c> may</c><00:04:01.870><c> be</c><00:04:01.900><c> better</c><00:04:02.200><c> than</c>

00:04:02.459 --> 00:04:02.469 align:start position:0%
these view options may be better than
 

00:04:02.469 --> 00:04:04.979 align:start position:0%
these view options may be better than
others<00:04:02.560><c> in</c><00:04:02.950><c> this</c><00:04:03.609><c> example</c><00:04:04.000><c> the</c><00:04:04.510><c> header</c><00:04:04.719><c> rows</c>

00:04:04.979 --> 00:04:04.989 align:start position:0%
others in this example the header rows
 

00:04:04.989 --> 00:04:07.140 align:start position:0%
others in this example the header rows
and<00:04:05.200><c> columns</c><00:04:05.530><c> are</c><00:04:05.650><c> really</c><00:04:06.099><c> important</c><00:04:06.609><c> so</c><00:04:07.030><c> the</c>

00:04:07.140 --> 00:04:07.150 align:start position:0%
and columns are really important so the
 

00:04:07.150 --> 00:04:08.880 align:start position:0%
and columns are really important so the
freeze<00:04:07.390><c> panes</c><00:04:07.750><c> feature</c><00:04:08.019><c> is</c><00:04:08.260><c> probably</c><00:04:08.739><c> our</c>

00:04:08.880 --> 00:04:08.890 align:start position:0%
freeze panes feature is probably our
 

00:04:08.890 --> 00:04:11.490 align:start position:0%
freeze panes feature is probably our
best<00:04:09.040><c> choice</c><00:04:09.480><c> you'll</c><00:04:10.480><c> want</c><00:04:10.689><c> to</c><00:04:10.750><c> try</c><00:04:10.959><c> all</c><00:04:11.230><c> the</c>

00:04:11.490 --> 00:04:11.500 align:start position:0%
best choice you'll want to try all the
 

00:04:11.500 --> 00:04:12.990 align:start position:0%
best choice you'll want to try all the
view<00:04:11.680><c> options</c><00:04:12.129><c> and</c><00:04:12.340><c> see</c><00:04:12.459><c> which</c><00:04:12.760><c> one</c><00:04:12.969><c> works</c>

00:04:12.990 --> 00:04:13.000 align:start position:0%
view options and see which one works
 

00:04:13.000 --> 00:04:16.590 align:start position:0%
view options and see which one works
best<00:04:13.480><c> for</c><00:04:13.719><c> your</c><00:04:14.049><c> spreadsheet</c>