View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim J. Jim J. is offline
external usenet poster
 
Posts: 11
Default How do you change the default alignment of merged cells?

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!