Vertical centering not functioning for print

T

Tony Paskitti

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

BobT

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

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

Similar Threads

Move Chart with Text 0
Table of content - format does not get saved 2
Print (physical or pdf) not respecting format of source document 0
vertical centering of data 4
Page numbering with Merged Document and IF statements 1
Line not showing on print 3
Creating Labels Over 3-Up Image 2
Prompt For Replace in Selection And More... 0

Top