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.520><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.560 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:03.600><c> for</c><00:00:03.629><c> a</c><00:00:03.870><c> better</c><00:00:04.020><c> life</c>

00:00:10.560 --> 00:00:10.570 align:start position:0%
 
 

00:00:10.570 --> 00:00:12.629 align:start position:0%
 
because<00:00:11.500><c> workbooks</c><00:00:11.950><c> are</c><00:00:12.130><c> designed</c><00:00:12.430><c> to</c><00:00:12.490><c> be</c>

00:00:12.629 --> 00:00:12.639 align:start position:0%
because workbooks are designed to be
 

00:00:12.639 --> 00:00:14.310 align:start position:0%
because workbooks are designed to be
viewed<00:00:12.790><c> electronically</c><00:00:13.510><c> it</c><00:00:13.719><c> can</c><00:00:13.960><c> be</c><00:00:14.050><c> hard</c><00:00:14.260><c> to</c>

00:00:14.310 --> 00:00:14.320 align:start position:0%
viewed electronically it can be hard to
 

00:00:14.320 --> 00:00:15.330 align:start position:0%
viewed electronically it can be hard to
tell<00:00:14.410><c> what</c><00:00:14.680><c> your</c><00:00:14.799><c> data</c><00:00:14.980><c> might</c><00:00:15.160><c> look</c><00:00:15.190><c> like</c>

00:00:15.330 --> 00:00:15.340 align:start position:0%
tell what your data might look like
 

00:00:15.340 --> 00:00:17.730 align:start position:0%
tell what your data might look like
outside<00:00:15.940><c> of</c><00:00:15.969><c> Excel</c><00:00:16.450><c> for</c><00:00:16.840><c> example</c><00:00:16.869><c> if</c><00:00:17.439><c> you</c><00:00:17.529><c> plan</c>

00:00:17.730 --> 00:00:17.740 align:start position:0%
outside of Excel for example if you plan
 

00:00:17.740 --> 00:00:20.760 align:start position:0%
outside of Excel for example if you plan
to<00:00:17.800><c> print</c><00:00:17.920><c> it</c><00:00:18.279><c> or</c><00:00:18.430><c> save</c><00:00:18.460><c> it</c><00:00:18.790><c> as</c><00:00:18.970><c> a</c><00:00:19.000><c> PDF</c><00:00:19.770><c> luckily</c>

00:00:20.760 --> 00:00:20.770 align:start position:0%
to print it or save it as a PDF luckily
 

00:00:20.770 --> 00:00:22.530 align:start position:0%
to print it or save it as a PDF luckily
there<00:00:21.099><c> are</c><00:00:21.220><c> several</c><00:00:21.550><c> different</c><00:00:21.880><c> ways</c><00:00:21.910><c> to</c><00:00:22.060><c> view</c>

00:00:22.530 --> 00:00:22.540 align:start position:0%
there are several different ways to view
 

00:00:22.540 --> 00:00:25.560 align:start position:0%
there are several different ways to view
and<00:00:22.689><c> customize</c><00:00:23.170><c> your</c><00:00:23.380><c> layout</c><00:00:23.880><c> to</c><00:00:24.880><c> get</c><00:00:25.029><c> started</c>

00:00:25.560 --> 00:00:25.570 align:start position:0%
and customize your layout to get started
 

00:00:25.570 --> 00:00:26.940 align:start position:0%
and customize your layout to get started
I<00:00:25.599><c> recommend</c><00:00:26.170><c> switching</c><00:00:26.560><c> to</c><00:00:26.710><c> page</c><00:00:26.919><c> layout</c>

00:00:26.940 --> 00:00:26.950 align:start position:0%
I recommend switching to page layout
 

00:00:26.950 --> 00:00:28.979 align:start position:0%
I recommend switching to page layout
view<00:00:27.340><c> using</c><00:00:28.000><c> the</c><00:00:28.119><c> command</c><00:00:28.450><c> in</c><00:00:28.599><c> the</c><00:00:28.689><c> bottom</c>

00:00:28.979 --> 00:00:28.989 align:start position:0%
view using the command in the bottom
 

00:00:28.989 --> 00:00:30.990 align:start position:0%
view using the command in the bottom
right<00:00:29.169><c> corner</c><00:00:29.520><c> this</c><00:00:30.520><c> will</c><00:00:30.730><c> help</c><00:00:30.910><c> you</c>

00:00:30.990 --> 00:00:31.000 align:start position:0%
right corner this will help you
 

00:00:31.000 --> 00:00:32.819 align:start position:0%
right corner this will help you
visualize<00:00:31.180><c> the</c><00:00:31.689><c> final</c><00:00:31.810><c> product</c><00:00:32.320><c> as</c><00:00:32.470><c> you</c><00:00:32.680><c> make</c>

00:00:32.819 --> 00:00:32.829 align:start position:0%
visualize the final product as you make
 

