WEBVTT
Kind: captions
Language: en

00:00:00.410 --> 00:00:02.990 align:start position:0%
 
Goodwill<00:00:01.410><c> Community</c><00:00:01.890><c> Foundation</c><00:00:02.550><c> creating</c>

00:00:02.990 --> 00:00:03.000 align:start position:0%
Goodwill Community Foundation creating
 

00:00:03.000 --> 00:00:10.789 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:03.600><c> for</c><00:00:03.810><c> a</c><00:00:03.870><c> better</c><00:00:03.899><c> life</c>

00:00:10.789 --> 00:00:10.799 align:start position:0%
 
 

00:00:10.799 --> 00:00:13.320 align:start position:0%
 
Excel<00:00:11.799><c> worksheets</c><00:00:12.219><c> can</c><00:00:12.429><c> have</c><00:00:12.580><c> a</c><00:00:12.610><c> lot</c><00:00:12.940><c> of</c><00:00:12.969><c> cells</c>

00:00:13.320 --> 00:00:13.330 align:start position:0%
Excel worksheets can have a lot of cells
 

00:00:13.330 --> 00:00:15.390 align:start position:0%
Excel worksheets can have a lot of cells
and<00:00:13.599><c> sometimes</c><00:00:14.530><c> you</c><00:00:14.650><c> may</c><00:00:14.769><c> find</c><00:00:14.980><c> that</c><00:00:15.099><c> you</c><00:00:15.219><c> want</c>

00:00:15.390 --> 00:00:15.400 align:start position:0%
and sometimes you may find that you want
 

00:00:15.400 --> 00:00:16.620 align:start position:0%
and sometimes you may find that you want
to<00:00:15.490><c> view</c><00:00:15.670><c> two</c><00:00:15.910><c> different</c><00:00:16.209><c> parts</c><00:00:16.420><c> of</c><00:00:16.510><c> the</c>

00:00:16.620 --> 00:00:16.630 align:start position:0%
to view two different parts of the
 

00:00:16.630 --> 00:00:19.409 align:start position:0%
to view two different parts of the
spreadsheet<00:00:16.900><c> at</c><00:00:17.260><c> the</c><00:00:17.410><c> same</c><00:00:17.619><c> time</c><00:00:18.029><c> for</c><00:00:19.029><c> example</c>

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

00:00:19.419 --> 00:00:20.999 align:start position:0%
spreadsheet at the same time for example
in<00:00:19.570><c> this</c><00:00:19.750><c> spreadsheet</c><00:00:20.259><c> I</c><00:00:20.289><c> have</c><00:00:20.529><c> a</c><00:00:20.560><c> list</c><00:00:20.890><c> of</c>

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

00:00:21.009 --> 00:00:23.760 align:start position:0%
in this spreadsheet I have a list of
salespeople<00:00:21.580><c> in</c><00:00:21.880><c> the</c><00:00:22.029><c> first</c><00:00:22.300><c> column</c><00:00:22.650><c> but</c><00:00:23.650><c> when</c>

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

00:00:23.770 --> 00:00:24.960 align:start position:0%
salespeople in the first column but when
I<00:00:23.800><c> scroll</c><00:00:24.130><c> to</c><00:00:24.160><c> the</c><00:00:24.340><c> right</c><00:00:24.369><c> those</c><00:00:24.730><c> names</c>

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

00:00:24.970 --> 00:00:26.730 align:start position:0%
I scroll to the right those names
disappear<00:00:25.599><c> which</c><00:00:25.990><c> makes</c><00:00:26.200><c> it</c><00:00:26.320><c> really</c><00:00:26.349><c> hard</c><00:00:26.679><c> to</c>

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

00:00:26.740 --> 00:00:30.419 align:start position:0%
disappear which makes it really hard to
see<00:00:26.830><c> who</c><00:00:27.160><c> the</c><00:00:27.279><c> sales</c><00:00:27.490><c> data</c><00:00:27.699><c> belongs</c><00:00:28.119><c> to</c><00:00:29.250><c> we</c><00:00:30.250><c> can</c>

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

00:00:30.429 --> 00:00:32.820 align:start position:0%
see who the sales data belongs to we can
fix<00:00:30.640><c> this</c><00:00:30.910><c> by</c><00:00:30.970><c> freezing</c><00:00:31.420><c> the</c><00:00:31.660><c> first</c><00:00:31.960><c> column</c><00:00:32.410><c> so</c>

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

00:00:32.830 --> 00:00:36.299 align:start position:0%
fix this by freezing the first column so
it<00:00:32.980><c> will</c><00:00:33.100><c> always</c><00:00:33.400><c> stay</c><00:00:33.580><c> visible</c><00:00:34.800><c> first</c><00:00:35.800><c> go</c><00:00:36.250><c> to</c>

00:00:36.299 --> 00:00:36.309 align:start position:0%
it will always stay visible first go to
 

00:00:36.309 --> 00:00:41.189 align:start position:0%
it will always stay visible first go to
the<00:00:36.550><c> View</c><00:00:36.790><c> tab</c><00:00:36.970><c> and</c><00:00:37.530><c> click</c><00:00:38.530><c> freeze</c><00:00:39.010><c> panes</c><00:00:40.199><c> you</c>

