Goodwill Community Foundation creating
opportunities for a better life
because workbooks are designed to be
viewed electronically it can be hard to
tell what your data might look like
outside of Excel for example if you plan
to print it or save it as a PDF luckily
there are several different ways to view
and customize your layout to get started
I recommend switching to page layout
view using the command in the bottom
right corner this will help you
visualize the final product as you make
changes to your workbook next go to the
page Layout tab on the ribbon here
you'll find everything you need to
modify your page orientation margins
print titles and more for example our
current orientation is portrait or
vertical a good choice if your goal is
to fit more rows on each page I'd like
to switch to landscape or horizontal so
I can fit more columns instead just
click the orientation command then
choose landscape and you'll instantly
see the change there's still one column
that's getting cut off on the right but
that's okay if we adjust the margins we
should be able to fit all the columns on
a single page all you have to do is
click the margins command here you can
choose one of the predefined sizes or
you can customize your margins depending
on what you need just go back to the
margins command but this time click
custom margins I'm going to make the
left and right margins just a little bit
wider at 0.5 inches instead of 0.25 when
you're done click OK and your worksheet
will be updated you can also add headers
and footers to your workbook to make the
printed copy easier to read in this
example we'll add a header by clicking
the area here this opens the design tab
for working with headers and footers
from here you can easily add page
numbers today's date and other
information to your header or footer all
you have to do is click the command you
want
how about page numbers when you're done
click anywhere else in your worksheet to
exit now the pages are numbered page 1
and page 2 here's a tip if
worksheet uses title headings you can
include them on each page to make the
printed copy easier to read for example
in this workbook it would really help me
to know what months these sales figures
are for just go back to your title
headings then click the print titles
command next click the button next to
the field you want to repeat you can
choose either rows or columns the dialog
box will collapse and your cursor will
turn into a selection arrow from here
select the data you want to repeat on
each page then click the button again to
go back to the dialog box when you're
done click OK now my header row appears
at the top of page 1 and page 2 there's
one more thing I'd like to change about
my layout notice how the data is split
up so page 2 only contains about 9 or 10
rows I'd like more control over that
instead of the last couple of rows I
want the data to be divided evenly 20
people on each page to do this I'm going
to switch to the page break preview
using the command in the bottom right
corner this makes it easy to review your
page breaks so you can easily insert
your own simply select the row below
where you want the page break to appear
then click the breaks command and choose
insert page break if we switch back to
page layout view and zoom out just a
little we can see that the data is
divided evenly between page 1 and page 2
now you have all the tools you need to
customize your page layout and prepare
your workbook for printing or exporting
you