00:00:32.829 --> 00:00:36.030 align:start position:0%
visualize the final product as you make
changes<00:00:33.190><c> to</c><00:00:33.250><c> your</c><00:00:33.399><c> workbook</c><00:00:34.500><c> next</c><00:00:35.500><c> go</c><00:00:35.829><c> to</c><00:00:35.860><c> the</c>

00:00:36.030 --> 00:00:36.040 align:start position:0%
changes to your workbook next go to the
 

00:00:36.040 --> 00:00:38.310 align:start position:0%
changes to your workbook next go to the
page<00:00:36.220><c> Layout</c><00:00:36.610><c> tab</c><00:00:36.640><c> on</c><00:00:37.030><c> the</c><00:00:37.120><c> ribbon</c><00:00:37.320><c> here</c>

00:00:38.310 --> 00:00:38.320 align:start position:0%
page Layout tab on the ribbon here
 

00:00:38.320 --> 00:00:39.630 align:start position:0%
page Layout tab on the ribbon here
you'll<00:00:38.470><c> find</c><00:00:38.649><c> everything</c><00:00:38.860><c> you</c><00:00:39.280><c> need</c><00:00:39.460><c> to</c>

00:00:39.630 --> 00:00:39.640 align:start position:0%
you'll find everything you need to
 

00:00:39.640 --> 00:00:41.819 align:start position:0%
you'll find everything you need to
modify<00:00:40.030><c> your</c><00:00:40.180><c> page</c><00:00:40.390><c> orientation</c><00:00:40.930><c> margins</c>

00:00:41.819 --> 00:00:41.829 align:start position:0%
modify your page orientation margins
 

00:00:41.829 --> 00:00:45.060 align:start position:0%
modify your page orientation margins
print<00:00:42.370><c> titles</c><00:00:42.730><c> and</c><00:00:42.910><c> more</c><00:00:43.440><c> for</c><00:00:44.440><c> example</c><00:00:44.530><c> our</c>

00:00:45.060 --> 00:00:45.070 align:start position:0%
print titles and more for example our
 

00:00:45.070 --> 00:00:46.890 align:start position:0%
print titles and more for example our
current<00:00:45.400><c> orientation</c><00:00:45.550><c> is</c><00:00:46.270><c> portrait</c><00:00:46.300><c> or</c>

00:00:46.890 --> 00:00:46.900 align:start position:0%
current orientation is portrait or
 

00:00:46.900 --> 00:00:48.930 align:start position:0%
current orientation is portrait or
vertical<00:00:46.930><c> a</c><00:00:47.590><c> good</c><00:00:48.160><c> choice</c><00:00:48.340><c> if</c><00:00:48.580><c> your</c><00:00:48.730><c> goal</c><00:00:48.910><c> is</c>

00:00:48.930 --> 00:00:48.940 align:start position:0%
vertical a good choice if your goal is
 

00:00:48.940 --> 00:00:51.780 align:start position:0%
vertical a good choice if your goal is
to<00:00:49.090><c> fit</c><00:00:49.390><c> more</c><00:00:49.570><c> rows</c><00:00:49.870><c> on</c><00:00:50.140><c> each</c><00:00:50.290><c> page</c><00:00:50.560><c> I'd</c><00:00:51.490><c> like</c>

00:00:51.780 --> 00:00:51.790 align:start position:0%
to fit more rows on each page I'd like
 

00:00:51.790 --> 00:00:54.180 align:start position:0%
to fit more rows on each page I'd like
to<00:00:51.910><c> switch</c><00:00:52.030><c> to</c><00:00:52.360><c> landscape</c><00:00:52.750><c> or</c><00:00:53.140><c> horizontal</c><00:00:53.200><c> so</c>

00:00:54.180 --> 00:00:54.190 align:start position:0%
to switch to landscape or horizontal so
 

00:00:54.190 --> 00:00:56.970 align:start position:0%
to switch to landscape or horizontal so
I<00:00:54.220><c> can</c><00:00:54.490><c> fit</c><00:00:54.670><c> more</c><00:00:54.820><c> columns</c><00:00:55.270><c> instead</c><00:00:55.980><c> just</c>

00:00:56.970 --> 00:00:56.980 align:start position:0%
I can fit more columns instead just
 

00:00:56.980 --> 00:00:59.520 align:start position:0%
I can fit more columns instead just
click<00:00:57.250><c> the</c><00:00:57.370><c> orientation</c><00:00:58.060><c> command</c><00:00:58.530><c> then</c>

00:00:59.520 --> 00:00:59.530 align:start position:0%
click the orientation command then
 

00:00:59.530 --> 00:01:02.069 align:start position:0%
click the orientation command then
choose<00:00:59.560><c> landscape</c><00:01:00.490><c> and</c><00:01:00.870><c> you'll</c><00:01:01.870><c> instantly</c>

00:01:02.069 --> 00:01:02.079 align:start position:0%
choose landscape and you'll instantly
 