00:00:41.189 --> 00:00:41.199 align:start position:0%
the View tab and click freeze panes you
 

00:00:41.199 --> 00:00:43.049 align:start position:0%
the View tab and click freeze panes you
have<00:00:41.320><c> a</c><00:00:41.350><c> few</c><00:00:41.650><c> different</c><00:00:41.830><c> options</c><00:00:42.129><c> but</c><00:00:42.730><c> we</c><00:00:42.940><c> just</c>

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

00:00:43.059 --> 00:00:46.209 align:start position:0%
have a few different options but we just
want<00:00:43.300><c> to</c><00:00:43.450><c> freeze</c><00:00:43.690><c> the</c><00:00:43.960><c> first</c><00:00:43.989><c> column</c>

00:00:46.209 --> 00:00:46.219 align:start position:0%
want to freeze the first column
 

00:00:46.219 --> 00:00:48.790 align:start position:0%
want to freeze the first column
now<00:00:47.120><c> when</c><00:00:47.300><c> we</c><00:00:47.420><c> scroll</c><00:00:47.690><c> we</c><00:00:47.930><c> can</c><00:00:48.109><c> easily</c><00:00:48.320><c> see</c><00:00:48.649><c> the</c>

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

00:00:48.800 --> 00:00:50.650 align:start position:0%
now when we scroll we can easily see the
names<00:00:48.980><c> of</c><00:00:49.129><c> each</c><00:00:49.399><c> salesperson</c><00:00:49.850><c> no</c><00:00:50.480><c> matter</c>

00:00:50.650 --> 00:00:50.660 align:start position:0%
names of each salesperson no matter
 

00:00:50.660 --> 00:00:53.939 align:start position:0%
names of each salesperson no matter
where<00:00:50.930><c> they</c><00:00:51.079><c> are</c><00:00:51.110><c> in</c><00:00:51.230><c> the</c><00:00:51.440><c> spreadsheet</c><00:00:51.920><c> the</c>

00:00:53.939 --> 00:00:53.949 align:start position:0%
where they are in the spreadsheet the
 

00:00:53.949 --> 00:00:56.649 align:start position:0%
where they are in the spreadsheet the
spreadsheet<00:00:54.949><c> also</c><00:00:55.339><c> has</c><00:00:55.519><c> dates</c><00:00:55.940><c> in</c><00:00:56.210><c> the</c><00:00:56.300><c> second</c>

00:00:56.649 --> 00:00:56.659 align:start position:0%
spreadsheet also has dates in the second
 

00:00:56.659 --> 00:00:58.630 align:start position:0%
spreadsheet also has dates in the second
row<00:00:56.809><c> and</c><00:00:57.079><c> I'd</c><00:00:57.589><c> like</c><00:00:57.710><c> to</c><00:00:57.860><c> freeze</c><00:00:58.100><c> them</c><00:00:58.430><c> so</c>

00:00:58.630 --> 00:00:58.640 align:start position:0%
row and I'd like to freeze them so
 

00:00:58.640 --> 00:01:00.270 align:start position:0%
row and I'd like to freeze them so
they'll<00:00:58.789><c> stay</c><00:00:59.000><c> visible</c><00:00:59.180><c> when</c><00:00:59.510><c> I</c><00:00:59.539><c> scroll</c><00:00:59.839><c> down</c>

00:01:00.270 --> 00:01:00.280 align:start position:0%
they'll stay visible when I scroll down
 

00:01:00.280 --> 00:01:02.619 align:start position:0%
they'll stay visible when I scroll down
but<00:01:01.280><c> this</c><00:01:01.430><c> time</c><00:01:01.640><c> is</c><00:01:01.789><c> going</c><00:01:02.000><c> to</c><00:01:02.030><c> work</c><00:01:02.239><c> a</c><00:01:02.390><c> little</c>

00:01:02.619 --> 00:01:02.629 align:start position:0%
but this time is going to work a little
 

00:01:02.629 --> 00:01:04.600 align:start position:0%
but this time is going to work a little
bit<00:01:02.750><c> differently</c><00:01:02.870><c> because</c><00:01:03.530><c> it's</c><00:01:03.860><c> Row</c><00:01:04.070><c> two</c><00:01:04.129><c> and</c>

00:01:04.600 --> 00:01:04.610 align:start position:0%
bit differently because it's Row two and
 

00:01:04.610 --> 00:01:06.609 align:start position:0%
bit differently because it's Row two and
you<00:01:05.089><c> can</c><00:01:05.119><c> see</c><00:01:05.299><c> why</c><00:01:05.690><c> if</c><00:01:05.990><c> you</c><00:01:06.080><c> go</c><00:01:06.200><c> to</c><00:01:06.259><c> the</c><00:01:06.409><c> freeze</c>

00:01:06.609 --> 00:01:06.619 align:start position:0%
you can see why if you go to the freeze
 

00:01:06.619 --> 00:01:09.370 align:start position:0%
you can see why if you go to the freeze
panes<00:01:06.890><c> command</c><00:01:07.869><c> there's</c><00:01:08.869><c> an</c><00:01:09.020><c> option</c><00:01:09.350><c> to</c>

00:01:09.370 --> 00:01:09.380 align:start position:0%
panes command there's an option to
 

