ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I get Excel to print in page centre? (https://www.excelbanter.com/excel-discussion-misc-queries/254907-how-do-i-get-excel-print-page-centre.html)

SimoninParis

How do I get Excel to print in page centre?
 
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?

Blinds Nottingham

How do I get Excel to print in page centre?
 
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

trip_to_tokyo[_3_]

How do I get Excel to print in page centre?
 
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.



"SimoninParis" wrote:

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?



All times are GMT +1. The time now is 06:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com