vertically center text in merged cells?

H

HurtinUnit19

Hello,

I have two merged cells, A10 & A11. When I enter text into the merged
cell and try and center it, the text is only centered in the
horizontal plane. This leaves a gap in the merged cell above the text
and looks unattractive. I'd like to center the text vertically. Is
this possible? I am using Excel 97.

TIA

Hurtin
 
G

Guest

Stay away from merged cells, that will save you potential troubles
in the future
Having said that I can't reproduce that on excel 2000 if I select center
in both the vertical and horizontal boxes

Regards,

Peo Sjoblom
 
D

Don Guillett

Since I don't use merged cells, try
right click>format>alignment>horizontal>center across>and then the other
options.

Don Guillett
SalesAid Software
(e-mail address removed)
 

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

Automatically color merged cells 1
Help with merged cells 1
Auto Row Height with Wrapped Text in Merged Cells Problem 3
Getting word wrap to work in a merged cell 1
AutoFilter column w/merged cells 2
Pasting into merged cells 1
Wrap text in merged cells VBA 2
some text shows in merged cells but not all 2

Top