Thanks John. The problem is that one you go to another cells or a different
workbook, you have to again format the cells using the procedure you just
mention. I was hoping to have it make "center-center" by default.

Odarit

"John" wrote:

Hi
Goto FormatCellsAlignment adjust Vertical
HTH
John
"Odarit" wrote in message
...
When I merge cells, Excel merges and centers the data to be placed
horizontally. However, the vertical alignment remains or is defaulted to
"bottom". How can I make Excell to center the merge cells to show data
center
in either direction, vertical and horizontal?

Thanks