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. |
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