00:01:02.079 --> 00:01:05.069 align:start position:0%
choose landscape and you'll instantly
see<00:01:02.620><c> the</c><00:01:02.650><c> change</c><00:01:03.239><c> there's</c><00:01:04.239><c> still</c><00:01:04.540><c> one</c><00:01:04.720><c> column</c>

00:01:05.069 --> 00:01:05.079 align:start position:0%
see the change there's still one column
 

00:01:05.079 --> 00:01:06.569 align:start position:0%
see the change there's still one column
that's<00:01:05.229><c> getting</c><00:01:05.500><c> cut</c><00:01:05.680><c> off</c><00:01:05.710><c> on</c><00:01:05.950><c> the</c><00:01:06.070><c> right</c><00:01:06.220><c> but</c>

00:01:06.569 --> 00:01:06.579 align:start position:0%
that's getting cut off on the right but
 

00:01:06.579 --> 00:01:09.090 align:start position:0%
that's getting cut off on the right but
that's<00:01:06.759><c> okay</c><00:01:07.150><c> if</c><00:01:07.360><c> we</c><00:01:07.930><c> adjust</c><00:01:08.020><c> the</c><00:01:08.380><c> margins</c><00:01:08.770><c> we</c>

00:01:09.090 --> 00:01:09.100 align:start position:0%
that's okay if we adjust the margins we
 

00:01:09.100 --> 00:01:10.830 align:start position:0%
that's okay if we adjust the margins we
should<00:01:09.340><c> be</c><00:01:09.490><c> able</c><00:01:09.610><c> to</c><00:01:09.729><c> fit</c><00:01:09.939><c> all</c><00:01:10.119><c> the</c><00:01:10.299><c> columns</c><00:01:10.659><c> on</c>

00:01:10.830 --> 00:01:10.840 align:start position:0%
should be able to fit all the columns on
 

00:01:10.840 --> 00:01:13.560 align:start position:0%
should be able to fit all the columns on
a<00:01:10.869><c> single</c><00:01:11.259><c> page</c><00:01:11.729><c> all</c><00:01:12.729><c> you</c><00:01:12.790><c> have</c><00:01:13.149><c> to</c><00:01:13.299><c> do</c><00:01:13.420><c> is</c>

00:01:13.560 --> 00:01:13.570 align:start position:0%
a single page all you have to do is
 

00:01:13.570 --> 00:01:16.080 align:start position:0%
a single page all you have to do is
click<00:01:13.810><c> the</c><00:01:13.930><c> margins</c><00:01:14.320><c> command</c><00:01:14.820><c> here</c><00:01:15.820><c> you</c><00:01:15.940><c> can</c>

00:01:16.080 --> 00:01:16.090 align:start position:0%
click the margins command here you can
 

00:01:16.090 --> 00:01:19.020 align:start position:0%
click the margins command here you can
choose<00:01:16.270><c> one</c><00:01:16.510><c> of</c><00:01:16.540><c> the</c><00:01:16.720><c> predefined</c><00:01:17.260><c> sizes</c><00:01:18.030><c> or</c>

00:01:19.020 --> 00:01:19.030 align:start position:0%
choose one of the predefined sizes or
 

00:01:19.030 --> 00:01:20.969 align:start position:0%
choose one of the predefined sizes or
you<00:01:19.090><c> can</c><00:01:19.510><c> customize</c><00:01:20.020><c> your</c><00:01:20.050><c> margins</c><00:01:20.530><c> depending</c>

00:01:20.969 --> 00:01:20.979 align:start position:0%
you can customize your margins depending
 

00:01:20.979 --> 00:01:23.460 align:start position:0%
you can customize your margins depending
on<00:01:21.070><c> what</c><00:01:21.220><c> you</c><00:01:21.340><c> need</c><00:01:21.550><c> just</c><00:01:22.050><c> go</c><00:01:23.050><c> back</c><00:01:23.229><c> to</c><00:01:23.380><c> the</c>

00:01:23.460 --> 00:01:23.470 align:start position:0%
on what you need just go back to the
 

00:01:23.470 --> 00:01:26.430 align:start position:0%
on what you need just go back to the
margins<00:01:23.830><c> command</c><00:01:24.540><c> but</c><00:01:25.540><c> this</c><00:01:25.720><c> time</c><00:01:25.990><c> click</c>

00:01:26.430 --> 00:01:26.440 align:start position:0%
margins command but this time click
 

00:01:26.440 --> 00:01:30.090 align:start position:0%
margins command but this time click
custom<00:01:26.979><c> margins</c><00:01:27.159><c> I'm</c><00:01:28.710><c> going</c><00:01:29.710><c> to</c><00:01:29.770><c> make</c><00:01:29.950><c> the</c>

00:01:30.090 --> 00:01:30.100 align:start position:0%
custom margins I'm going to make the
 

