Spreadsheets Page Setup And Printing

Step by step guide to some of the options when printing in Excel.

Includes print preview, page breaks, page setup and formula view

1. www.MoreThanMaths.com
Learn how to:
•See what your printed spreadsheet
will look like
•Change margins, page layouts and
headings
•Put in page breaks
•Print the spreadsheet showing the
formulae that you used

2. www.MoreThanMaths.com
Print Preview
•It’s always a good idea to see what
your print out will look like before
you actually print it.
•Then you can avoid wasting paper
and printer ink.
•You can do this by using Print
Preview

3. www.MoreThanMaths.com
Print Preview:
Just click File, then
choose Print
Preview

4. www.MoreThanMaths.com
Print Preview:
Now you can see if
your print out looks
OK.
If it doesn’t, you will
need to change
some things before
you print.

5. www.MoreThanMaths.com
Page Breaks
•Excel often puts half of a table on
one page and the other half on
another page. Not much good!
•You can decide where you want one
page to stop and a new page to start
using Page Breaks

6. www.MoreThanMaths.com
Page Breaks:
After you have
done a Print
Preview, a dotty
line like this shows
your where one
page ends and the
next one starts.

7. www.MoreThanMaths.com
Page Breaks :
If I select this cell
and click on
Insert, then choose
Page Break my
page will start at
the start of my
table.
Much more
sensible!

8. www.MoreThanMaths.com
Page Setup
•You can change the way that your
print out will look by using Page
Setup
•You can use Page Setup to
–Set the paper size
–Choose portrait or landscape
–Add page headings
–And much more!

9. www.MoreThanMaths.com
Using Page Setup:
1. Click on File
and then choose
Page Setup

10. www.MoreThanMaths.com
Using Page Setup:
You will see this
dialogue box.
It has several
tabs, each one
takes you to a
different section.

11. www.MoreThanMaths.com
Using Page Setup:
The page tab
Choose portrait
or landscape
Choose a paper
size

12. www.MoreThanMaths.com
Using Page Setup:
The page tab
You can scale
your work to
make it all fit
onto one page,
but be careful –
you might end
up with very
small writing!

13. www.MoreThanMaths.com
Using Page Setup:
The margins tab
Choose the
margins you want
for your paper
Print in the
centre of the
paper

14. www.MoreThanMaths.com
Using Page Setup:
The
header/footer tab
Choose Custom
Header

15. www.MoreThanMaths.com
Using Page Setup:
Choose what
you want in your
heading.
It’s a good idea to
type your name as a
heading!

16. www.MoreThanMaths.com
Using Page Setup:
Choose what to
print. You might
want to tick this
to print the
gridlines.
The sheet tab

17. www.MoreThanMaths.com
Printing Out Your Formulas
•You can show someone what
calculations your spreadsheet is
doing.
•Watch out – this will change all of
your column widths, but DON’T
PANIC – they will change back!

18. www.MoreThanMaths.com
Printing Out Your Formulas :
Just click Tools,
then choose
Options

19. www.MoreThanMaths.com
Printing Out Your Formulas :
This dialogue box
will appear.
Click to put a tick
(check) next to
formulas.
Then Click OK

20. www.MoreThanMaths.com
Printing Out Your Formulas :
Now you can see
the formulas.
This is what will
print out
DON’T PANIC
about the column
widths! Just leave
them as they are.

21. www.MoreThanMaths.com
Printing Out Your Formulas :
To change back,
just click Tools,
then choose
Options.
Then get rid of the
tick next to
formulas. Easy!

22. www.MoreThanMaths.com
Summary:
•Use Print Preview before you print your
work. Choose File -> Print Preview
•Use Page Setup to change the way that
your work looks when you print it.
Choose File -> Page Setup
•To display your calculations, choose
Tools -> Options and click on Formulas