00:01:09.380 --> 00:01:11.440 align:start position:0%
panes command there's an option to
freeze<00:01:09.649><c> the</c><00:01:09.860><c> top</c><00:01:10.100><c> row</c><00:01:10.340><c> but</c><00:01:10.909><c> there</c><00:01:11.090><c> isn't</c><00:01:11.240><c> an</c>

00:01:11.440 --> 00:01:11.450 align:start position:0%
freeze the top row but there isn't an
 

00:01:11.450 --> 00:01:13.300 align:start position:0%
freeze the top row but there isn't an
option<00:01:11.780><c> to</c><00:01:11.930><c> just</c><00:01:11.960><c> freeze</c><00:01:12.500><c> the</c><00:01:12.710><c> second</c><00:01:13.070><c> row</c><00:01:13.159><c> by</c>

00:01:13.300 --> 00:01:13.310 align:start position:0%
option to just freeze the second row by
 

00:01:13.310 --> 00:01:16.149 align:start position:0%
option to just freeze the second row by
itself<00:01:13.869><c> instead</c><00:01:14.869><c> we'll</c><00:01:15.350><c> need</c><00:01:15.500><c> to</c><00:01:15.649><c> freeze</c><00:01:15.890><c> the</c>

00:01:16.149 --> 00:01:16.159 align:start position:0%
itself instead we'll need to freeze the
 

00:01:16.159 --> 00:01:19.600 align:start position:0%
itself instead we'll need to freeze the
top<00:01:16.399><c> two</c><00:01:16.759><c> rows</c><00:01:17.830><c> since</c><00:01:18.830><c> we've</c><00:01:19.009><c> already</c><00:01:19.190><c> frozen</c>

00:01:19.600 --> 00:01:19.610 align:start position:0%
top two rows since we've already frozen
 

00:01:19.610 --> 00:01:22.029 align:start position:0%
top two rows since we've already frozen
the<00:01:19.820><c> first</c><00:01:20.090><c> column</c><00:01:20.479><c> we'll</c><00:01:20.960><c> need</c><00:01:21.140><c> to</c><00:01:21.350><c> reset</c><00:01:21.890><c> the</c>

00:01:22.029 --> 00:01:22.039 align:start position:0%
the first column we'll need to reset the
 

00:01:22.039 --> 00:01:24.190 align:start position:0%
the first column we'll need to reset the
spreadsheet<00:01:22.550><c> by</c><00:01:22.970><c> selecting</c><00:01:23.170><c> unfreeze</c><00:01:24.170><c> panes</c>

00:01:24.190 --> 00:01:24.200 align:start position:0%
spreadsheet by selecting unfreeze panes
 

00:01:24.200 --> 00:01:28.690 align:start position:0%
spreadsheet by selecting unfreeze panes
and<00:01:25.330><c> now</c><00:01:26.330><c> you</c><00:01:26.390><c> have</c><00:01:26.630><c> two</c><00:01:26.869><c> options</c><00:01:27.580><c> you</c><00:01:28.580><c> can</c>

00:01:28.690 --> 00:01:28.700 align:start position:0%
and now you have two options you can
 

00:01:28.700 --> 00:01:30.460 align:start position:0%
and now you have two options you can
either<00:01:28.759><c> select</c><00:01:29.420><c> the</c><00:01:29.509><c> row</c><00:01:29.690><c> below</c><00:01:29.929><c> the</c><00:01:30.319><c> rows</c>

00:01:30.460 --> 00:01:30.470 align:start position:0%
either select the row below the rows
 

00:01:30.470 --> 00:01:32.380 align:start position:0%
either select the row below the rows
that<00:01:30.500><c> you</c><00:01:30.740><c> want</c><00:01:30.920><c> to</c><00:01:31.039><c> freeze</c><00:01:31.369><c> or</c><00:01:31.640><c> you</c><00:01:32.210><c> can</c>

00:01:32.380 --> 00:01:32.390 align:start position:0%
that you want to freeze or you can
 

00:01:32.390 --> 00:01:36.130 align:start position:0%
that you want to freeze or you can
select<00:01:32.720><c> a</c><00:01:32.840><c> single</c><00:01:33.110><c> cell</c><00:01:33.619><c> such</c><00:01:34.220><c> as</c><00:01:34.250><c> b3</c><00:01:34.640><c> if</c><00:01:35.179><c> you</c>

00:01:36.130 --> 00:01:36.140 align:start position:0%
select a single cell such as b3 if you
 

00:01:36.140 --> 00:01:38.139 align:start position:0%
select a single cell such as b3 if you
only<00:01:36.289><c> select</c><00:01:36.560><c> one</c><00:01:36.979><c> cell</c><00:01:37.009><c> it</c><00:01:37.640><c> will</c><00:01:37.819><c> freeze</c><00:01:38.119><c> the</c>

00:01:38.139 --> 00:01:38.149 align:start position:0%
only select one cell it will freeze the
 

00:01:38.149 --> 00:01:40.809 align:start position:0%
only select one cell it will freeze the
rows<00:01:38.630><c> above</c><00:01:38.990><c> it</c><00:01:39.170><c> and</c><00:01:39.319><c> also</c><00:01:40.130><c> the</c><00:01:40.280><c> columns</c><00:01:40.640><c> to</c>