00:01:30.100 --> 00:01:31.980 align:start position:0%
custom margins I'm going to make the
left<00:01:30.310><c> and</c><00:01:30.520><c> right</c><00:01:30.670><c> margins</c><00:01:30.850><c> just</c><00:01:31.390><c> a</c><00:01:31.479><c> little</c><00:01:31.810><c> bit</c>

00:01:31.980 --> 00:01:31.990 align:start position:0%
left and right margins just a little bit
 

00:01:31.990 --> 00:01:36.510 align:start position:0%
left and right margins just a little bit
wider<00:01:32.229><c> at</c><00:01:32.530><c> 0.5</c><00:01:33.159><c> inches</c><00:01:33.580><c> instead</c><00:01:34.150><c> of</c><00:01:34.270><c> 0.25</c><00:01:35.520><c> when</c>

00:01:36.510 --> 00:01:36.520 align:start position:0%
wider at 0.5 inches instead of 0.25 when
 

00:01:36.520 --> 00:01:39.330 align:start position:0%
wider at 0.5 inches instead of 0.25 when
you're<00:01:36.670><c> done</c><00:01:36.820><c> click</c><00:01:37.180><c> OK</c><00:01:37.570><c> and</c><00:01:37.979><c> your</c><00:01:38.979><c> worksheet</c>

00:01:39.330 --> 00:01:39.340 align:start position:0%
you're done click OK and your worksheet
 

00:01:39.340 --> 00:01:42.450 align:start position:0%
you're done click OK and your worksheet
will<00:01:39.490><c> be</c><00:01:39.580><c> updated</c><00:01:40.060><c> you</c><00:01:40.650><c> can</c><00:01:41.650><c> also</c><00:01:41.830><c> add</c><00:01:42.100><c> headers</c>

00:01:42.450 --> 00:01:42.460 align:start position:0%
will be updated you can also add headers
 

00:01:42.460 --> 00:01:43.950 align:start position:0%
will be updated you can also add headers
and<00:01:42.640><c> footers</c><00:01:42.700><c> to</c><00:01:43.060><c> your</c><00:01:43.180><c> workbook</c><00:01:43.540><c> to</c><00:01:43.720><c> make</c><00:01:43.840><c> the</c>

00:01:43.950 --> 00:01:43.960 align:start position:0%
and footers to your workbook to make the
 

00:01:43.960 --> 00:01:46.200 align:start position:0%
and footers to your workbook to make the
printed<00:01:44.229><c> copy</c><00:01:44.409><c> easier</c><00:01:44.979><c> to</c><00:01:45.100><c> read</c><00:01:45.280><c> in</c><00:01:45.490><c> this</c>

00:01:46.200 --> 00:01:46.210 align:start position:0%
printed copy easier to read in this
 

00:01:46.210 --> 00:01:48.330 align:start position:0%
printed copy easier to read in this
example<00:01:46.600><c> we'll</c><00:01:47.140><c> add</c><00:01:47.170><c> a</c><00:01:47.350><c> header</c><00:01:47.650><c> by</c><00:01:47.950><c> clicking</c>

00:01:48.330 --> 00:01:48.340 align:start position:0%
example we'll add a header by clicking
 

00:01:48.340 --> 00:01:51.719 align:start position:0%
example we'll add a header by clicking
the<00:01:48.460><c> area</c><00:01:48.790><c> here</c><00:01:49.590><c> this</c><00:01:50.590><c> opens</c><00:01:50.830><c> the</c><00:01:51.159><c> design</c><00:01:51.490><c> tab</c>

00:01:51.719 --> 00:01:51.729 align:start position:0%
the area here this opens the design tab
 

00:01:51.729 --> 00:01:53.149 align:start position:0%
the area here this opens the design tab
for<00:01:52.090><c> working</c><00:01:52.390><c> with</c><00:01:52.540><c> headers</c><00:01:52.810><c> and</c><00:01:52.960><c> footers</c>

00:01:53.149 --> 00:01:53.159 align:start position:0%
for working with headers and footers
 

00:01:53.159 --> 00:01:55.620 align:start position:0%
for working with headers and footers
from<00:01:54.159><c> here</c><00:01:54.460><c> you</c><00:01:54.610><c> can</c><00:01:54.760><c> easily</c><00:01:54.970><c> add</c><00:01:55.210><c> page</c>

00:01:55.620 --> 00:01:55.630 align:start position:0%
from here you can easily add page
 

00:01:55.630 --> 00:01:57.270 align:start position:0%
from here you can easily add page
numbers<00:01:55.659><c> today's</c><00:01:56.530><c> date</c><00:01:56.830><c> and</c><00:01:57.010><c> other</c>

00:01:57.270 --> 00:01:57.280 align:start position:0%
numbers today's date and other
 

00:01:57.280 --> 00:01:59.280 align:start position:0%
numbers today's date and other
information<00:01:57.640><c> to</c><00:01:58.090><c> your</c><00:01:58.210><c> header</c><00:01:58.420><c> or</c><00:01:58.630><c> footer</c><00:01:58.659><c> all</c>

