There is one icon that merges and centers selected cells ("Merge and
Center"). Unfortunately, the icon on centers the data horizontally. The
data remains bottom-justified. Is there a way to?:
1) Modify the macro (or whatever) drives this icon's function?
2) Create a new icon and function to do what I need?
3) Change the default alignment within a cell (whether merged or not)?
Thanks in advance!

Hi,
this might answer part of your questions:

To center vertically you can use the built-in icon:
- menu View Tollbars Customize, the Customize dialog pops up
- in tab Commands, select Format from the Categories list, and from the
COmmands list, locate the Center VErically icon and drag it to one of your
current toollbars.

I dont'think there is a builtin merge+center vertically.
--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"Jim J." wrote:

There is one icon that merges and centers selected cells ("Merge and
Center"). Unfortunately, the icon on centers the data horizontally. The
data remains bottom-justified. Is there a way to?:
1) Modify the macro (or whatever) drives this icon's function?
2) Create a new icon and function to do what I need?
3) Change the default alignment within a cell (whether merged or not)?
Thanks in advance!