Archive of Mr Excel Message Board

Back to Printing in Excel archive index
Back to archive home

Does Not Center When I Print??

Posted by Cory on January 07, 2002 6:31 AM

I have an excel sheet, the size of it is landscape "A".
My problem is that when I print it out, it shifts to the far left or right of the page, instead of the center. I have went in and adusted the margins and messed aroung with the page set up to center it, but no matter what I do, the page will always shift to the edge of the paper when print?????

Re: Does Not Center When I Print??

Posted by George J on January 10, 2002 8:26 AM

To print something centred in excel, you should just have to go to file/page-setup/ click on the margins tab and at the bottom there is centre horizontally/vertically boxes you can select. If this is not working go to print preview and see if there are any other cells with data entered in them. Also go to file/print-area and clear print area, then reselect the A column. This should take care of it.

George

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.