00:01:59.280 --> 00:01:59.290 align:start position:0%
information to your header or footer all
 

00:01:59.290 --> 00:02:01.440 align:start position:0%
information to your header or footer all
you<00:02:00.100><c> have</c><00:02:00.280><c> to</c><00:02:00.400><c> do</c><00:02:00.549><c> is</c><00:02:00.670><c> click</c><00:02:00.909><c> the</c><00:02:01.030><c> command</c><00:02:01.360><c> you</c>

00:02:01.440 --> 00:02:01.450 align:start position:0%
you have to do is click the command you
 

00:02:01.450 --> 00:02:01.770 align:start position:0%
you have to do is click the command you
want

00:02:01.770 --> 00:02:01.780 align:start position:0%
want
 

00:02:01.780 --> 00:02:05.520 align:start position:0%
want
how<00:02:02.409><c> about</c><00:02:02.680><c> page</c><00:02:02.950><c> numbers</c><00:02:04.229><c> when</c><00:02:05.229><c> you're</c><00:02:05.380><c> done</c>

00:02:05.520 --> 00:02:05.530 align:start position:0%
how about page numbers when you're done
 

00:02:05.530 --> 00:02:07.440 align:start position:0%
how about page numbers when you're done
click<00:02:05.979><c> anywhere</c><00:02:06.460><c> else</c><00:02:06.640><c> in</c><00:02:06.820><c> your</c><00:02:06.909><c> worksheet</c><00:02:07.270><c> to</c>

00:02:07.440 --> 00:02:07.450 align:start position:0%
click anywhere else in your worksheet to
 

00:02:07.450 --> 00:02:10.469 align:start position:0%
click anywhere else in your worksheet to
exit<00:02:07.840><c> now</c><00:02:08.129><c> the</c><00:02:09.129><c> pages</c><00:02:09.580><c> are</c><00:02:09.729><c> numbered</c><00:02:09.819><c> page</c><00:02:10.209><c> 1</c>

00:02:10.469 --> 00:02:10.479 align:start position:0%
exit now the pages are numbered page 1
 

00:02:10.479 --> 00:02:15.559 align:start position:0%
exit now the pages are numbered page 1
and<00:02:10.720><c> page</c><00:02:11.340><c> 2</c><00:02:13.890><c> here's</c><00:02:14.890><c> a</c><00:02:14.980><c> tip</c><00:02:15.220><c> if</c>

00:02:15.559 --> 00:02:15.569 align:start position:0%
and page 2 here's a tip if
 

00:02:15.569 --> 00:02:17.239 align:start position:0%
and page 2 here's a tip if
worksheet<00:02:15.870><c> uses</c><00:02:16.170><c> title</c><00:02:16.499><c> headings</c><00:02:16.799><c> you</c><00:02:17.219><c> can</c>

00:02:17.239 --> 00:02:17.249 align:start position:0%
worksheet uses title headings you can
 

00:02:17.249 --> 00:02:18.979 align:start position:0%
worksheet uses title headings you can
include<00:02:17.640><c> them</c><00:02:17.790><c> on</c><00:02:17.909><c> each</c><00:02:18.120><c> page</c><00:02:18.450><c> to</c><00:02:18.480><c> make</c><00:02:18.840><c> the</c>

00:02:18.979 --> 00:02:18.989 align:start position:0%
include them on each page to make the
 

00:02:18.989 --> 00:02:21.589 align:start position:0%
include them on each page to make the
printed<00:02:19.290><c> copy</c><00:02:19.439><c> easier</c><00:02:20.010><c> to</c><00:02:20.129><c> read</c><00:02:20.310><c> for</c><00:02:20.599><c> example</c>

00:02:21.589 --> 00:02:21.599 align:start position:0%
printed copy easier to read for example
 

00:02:21.599 --> 00:02:23.330 align:start position:0%
printed copy easier to read for example
in<00:02:21.749><c> this</c><00:02:21.870><c> workbook</c><00:02:22.139><c> it</c><00:02:22.560><c> would</c><00:02:22.799><c> really</c><00:02:22.980><c> help</c><00:02:23.189><c> me</c>

00:02:23.330 --> 00:02:23.340 align:start position:0%
in this workbook it would really help me
 

00:02:23.340 --> 00:02:24.800 align:start position:0%
in this workbook it would really help me
to<00:02:23.430><c> know</c><00:02:23.549><c> what</c><00:02:23.760><c> months</c><00:02:23.999><c> these</c><00:02:24.180><c> sales</c><00:02:24.480><c> figures</c>

00:02:24.800 --> 00:02:24.810 align:start position:0%
to know what months these sales figures
 

