ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Vertical centering not functioning for print (https://www.excelbanter.com/excel-discussion-misc-queries/190033-vertical-centering-not-functioning-print.html)

Tony Paskitti

Vertical centering not functioning for print
 
In Excel, when going to print, I have selected the box center on page
vertically. It has no effect and I have deleted all the cells below the text.
The document will not center vertically.

The horizontal is working properly.

Bobt

Vertical centering not functioning for print
 
When you say "I have deleted all the cells below the text.", do you mean:

(A) I cleared the cell contents/formatting.
(B) I have set my printing cell range to exclude any empty cells beneath
what I want to print.

If (A) then, that's not what you need to do. You need to ensure that your
print range is set to be only what you what to print (and center). From the
FILE menu, choose SET PRINT RANGE (I'm on 2007 and that menu doesn't exist
any more, so I can't confirm the submenu option).

"Tony Paskitti" wrote:

In Excel, when going to print, I have selected the box center on page
vertically. It has no effect and I have deleted all the cells below the text.
The document will not center vertically.

The horizontal is working properly.



All times are GMT +1. The time now is 02:12 PM.

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