Print What You Want to Print,

1
Efficient and Excellent ExcelA Papercuts
Presentation

• Print What You Want to Print,
• Not What You Dont

2
Efficient and Excellent Excel
Heres a really big spreadsheet showing paper use
from January through December 2006. Youll make
it fit on one page by highlighting the area to
print, then selecting it in File gt Print Area.
3
Efficient and Excellent Excel
You highlight the area
4
Efficient and Excellent Excel
Then you go to Print Area gt Set Print Area.
5
Efficient and Excellent Excel
Then click Print Preview to see how it will
appear on your printed page.
6
Efficient and Excellent Excel
Perfect. Your spreadsheet fits on one page.
7
Efficient and Excellent Excel
Here are other tricks to make your Excel
spreadsheet fit the page without wasting paper.
8
Efficient and Excellent Excel
First click on Print Preview to see how your
spreadsheet will look as its set up currently.
Only the first two columns show this isnt what
you want!
9
Efficient and Excellent Excel
Go to Page Setup to see how its set.
10
Efficient and Excellent Excel
Its set to Portrait orientation and Letter paper
size. That can be changed.
11
Efficient and Excellent Excel
Change it to Landscape and Legal. Then go back
to Page Preview to see how it looks.
12
Efficient and Excellent Excel
This is better, but the two far-right columns
still arent printing on one page.
13
Efficient and Excellent Excel
Scroll down a little and youll see theyre going
to print on a separate page. What a waste of
paper that would be!
14
Efficient and Excellent Excel
Fix it by using the Scaling feature in Page
Setup. Click the Fit to button and enter 1
in page(s) wide. Take out any number that
appears in by page(s) tall. Then click OK.
15
Efficient and Excellent Excel
Check Print Preview to make sure all your columns
will print now. Yes they will.
16
Efficient and Excellent Excel
But your headings only show on the first page.
Its a long document -- your reader might forget
what each column contains unless you label the
columns on all pages.
17
Efficient and Excellent Excel
Theres an easy way to make column headings
appear on each page. First go to Page Setup gt
Sheet gt Rows to repeat at top.
18
Efficient and Excellent Excel
Now click on the document icon at the right of
Rows to repeat at top.
19
Efficient and Excellent Excel
The program prompts you to enter which rows you
want to repeat at the top of each page.
20
Efficient and Excellent Excel
Click on the 1 at the left of the first row to
automatically enter the Rows to repeat at top.
21
Efficient and Excellent Excel
Now click on the icon to return to Page Setup,
where youre still on the Sheet tab.
22
Efficient and Excellent Excel
Click OK.
23
Efficient and Excellent Excel
To verify that your pages look the way you want
them to, go to Print Preview and scroll down.
The first row is repeated on each page,
displaying column headers on each page of the
printed spreadsheet. Success!
24
Efficient and Excellent Excel
And if you decide you dont want to print the
entire document, its easy to print only a
selected area.
25
Efficient and Excellent Excel
Use the cursor to highlight the area you want to
print
26
Efficient and Excellent Excel
Then go to File gt Print Area gt Set Print Area.
27
Efficient and Excellent Excel
To verify that youve selected the area you
really want to print, go to Print Preview to see
the portion that will be printed.
28
Efficient and Excellent Excel
If you want to clear or reset the print area,
just return to File gt Print Area.
29

• Reduce unnecessary paper use.
• Tell your co-workers what youve learned.

http//www.seattle.gov/papercuts/