00:02:24.810 --> 00:02:27.440 align:start position:0%
to know what months these sales figures
are<00:02:24.959><c> for</c><00:02:25.609><c> just</c><00:02:26.609><c> go</c><00:02:26.760><c> back</c><00:02:26.939><c> to</c><00:02:27.150><c> your</c><00:02:27.269><c> title</c>

00:02:27.440 --> 00:02:27.450 align:start position:0%
are for just go back to your title
 

00:02:27.450 --> 00:02:30.050 align:start position:0%
are for just go back to your title
headings<00:02:28.249><c> then</c><00:02:29.249><c> click</c><00:02:29.549><c> the</c><00:02:29.670><c> print</c><00:02:29.909><c> titles</c>

00:02:30.050 --> 00:02:30.060 align:start position:0%
headings then click the print titles
 

00:02:30.060 --> 00:02:33.979 align:start position:0%
headings then click the print titles
command<00:02:31.849><c> next</c><00:02:32.849><c> click</c><00:02:33.269><c> the</c><00:02:33.299><c> button</c><00:02:33.689><c> next</c><00:02:33.810><c> to</c>

00:02:33.979 --> 00:02:33.989 align:start position:0%
command next click the button next to
 

00:02:33.989 --> 00:02:35.750 align:start position:0%
command next click the button next to
the<00:02:34.109><c> field</c><00:02:34.290><c> you</c><00:02:34.439><c> want</c><00:02:34.620><c> to</c><00:02:34.769><c> repeat</c><00:02:35.069><c> you</c><00:02:35.579><c> can</c>

00:02:35.750 --> 00:02:35.760 align:start position:0%
the field you want to repeat you can
 

00:02:35.760 --> 00:02:40.640 align:start position:0%
the field you want to repeat you can
choose<00:02:35.969><c> either</c><00:02:36.150><c> rows</c><00:02:36.510><c> or</c><00:02:36.810><c> columns</c><00:02:39.260><c> the</c><00:02:40.260><c> dialog</c>

00:02:40.640 --> 00:02:40.650 align:start position:0%
choose either rows or columns the dialog
 

00:02:40.650 --> 00:02:42.500 align:start position:0%
choose either rows or columns the dialog
box<00:02:40.889><c> will</c><00:02:41.129><c> collapse</c><00:02:41.430><c> and</c><00:02:41.730><c> your</c><00:02:41.939><c> cursor</c><00:02:42.299><c> will</c>

00:02:42.500 --> 00:02:42.510 align:start position:0%
box will collapse and your cursor will
 

00:02:42.510 --> 00:02:44.959 align:start position:0%
box will collapse and your cursor will
turn<00:02:42.540><c> into</c><00:02:42.930><c> a</c><00:02:42.959><c> selection</c><00:02:43.469><c> arrow</c><00:02:43.650><c> from</c><00:02:44.579><c> here</c>

00:02:44.959 --> 00:02:44.969 align:start position:0%
turn into a selection arrow from here
 

00:02:44.969 --> 00:02:46.670 align:start position:0%
turn into a selection arrow from here
select<00:02:45.269><c> the</c><00:02:45.540><c> data</c><00:02:45.840><c> you</c><00:02:46.019><c> want</c><00:02:46.139><c> to</c><00:02:46.290><c> repeat</c><00:02:46.530><c> on</c>

00:02:46.670 --> 00:02:46.680 align:start position:0%
select the data you want to repeat on
 

00:02:46.680 --> 00:02:49.580 align:start position:0%
select the data you want to repeat on
each<00:02:46.799><c> page</c><00:02:47.569><c> then</c><00:02:48.569><c> click</c><00:02:48.599><c> the</c><00:02:48.959><c> button</c><00:02:49.200><c> again</c><00:02:49.439><c> to</c>

00:02:49.580 --> 00:02:49.590 align:start position:0%
each page then click the button again to
 

00:02:49.590 --> 00:02:53.089 align:start position:0%
each page then click the button again to
go<00:02:49.799><c> back</c><00:02:49.980><c> to</c><00:02:50.159><c> the</c><00:02:50.250><c> dialog</c><00:02:50.609><c> box</c><00:02:51.950><c> when</c><00:02:52.950><c> you're</c>

00:02:53.089 --> 00:02:53.099 align:start position:0%
go back to the dialog box when you're
 

00:02:53.099 --> 00:02:56.509 align:start position:0%
go back to the dialog box when you're
done<00:02:53.310><c> click</c><00:02:53.699><c> OK</c><00:02:54.590><c> now</c><00:02:55.590><c> my</c><00:02:55.799><c> header</c><00:02:56.010><c> row</c><00:02:56.189><c> appears</c>

00:02:56.509 --> 00:02:56.519 align:start position:0%
done click OK now my header row appears
 

00:02:56.519 --> 00:03:01.399 align:start position:0%
done click OK now my header row appears
at<00:02:56.790><c> the</c><00:02:56.909><c> top</c><00:02:56.939><c> of</c><00:02:57.120><c> page</c><00:02:57.299><c> 1</c><00:02:57.750><c> and</c><00:02:57.989><c> page</c><00:02:58.250><c> 2</c><00:03:00.409><c> there's</c>