00:01:40.809 --> 00:01:40.819 align:start position:0%
rows above it and also the columns to
 

00:01:40.819 --> 00:01:43.499 align:start position:0%
rows above it and also the columns to
the<00:01:40.940><c> left</c><00:01:40.970><c> and</c><00:01:41.390><c> that's</c><00:01:41.780><c> exactly</c><00:01:42.229><c> what</c><00:01:42.380><c> we</c><00:01:42.500><c> want</c>

00:01:43.499 --> 00:01:43.509 align:start position:0%
the left and that's exactly what we want
 

00:01:43.509 --> 00:01:46.620 align:start position:0%
the left and that's exactly what we want
next<00:01:44.509><c> go</c><00:01:44.929><c> to</c><00:01:44.960><c> the</c><00:01:45.140><c> freeze</c><00:01:45.530><c> panes</c><00:01:45.860><c> command</c><00:01:46.009><c> and</c>

00:01:46.620 --> 00:01:46.630 align:start position:0%
next go to the freeze panes command and
 

00:01:46.630 --> 00:01:50.949 align:start position:0%
next go to the freeze panes command and
select<00:01:47.630><c> freeze</c><00:01:48.319><c> panes</c><00:01:48.710><c> and</c><00:01:49.539><c> now</c><00:01:50.539><c> you</c><00:01:50.599><c> can</c><00:01:50.810><c> see</c>

00:01:50.949 --> 00:01:50.959 align:start position:0%
select freeze panes and now you can see
 

00:01:50.959 --> 00:01:52.900 align:start position:0%
select freeze panes and now you can see
a<00:01:50.989><c> thin</c><00:01:51.319><c> line</c><00:01:51.530><c> in</c><00:01:51.770><c> between</c><00:01:52.099><c> rows</c><00:01:52.399><c> two</c><00:01:52.729><c> and</c>

00:01:52.900 --> 00:01:52.910 align:start position:0%
a thin line in between rows two and
 

00:01:52.910 --> 00:01:55.749 align:start position:0%
a thin line in between rows two and
three<00:01:53.209><c> and</c><00:01:53.470><c> also</c><00:01:54.470><c> aligned</c><00:01:54.739><c> between</c><00:01:54.920><c> columns</c><00:01:55.520><c> a</c>

00:01:55.749 --> 00:01:55.759 align:start position:0%
three and also aligned between columns a
 

00:01:55.759 --> 00:01:59.559 align:start position:0%
three and also aligned between columns a
and<00:01:55.789><c> B</c><00:01:57.160><c> when</c><00:01:58.160><c> I</c><00:01:58.190><c> scroll</c><00:01:58.550><c> I</c><00:01:58.789><c> can</c><00:01:58.940><c> see</c><00:01:59.149><c> all</c><00:01:59.360><c> of</c><00:01:59.390><c> my</c>

00:01:59.559 --> 00:01:59.569 align:start position:0%
and B when I scroll I can see all of my
 

00:01:59.569 --> 00:02:01.719 align:start position:0%
and B when I scroll I can see all of my
header<00:01:59.929><c> rows</c><00:02:00.170><c> and</c><00:02:00.470><c> columns</c><00:02:00.920><c> no</c><00:02:01.340><c> matter</c><00:02:01.520><c> where</c>

00:02:01.719 --> 00:02:01.729 align:start position:0%
header rows and columns no matter where
 

00:02:01.729 --> 00:02:07.449 align:start position:0%
header rows and columns no matter where
I<00:02:01.759><c> am</c><00:02:01.970><c> in</c><00:02:02.149><c> the</c><00:02:02.209><c> spreadsheet</c><00:02:06.310><c> sometimes</c><00:02:07.310><c> you</c>

00:02:07.449 --> 00:02:07.459 align:start position:0%
I am in the spreadsheet sometimes you
 

00:02:07.459 --> 00:02:08.830 align:start position:0%
I am in the spreadsheet sometimes you
may<00:02:07.580><c> need</c><00:02:07.759><c> to</c><00:02:07.910><c> work</c><00:02:08.060><c> with</c><00:02:08.300><c> two</c><00:02:08.539><c> different</c>

00:02:08.830 --> 00:02:08.840 align:start position:0%
may need to work with two different
 

00:02:08.840 --> 00:02:10.119 align:start position:0%
may need to work with two different
parts<00:02:09.050><c> of</c><00:02:09.140><c> the</c><00:02:09.259><c> spreadsheet</c><00:02:09.649><c> at</c><00:02:09.830><c> the</c><00:02:09.920><c> same</c>

00:02:10.119 --> 00:02:10.129 align:start position:0%
parts of the spreadsheet at the same
 

00:02:10.129 --> 00:02:12.339 align:start position:0%
parts of the spreadsheet at the same
time<00:02:10.459><c> there</c><00:02:11.360><c> are</c><00:02:11.480><c> a</c><00:02:11.540><c> couple</c><00:02:11.690><c> of</c><00:02:11.810><c> ways</c><00:02:11.989><c> to</c><00:02:12.200><c> do</c>

00:02:12.339 --> 00:02:12.349 align:start position:0%
time there are a couple of ways to do
 

00:02:12.349 --> 00:02:12.699 align:start position:0%
time there are a couple of ways to do
this

00:02:12.699 --> 00:02:12.709 align:start position:0%
this
 

