Centralizing text in Merged Cell

S

sparky3883

Hi all.

I was wondering if someone would be able to help me with a wee proble
that i am having regarding a rota that i have created for work.

In Column B, I have merged every two rows. What I would like to happe
is, when i input a number, i would like that number to be represente
in the centre of the merged cells. I inputted a number and then clicke
on Central align and although the text was aligned to the centre, i
was aligned to the bottom centre of the cell, not the middle centre.

Is it possible to align text to the middle of a merged cell?

Thanks in advance

I have included my rota so you know what i mean. Thanks agai

Attachment filename: rota.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=62057
 
D

Dave Peterson

It centered nicely for me in xl2002.

Are you sure you set the Vertical alignment?
 

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

Merged cell data tabulated in columns 4
? to align decimals when we centre the text in a cell 10.1, 100.1 3
Different alignment for Text & Numbers 1
where text wraps in a cell, how can the row height be auto set? 27
Wrapping Text in a Merged Cell 2
wrapping text and autofit in merged cell 1
merged cell wrap text autofit issue 3
Wrap Text in Merged Cell - How? 8

Top