00:03:01.399 --> 00:03:01.409 align:start position:0%
at the top of page 1 and page 2 there's
 

00:03:01.409 --> 00:03:02.869 align:start position:0%
at the top of page 1 and page 2 there's
one<00:03:01.709><c> more</c><00:03:01.859><c> thing</c><00:03:02.040><c> I'd</c><00:03:02.189><c> like</c><00:03:02.219><c> to</c><00:03:02.370><c> change</c><00:03:02.519><c> about</c>

00:03:02.869 --> 00:03:02.879 align:start position:0%
one more thing I'd like to change about
 

00:03:02.879 --> 00:03:05.330 align:start position:0%
one more thing I'd like to change about
my<00:03:03.120><c> layout</c><00:03:03.480><c> notice</c><00:03:04.469><c> how</c><00:03:04.590><c> the</c><00:03:04.650><c> data</c><00:03:04.919><c> is</c><00:03:05.010><c> split</c>

00:03:05.330 --> 00:03:05.340 align:start position:0%
my layout notice how the data is split
 

00:03:05.340 --> 00:03:07.520 align:start position:0%
my layout notice how the data is split
up<00:03:05.370><c> so</c><00:03:05.519><c> page</c><00:03:05.909><c> 2</c><00:03:06.180><c> only</c><00:03:06.419><c> contains</c><00:03:06.870><c> about</c><00:03:07.139><c> 9</c><00:03:07.349><c> or</c><00:03:07.379><c> 10</c>

00:03:07.520 --> 00:03:07.530 align:start position:0%
up so page 2 only contains about 9 or 10
 

00:03:07.530 --> 00:03:09.849 align:start position:0%
up so page 2 only contains about 9 or 10
rows<00:03:07.919><c> I'd</c><00:03:08.730><c> like</c><00:03:08.969><c> more</c><00:03:09.120><c> control</c><00:03:09.480><c> over</c><00:03:09.510><c> that</c>

00:03:09.849 --> 00:03:09.859 align:start position:0%
rows I'd like more control over that
 

00:03:09.859 --> 00:03:12.140 align:start position:0%
rows I'd like more control over that
instead<00:03:10.859><c> of</c><00:03:10.949><c> the</c><00:03:11.040><c> last</c><00:03:11.189><c> couple</c><00:03:11.609><c> of</c><00:03:11.669><c> rows</c><00:03:11.909><c> I</c>

00:03:12.140 --> 00:03:12.150 align:start position:0%
instead of the last couple of rows I
 

00:03:12.150 --> 00:03:14.839 align:start position:0%
instead of the last couple of rows I
want<00:03:12.510><c> the</c><00:03:12.629><c> data</c><00:03:12.810><c> to</c><00:03:12.930><c> be</c><00:03:13.049><c> divided</c><00:03:13.560><c> evenly</c><00:03:13.849><c> 20</c>

00:03:14.839 --> 00:03:14.849 align:start position:0%
want the data to be divided evenly 20
 

00:03:14.849 --> 00:03:17.959 align:start position:0%
want the data to be divided evenly 20
people<00:03:15.180><c> on</c><00:03:15.329><c> each</c><00:03:15.659><c> page</c><00:03:16.310><c> to</c><00:03:17.310><c> do</c><00:03:17.459><c> this</c><00:03:17.669><c> I'm</c><00:03:17.909><c> going</c>

00:03:17.959 --> 00:03:17.969 align:start position:0%
people on each page to do this I'm going
 

00:03:17.969 --> 00:03:19.459 align:start position:0%
people on each page to do this I'm going
to<00:03:18.389><c> switch</c><00:03:18.629><c> to</c><00:03:18.659><c> the</c><00:03:18.959><c> page</c><00:03:19.169><c> break</c><00:03:19.439><c> preview</c>

00:03:19.459 --> 00:03:19.469 align:start position:0%
to switch to the page break preview
 

00:03:19.469 --> 00:03:21.530 align:start position:0%
to switch to the page break preview
using<00:03:20.370><c> the</c><00:03:20.489><c> command</c><00:03:20.849><c> in</c><00:03:21.000><c> the</c><00:03:21.090><c> bottom</c><00:03:21.389><c> right</c>

00:03:21.530 --> 00:03:21.540 align:start position:0%
using the command in the bottom right
 

00:03:21.540 --> 00:03:24.349 align:start position:0%
using the command in the bottom right
corner<00:03:22.069><c> this</c><00:03:23.069><c> makes</c><00:03:23.370><c> it</c><00:03:23.519><c> easy</c><00:03:23.669><c> to</c><00:03:23.790><c> review</c><00:03:24.209><c> your</c>

00:03:24.349 --> 00:03:24.359 align:start position:0%
corner this makes it easy to review your
 