00:02:12.709 --> 00:02:15.280 align:start position:0%
this
one<00:02:13.670><c> way</c><00:02:13.819><c> is</c><00:02:14.060><c> to</c><00:02:14.090><c> click</c><00:02:14.450><c> the</c><00:02:14.629><c> new</c><00:02:14.870><c> window</c>

00:02:15.280 --> 00:02:15.290 align:start position:0%
one way is to click the new window
 

00:02:15.290 --> 00:02:16.730 align:start position:0%
one way is to click the new window
command

00:02:16.730 --> 00:02:16.740 align:start position:0%
command
 

00:02:16.740 --> 00:02:18.920 align:start position:0%
command
this<00:02:17.370><c> will</c><00:02:17.520><c> give</c><00:02:17.640><c> you</c><00:02:17.730><c> two</c><00:02:18.030><c> separate</c><00:02:18.570><c> windows</c>

00:02:18.920 --> 00:02:18.930 align:start position:0%
this will give you two separate windows
 

00:02:18.930 --> 00:02:21.110 align:start position:0%
this will give you two separate windows
and<00:02:19.230><c> you</c><00:02:19.830><c> may</c><00:02:19.920><c> need</c><00:02:20.040><c> to</c><00:02:20.100><c> drag</c><00:02:20.400><c> the</c><00:02:20.430><c> top</c><00:02:20.790><c> of</c><00:02:20.940><c> each</c>

00:02:21.110 --> 00:02:21.120 align:start position:0%
and you may need to drag the top of each
 

00:02:21.120 --> 00:02:25.369 align:start position:0%
and you may need to drag the top of each
window<00:02:21.510><c> so</c><00:02:21.690><c> you</c><00:02:21.780><c> can</c><00:02:21.930><c> see</c><00:02:22.110><c> both</c><00:02:22.320><c> of</c><00:02:22.350><c> them</c>

00:02:25.369 --> 00:02:25.379 align:start position:0%
 
 

00:02:25.379 --> 00:02:27.869 align:start position:0%
 
both<00:02:26.379><c> of</c><00:02:26.560><c> these</c><00:02:26.680><c> worksheets</c><00:02:27.129><c> are</c><00:02:27.370><c> showing</c><00:02:27.730><c> the</c>

00:02:27.869 --> 00:02:27.879 align:start position:0%
both of these worksheets are showing the
 

00:02:27.879 --> 00:02:30.750 align:start position:0%
both of these worksheets are showing the
same<00:02:28.180><c> file</c><00:02:28.629><c> and</c><00:02:28.959><c> we</c><00:02:29.709><c> can</c><00:02:29.890><c> use</c><00:02:30.069><c> it</c><00:02:30.220><c> to</c><00:02:30.340><c> view</c><00:02:30.519><c> two</c>

00:02:30.750 --> 00:02:30.760 align:start position:0%
same file and we can use it to view two
 

00:02:30.760 --> 00:02:34.350 align:start position:0%
same file and we can use it to view two
different<00:02:31.090><c> parts</c><00:02:31.329><c> of</c><00:02:31.450><c> the</c><00:02:31.569><c> worksheet</c><00:02:32.939><c> or</c><00:02:33.939><c> if</c>

00:02:34.350 --> 00:02:34.360 align:start position:0%
different parts of the worksheet or if
 

00:02:34.360 --> 00:02:36.569 align:start position:0%
different parts of the worksheet or if
the<00:02:34.510><c> workbook</c><00:02:34.870><c> has</c><00:02:35.049><c> multiple</c><00:02:35.560><c> sheets</c><00:02:35.890><c> you</c><00:02:36.430><c> can</c>

00:02:36.569 --> 00:02:36.579 align:start position:0%
the workbook has multiple sheets you can
 

00:02:36.579 --> 00:02:39.539 align:start position:0%
the workbook has multiple sheets you can
view<00:02:36.700><c> two</c><00:02:36.970><c> of</c><00:02:37.120><c> them</c><00:02:37.269><c> side</c><00:02:37.569><c> by</c><00:02:37.599><c> side</c><00:02:38.310><c> so</c><00:02:39.310><c> I</c><00:02:39.340><c> could</c>

00:02:39.539 --> 00:02:39.549 align:start position:0%
view two of them side by side so I could
 

00:02:39.549 --> 00:02:41.580 align:start position:0%
view two of them side by side so I could
view<00:02:39.670><c> the</c><00:02:39.790><c> 2010</c><00:02:40.329><c> sales</c><00:02:40.599><c> in</c><00:02:40.840><c> one</c><00:02:41.049><c> window</c><00:02:41.379><c> and</c>

00:02:41.580 --> 00:02:41.590 align:start position:0%
view the 2010 sales in one window and
 

00:02:41.590 --> 00:02:44.160 align:start position:0%
view the 2010 sales in one window and
the<00:02:42.010><c> 2012</c><00:02:42.579><c> sales</c><00:02:42.879><c> and</c><00:02:43.180><c> another</c><00:02:43.450><c> which</c><00:02:43.900><c> makes</c>

00:02:44.160 --> 00:02:44.170 align:start position:0%
the 2012 sales and another which makes
 

