How do I get Excel to print in page centre?

S

SimoninParis

I am sure that, in previous versions, you could entre what you want to print
without having to adjust margins and guess where the print might end up. Is
this still possible with 2007?
 
B

Blinds Nottingham

Yep should do.

I would recommend setting a print area, for what you require then if
you go to the page layout on the toolbar and click on margin you will
then see horizontal and vertical centres
remember if you havent change the print scaling to 1 page rather than
a 100% option you may not see any difference

you can access the page scaling from the page margins from the ribbon
and then clicking on the page tab

hope that help

Nick
Bradrail Awnings and Blinds
http://www.bradrail.co.uk
 
T

trip_to_tokyo

In EXCEL 2007 try the following:-

- Page Layout

- click in arrow in lower right hand corner

- Page Setup should launch

- Margins tab

- select Horizontally and Vertically

- OK

If my comments have helped please hit Yes.

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top