00:03:24.359 --> 00:03:26.210 align:start position:0%
corner this makes it easy to review your
page<00:03:24.569><c> breaks</c><00:03:24.900><c> so</c><00:03:25.290><c> you</c><00:03:25.319><c> can</c><00:03:25.560><c> easily</c><00:03:25.709><c> insert</c>

00:03:26.210 --> 00:03:26.220 align:start position:0%
page breaks so you can easily insert
 

00:03:26.220 --> 00:03:29.059 align:start position:0%
page breaks so you can easily insert
your<00:03:26.370><c> own</c><00:03:27.079><c> simply</c><00:03:28.079><c> select</c><00:03:28.500><c> the</c><00:03:28.650><c> row</c><00:03:28.829><c> below</c>

00:03:29.059 --> 00:03:29.069 align:start position:0%
your own simply select the row below
 

00:03:29.069 --> 00:03:31.569 align:start position:0%
your own simply select the row below
where<00:03:29.430><c> you</c><00:03:29.519><c> want</c><00:03:29.699><c> the</c><00:03:29.819><c> page</c><00:03:30.030><c> break</c><00:03:30.269><c> to</c><00:03:30.479><c> appear</c>

00:03:31.569 --> 00:03:31.579 align:start position:0%
where you want the page break to appear
 

00:03:31.579 --> 00:03:34.819 align:start position:0%
where you want the page break to appear
then<00:03:32.579><c> click</c><00:03:32.879><c> the</c><00:03:33.030><c> breaks</c><00:03:33.269><c> command</c><00:03:33.720><c> and</c><00:03:33.930><c> choose</c>

00:03:34.819 --> 00:03:34.829 align:start position:0%
then click the breaks command and choose
 

00:03:34.829 --> 00:03:39.229 align:start position:0%
then click the breaks command and choose
insert<00:03:35.370><c> page</c><00:03:35.669><c> break</c><00:03:36.319><c> if</c><00:03:37.729><c> we</c><00:03:38.729><c> switch</c><00:03:38.970><c> back</c><00:03:39.180><c> to</c>

00:03:39.229 --> 00:03:39.239 align:start position:0%
insert page break if we switch back to
 

00:03:39.239 --> 00:03:41.449 align:start position:0%
insert page break if we switch back to
page<00:03:39.659><c> layout</c><00:03:40.049><c> view</c><00:03:40.079><c> and</c><00:03:40.500><c> zoom</c><00:03:40.530><c> out</c><00:03:40.919><c> just</c><00:03:40.979><c> a</c>

00:03:41.449 --> 00:03:41.459 align:start position:0%
page layout view and zoom out just a
 

00:03:41.459 --> 00:03:43.759 align:start position:0%
page layout view and zoom out just a
little<00:03:41.750><c> we</c><00:03:42.750><c> can</c><00:03:42.900><c> see</c><00:03:43.079><c> that</c><00:03:43.229><c> the</c><00:03:43.379><c> data</c><00:03:43.560><c> is</c>

00:03:43.759 --> 00:03:43.769 align:start position:0%
little we can see that the data is
 

00:03:43.769 --> 00:03:46.780 align:start position:0%
little we can see that the data is
divided<00:03:44.099><c> evenly</c><00:03:44.459><c> between</c><00:03:44.579><c> page</c><00:03:45.209><c> 1</c><00:03:45.479><c> and</c><00:03:45.689><c> page</c><00:03:45.750><c> 2</c>

00:03:46.780 --> 00:03:46.790 align:start position:0%
divided evenly between page 1 and page 2
 

00:03:46.790 --> 00:03:49.129 align:start position:0%
divided evenly between page 1 and page 2
now<00:03:47.790><c> you</c><00:03:47.849><c> have</c><00:03:48.090><c> all</c><00:03:48.329><c> the</c><00:03:48.509><c> tools</c><00:03:48.750><c> you</c><00:03:48.900><c> need</c><00:03:48.930><c> to</c>

00:03:49.129 --> 00:03:49.139 align:start position:0%
now you have all the tools you need to
 

00:03:49.139 --> 00:03:51.379 align:start position:0%
now you have all the tools you need to
customize<00:03:49.500><c> your</c><00:03:50.009><c> page</c><00:03:50.159><c> layout</c><00:03:50.459><c> and</c><00:03:50.819><c> prepare</c>

00:03:51.379 --> 00:03:51.389 align:start position:0%
customize your page layout and prepare
 

00:03:51.389 --> 00:03:55.970 align:start position:0%
customize your page layout and prepare
your<00:03:51.569><c> workbook</c><00:03:51.930><c> for</c><00:03:52.109><c> printing</c><00:03:52.500><c> or</c><00:03:52.590><c> exporting</c>

00:03:55.970 --> 00:03:55.980 align:start position:0%
 
 

00:03:55.980 --> 00:03:58.040 align:start position:0%
 
you