00:02:44.170 --> 00:02:46.670 align:start position:0%
the 2012 sales and another which makes
it<00:02:44.319><c> very</c><00:02:44.530><c> easy</c><00:02:44.680><c> to</c><00:02:44.950><c> compare</c><00:02:45.370><c> the</c><00:02:45.579><c> two</c><00:02:45.610><c> years</c><00:02:46.000><c> if</c>

00:02:46.670 --> 00:02:46.680 align:start position:0%
it very easy to compare the two years if
 

00:02:46.680 --> 00:02:49.259 align:start position:0%
it very easy to compare the two years if
you<00:02:47.680><c> want</c><00:02:47.860><c> to</c><00:02:47.920><c> go</c><00:02:48.010><c> back</c><00:02:48.190><c> to</c><00:02:48.370><c> just</c><00:02:48.670><c> viewing</c><00:02:49.000><c> one</c>

00:02:49.259 --> 00:02:49.269 align:start position:0%
you want to go back to just viewing one
 

00:02:49.269 --> 00:02:51.270 align:start position:0%
you want to go back to just viewing one
window<00:02:49.659><c> you</c><00:02:50.079><c> can</c><00:02:50.230><c> close</c><00:02:50.500><c> either</c><00:02:50.769><c> one</c><00:02:51.069><c> by</c>

00:02:51.270 --> 00:02:51.280 align:start position:0%
window you can close either one by
 

00:02:51.280 --> 00:02:52.830 align:start position:0%
window you can close either one by
clicking<00:02:51.340><c> the</c><00:02:51.730><c> close</c><00:02:51.940><c> button</c><00:02:52.209><c> in</c><00:02:52.480><c> the</c><00:02:52.540><c> upper</c>

00:02:52.830 --> 00:02:52.840 align:start position:0%
clicking the close button in the upper
 

00:02:52.840 --> 00:02:55.860 align:start position:0%
clicking the close button in the upper
right<00:02:52.989><c> corner</c><00:02:53.200><c> and</c><00:02:53.909><c> then</c><00:02:54.909><c> you</c><00:02:55.090><c> can</c><00:02:55.239><c> resize</c><00:02:55.659><c> the</c>

00:02:55.860 --> 00:02:55.870 align:start position:0%
right corner and then you can resize the
 

00:02:55.870 --> 00:02:59.119 align:start position:0%
right corner and then you can resize the
window<00:02:56.140><c> or</c><00:02:56.349><c> click</c><00:02:56.379><c> the</c><00:02:56.650><c> maximize</c><00:02:56.950><c> button</c>

00:02:59.119 --> 00:02:59.129 align:start position:0%
window or click the maximize button
 

00:02:59.129 --> 00:03:01.440 align:start position:0%
window or click the maximize button
another<00:03:00.129><c> way</c><00:03:00.370><c> to</c><00:03:00.430><c> view</c><00:03:00.640><c> two</c><00:03:00.940><c> different</c><00:03:01.269><c> parts</c>

00:03:01.440 --> 00:03:01.450 align:start position:0%
another way to view two different parts
 

00:03:01.450 --> 00:03:02.940 align:start position:0%
another way to view two different parts
of<00:03:01.540><c> a</c><00:03:01.629><c> worksheet</c><00:03:01.989><c> is</c><00:03:02.170><c> to</c><00:03:02.379><c> use</c><00:03:02.560><c> the</c><00:03:02.739><c> split</c>

00:03:02.940 --> 00:03:02.950 align:start position:0%
of a worksheet is to use the split
 

00:03:02.950 --> 00:03:05.129 align:start position:0%
of a worksheet is to use the split
feature<00:03:03.250><c> this</c><00:03:04.239><c> is</c><00:03:04.420><c> a</c><00:03:04.450><c> little</c><00:03:04.840><c> bit</c><00:03:04.959><c> like</c>

00:03:05.129 --> 00:03:05.139 align:start position:0%
feature this is a little bit like
 

00:03:05.139 --> 00:03:07.020 align:start position:0%
feature this is a little bit like
freezing<00:03:05.590><c> panes</c><00:03:05.799><c> except</c><00:03:06.609><c> instead</c><00:03:06.909><c> of</c>

00:03:07.020 --> 00:03:07.030 align:start position:0%
freezing panes except instead of
 

00:03:07.030 --> 00:03:08.729 align:start position:0%
freezing panes except instead of
freezing<00:03:07.359><c> them</c><00:03:07.659><c> you</c><00:03:07.900><c> can</c><00:03:08.049><c> actually</c><00:03:08.230><c> scroll</c>

00:03:08.729 --> 00:03:08.739 align:start position:0%
freezing them you can actually scroll
 

00:03:08.739 --> 00:03:12.449 align:start position:0%
freezing them you can actually scroll
each<00:03:09.069><c> section</c><00:03:09.609><c> individually</c><00:03:11.010><c> first</c><00:03:12.010><c> if</c><00:03:12.310><c> you</c>

00:03:12.449 --> 00:03:12.459 align:start position:0%
each section individually first if you
 

00:03:12.459 --> 00:03:14.520 align:start position:0%
each section individually first if you
have<00:03:12.609><c> any</c><00:03:12.730><c> frozen</c><00:03:13.060><c> panes</c><00:03:13.510><c> you'll</c><00:03:14.109><c> need</c><00:03:14.349><c> to</c>

