WEBVTT
Kind: captions
Language: en

00:00:11.240 --> 00:00:14.670
Because workbooks are designed to be viewed
electronically, it can be hard to tell what

00:00:14.670 --> 00:00:18.490
your data might look like outside of Excel
(for example, if you plan to print it, or

00:00:18.490 --> 00:00:23.410
save it as a PDF). Luckily, there are several
different ways to view and customize your

00:00:23.410 --> 00:00:24.860
layout.

00:00:24.860 --> 00:00:28.980
To get started, I recommend switching to Page
Layout view using the command in the bottom

00:00:28.980 --> 00:00:33.690
right corner. This will help you visualize
the final product as you make changes to your

00:00:33.690 --> 00:00:34.750
workbook.

00:00:34.750 --> 00:00:39.980
Next, go to the Page Layout tab on the ribbon.
Here you'll find everything you need to modify

00:00:39.980 --> 00:00:43.760
your page orientation, margins, print titles,
and more.

00:00:43.760 --> 00:00:48.890
For example, our current orientation is portrait
(or vertical)—a good choice if your goal

00:00:48.890 --> 00:00:54.190
is to fit more rows on each page. I'd like
to switch to landscape (or horizontal) so

00:00:54.190 --> 00:00:57.040
I can fit more columns instead.

00:00:57.040 --> 00:01:02.549
Just click the Orientation command... then
choose Landscape. And you'll instantly see

00:01:02.549 --> 00:01:07.770
the change. There's still one column that's
getting cut off on the right, but that's okay.

00:01:07.770 --> 00:01:12.830
If we adjust the margins, we should be able
to fit all the columns on a single page.

00:01:12.830 --> 00:01:17.579
All you have to do is click the Margins command.
Here you can choose one of the predefined

00:01:17.579 --> 00:01:22.909
sizes... or you can customize your margins
depending on what you need.

00:01:22.909 --> 00:01:28.179
Just go back to the Margins command... but
this time, click Custom Margins. 

00:01:29.460 --> 00:01:34.140
I'm going to make the left and right margins
just a little bit wider at .50 inches, instead

00:01:34.140 --> 00:01:36.390
of .25.

00:01:36.390 --> 00:01:41.509
When you're done, click OK... and your worksheet
will be updated.

00:01:41.509 --> 00:01:45.189
You can also add headers and footers to your
workbook to make the printed copy easier to

00:01:45.189 --> 00:01:50.659
read. In this example, we'll add a header
by clicking the area here.

00:01:50.659 --> 00:01:55.139
This opens the Design tab for working with
headers and footers. From here, you can easily

00:01:55.139 --> 00:01:59.979
add page numbers, today's date, and other
information to your header or footer. All

00:01:59.979 --> 00:02:05.100
you have to do is click the command you want.
How about Page Numbers?

00:02:05.100 --> 00:02:09.979
When you're done, click anywhere else in your
worksheet to exit. Now the pages are numbered

00:02:09.979 --> 00:02:14.880
page 1... and page 2.

00:02:14.880 --> 00:02:18.530
Here's a tip if your worksheet uses title
headings: you can include them on each page

00:02:18.530 --> 00:02:23.030
to make the printed copy easier to read. For
example, in this workbook, it would really

00:02:23.030 --> 00:02:26.610
help me to know what months these sales figures
are for.

00:02:26.610 --> 00:02:33.280
Just go back to your title headings... then
click the Print Titles command. Next, click

00:02:33.280 --> 00:02:40.280
the button next to the field you want to repeat—you
can choose either rows or columns.

00:02:40.280 --> 00:02:45.420
The dialog box will collapse, and your cursor
will turn into a selection arrow. From here,

00:02:45.420 --> 00:02:49.750
select the data you want to repeat on each
page... then click the button again to go

00:02:49.750 --> 00:02:52.810
back to the dialog box.

00:02:52.810 --> 00:02:59.450
When you're done, click OK. Now my header
row appears at the top of page 1... and page

00:02:59.450 --> 00:03:01.420
2.

00:03:01.420 --> 00:03:05.340
There's one more thing I'd like to change
about my layout. Notice how the data is split

00:03:05.340 --> 00:03:10.950
up so page 2 only contains about 9 or 10 rows?
I'd like more control over that. Instead of

00:03:10.950 --> 00:03:17.200
the last couple of rows, I want the data to
be divided evenly—20 people on each page.

00:03:17.200 --> 00:03:21.370
To do this, I'm going to switch to the Page
Break Preview using the command in the bottom

00:03:21.370 --> 00:03:26.260
right corner. This makes it easy to review
your page breaks so you can easily insert

00:03:26.260 --> 00:03:27.920
your own.

00:03:27.920 --> 00:03:33.480
Simply select the row below where you want
the page break to appear. Then click the Breaks

00:03:33.480 --> 00:03:38.590
command... and choose Insert Page Break.

00:03:38.590 --> 00:03:43.230
If we switch back to Page Layout view, and
zoom out just a little... we can see that

00:03:43.230 --> 00:03:47.650
the data is divided evenly between page 1
and page 2.

00:03:47.650 --> 00:03:51.930
Now you have all the tools you need to customize
your page layout, and prepare your workbook

00:03:51.930 --> 00:03:53.450
for printing or exporting.