00:03:14.520 --> 00:03:14.530 align:start position:0%
have any frozen panes you'll need to
 

00:03:14.530 --> 00:03:18.360 align:start position:0%
have any frozen panes you'll need to
unfreeze<00:03:15.159><c> panes</c><00:03:16.590><c> then</c><00:03:17.590><c> select</c><00:03:18.040><c> the</c><00:03:18.159><c> cell</c>

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

00:03:18.370 --> 00:03:19.649 align:start position:0%
unfreeze panes then select the cell
where<00:03:18.519><c> you</c><00:03:18.549><c> want</c><00:03:18.790><c> the</c><00:03:18.879><c> split</c><00:03:18.970><c> to</c><00:03:19.239><c> appear</c>

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

00:03:19.659 --> 00:03:22.039 align:start position:0%
where you want the split to appear
usually<00:03:20.560><c> somewhere</c><00:03:20.859><c> near</c><00:03:21.040><c> the</c><00:03:21.129><c> middle</c><00:03:21.370><c> and</c>

00:03:22.039 --> 00:03:22.049 align:start position:0%
usually somewhere near the middle and
 

00:03:22.049 --> 00:03:26.430 align:start position:0%
usually somewhere near the middle and
then<00:03:23.049><c> click</c><00:03:23.319><c> the</c><00:03:23.530><c> split</c><00:03:23.739><c> command</c><00:03:25.200><c> you</c><00:03:26.200><c> can</c><00:03:26.319><c> now</c>

00:03:26.430 --> 00:03:26.440 align:start position:0%
then click the split command you can now
 

00:03:26.440 --> 00:03:28.020 align:start position:0%
then click the split command you can now
see<00:03:26.680><c> that</c><00:03:26.709><c> there</c><00:03:27.040><c> are</c><00:03:27.069><c> vertical</c><00:03:27.790><c> and</c>

00:03:28.020 --> 00:03:28.030 align:start position:0%
see that there are vertical and
 

00:03:28.030 --> 00:03:31.020 align:start position:0%
see that there are vertical and
horizontal<00:03:28.060><c> dividers</c><00:03:29.250><c> there</c><00:03:30.250><c> are</c><00:03:30.400><c> also</c><00:03:30.519><c> four</c>

00:03:31.020 --> 00:03:31.030 align:start position:0%
horizontal dividers there are also four
 

00:03:31.030 --> 00:03:32.970 align:start position:0%
horizontal dividers there are also four
scroll<00:03:31.480><c> bars</c><00:03:31.720><c> which</c><00:03:32.019><c> you</c><00:03:32.049><c> can</c><00:03:32.319><c> use</c><00:03:32.470><c> to</c><00:03:32.500><c> scroll</c>

00:03:32.970 --> 00:03:32.980 align:start position:0%
scroll bars which you can use to scroll
 

00:03:32.980 --> 00:03:39.000 align:start position:0%
scroll bars which you can use to scroll
the<00:03:33.129><c> different</c><00:03:33.430><c> sections</c><00:03:37.590><c> now</c><00:03:38.590><c> you</c><00:03:38.650><c> may</c><00:03:38.829><c> find</c>

00:03:39.000 --> 00:03:39.010 align:start position:0%
the different sections now you may find
 

00:03:39.010 --> 00:03:40.589 align:start position:0%
the different sections now you may find
that<00:03:39.129><c> this</c><00:03:39.310><c> view</c><00:03:39.549><c> is</c><00:03:39.730><c> a</c><00:03:39.760><c> little</c><00:03:40.030><c> too</c><00:03:40.269><c> cluttered</c>

00:03:40.589 --> 00:03:40.599 align:start position:0%
that this view is a little too cluttered
 

00:03:40.599 --> 00:03:42.900 align:start position:0%
that this view is a little too cluttered
but<00:03:41.139><c> you</c><00:03:41.260><c> can</c><00:03:41.410><c> make</c><00:03:41.530><c> it</c><00:03:41.590><c> simpler</c><00:03:42.129><c> by</c><00:03:42.370><c> removing</c>

00:03:42.900 --> 00:03:42.910 align:start position:0%
but you can make it simpler by removing
 

00:03:42.910 --> 00:03:45.720 align:start position:0%
but you can make it simpler by removing
one<00:03:43.060><c> of</c><00:03:43.180><c> the</c><00:03:43.269><c> dividers</c><00:03:43.510><c> if</c><00:03:44.220><c> you</c><00:03:45.220><c> drag</c><00:03:45.519><c> the</c>

00:03:45.720 --> 00:03:45.730 align:start position:0%
one of the dividers if you drag the
 

00:03:45.730 --> 00:03:47.520 align:start position:0%
one of the dividers if you drag the
vertical<00:03:45.940><c> divider</c><00:03:46.449><c> all</c><00:03:46.720><c> the</c><00:03:46.930><c> way</c><00:03:47.049><c> to</c><00:03:47.109><c> the</c><00:03:47.260><c> left</c>

00:03:47.520 --> 00:03:47.530 align:start position:0%
vertical divider all the way to the left
 

00:03:47.530 --> 00:03:51.360 align:start position:0%
vertical divider all the way to the left
it<00:03:48.449><c> will</c><00:03:49.449><c> disappear</c><00:03:50.230><c> and</c><00:03:50.379><c> you'll</c><00:03:50.859><c> just</c><00:03:51.099><c> have</c><00:03:51.340><c> a</c>

00:03:51.360 --> 00:03:51.370 align:start position:0%
it will disappear and you'll just have a
 

00:03:51.370 --> 00:03:55.140 align:start position:0%
it will disappear and you'll just have a
horizontal<00:03:51.760><c> divider</c><00:03:53.370><c> by</c><00:03:54.370><c> scrolling</c><00:03:54.730><c> the</c><00:03:54.849><c> top</c>

00:03:55.140 --> 00:03:55.150 align:start position:0%
horizontal divider by scrolling the top
 

00:03:55.150 --> 00:03:57.119 align:start position:0%
horizontal divider by scrolling the top
and<00:03:55.329><c> bottom</c><00:03:55.599><c> sections</c><00:03:56.049><c> we</c><00:03:56.410><c> can</c><00:03:56.440><c> compare</c><00:03:57.010><c> the</c>

00:03:57.119 --> 00:03:57.129 align:start position:0%
and bottom sections we can compare the
 

00:03:57.129 --> 00:04:00.180 align:start position:0%
and bottom sections we can compare the
data<00:03:57.250><c> for</c><00:03:57.549><c> any</c><00:03:57.760><c> two</c><00:03:58.000><c> salespeople</c><00:03:58.769><c> for</c><00:03:59.769><c> example</c>

00:04:00.180 --> 00:04:00.190 align:start position:0%
data for any two salespeople for example
 

00:04:00.190 --> 00:04:04.860 align:start position:0%
data for any two salespeople for example
David<00:04:00.459><c> Carlson</c><00:04:00.849><c> and</c><00:04:01.209><c> Melissa</c><00:04:02.019><c> Post</c><00:04:03.870><c> depending</c>

00:04:04.860 --> 00:04:04.870 align:start position:0%
David Carlson and Melissa Post depending
 

00:04:04.870 --> 00:04:06.390 align:start position:0%
David Carlson and Melissa Post depending
on<00:04:04.989><c> the</c><00:04:05.109><c> spreadsheet</c><00:04:05.410><c> some</c><00:04:05.949><c> of</c><00:04:06.040><c> these</c><00:04:06.160><c> view</c>

00:04:06.390 --> 00:04:06.400 align:start position:0%
on the spreadsheet some of these view
 

00:04:06.400 --> 00:04:08.039 align:start position:0%
on the spreadsheet some of these view
options<00:04:06.790><c> may</c><00:04:07.060><c> be</c><00:04:07.090><c> better</c><00:04:07.359><c> than</c><00:04:07.480><c> others</c><00:04:07.840><c> in</c>

00:04:08.039 --> 00:04:08.049 align:start position:0%
options may be better than others in
 

00:04:08.049 --> 00:04:10.439 align:start position:0%
options may be better than others in
this<00:04:08.799><c> example</c><00:04:09.190><c> the</c><00:04:09.430><c> header</c><00:04:09.609><c> rows</c><00:04:09.879><c> and</c><00:04:10.090><c> columns</c>

00:04:10.439 --> 00:04:10.449 align:start position:0%
this example the header rows and columns
 

00:04:10.449 --> 00:04:12.569 align:start position:0%
this example the header rows and columns
are<00:04:10.629><c> really</c><00:04:10.989><c> important</c><00:04:11.440><c> so</c><00:04:11.919><c> the</c><00:04:12.040><c> freeze</c><00:04:12.280><c> panes</c>

00:04:12.569 --> 00:04:12.579 align:start position:0%
are really important so the freeze panes
 

00:04:12.579 --> 00:04:14.360 align:start position:0%
are really important so the freeze panes
feature<00:04:12.940><c> is</c><00:04:13.180><c> probably</c><00:04:13.540><c> the</c><00:04:13.720><c> best</c><00:04:13.900><c> choice</c>

00:04:14.360 --> 00:04:14.370 align:start position:0%
feature is probably the best choice
 

00:04:14.370 --> 00:04:16.770 align:start position:0%
feature is probably the best choice
you'll<00:04:15.370><c> just</c><00:04:15.549><c> have</c><00:04:15.699><c> to</c><00:04:15.790><c> try</c><00:04:16.000><c> all</c><00:04:16.030><c> of</c><00:04:16.299><c> the</c><00:04:16.599><c> view</c>

00:04:16.770 --> 00:04:16.780 align:start position:0%
you'll just have to try all of the view
 

00:04:16.780 --> 00:04:18.659 align:start position:0%
you'll just have to try all of the view
options<00:04:17.199><c> to</c><00:04:17.349><c> see</c><00:04:17.530><c> which</c><00:04:17.739><c> one</c><00:04:17.979><c> works</c><00:04:18.159><c> best</c><00:04:18.519><c> for</c>

00:04:18.659 --> 00:04:18.669 align:start position:0%
options to see which one works best for
 

00:04:18.669 --> 00:04:22.280 align:start position:0%
options to see which one works best for
your<00:04:19.000><c> spreadsheet</c>

00:04:22.280 --> 00:04:22.290 align:start position:0%
 
 

00:04:22.290 --> 00:04:24.350 align:start position:0%
 
you