Hi Gord, Thanks for your feedback but I don't know how to enter the info you
provided. Can you provide further assistance. I appreciate it.

Mike

"Gord Dibben" wrote:

There is no "center across selection" button available unless it has been added
in 2007

I added a button and a macro to toggle on/off.

Sub TOGGLECENTERACROSS()
With Selection
If .HorizontalAlignment = xlCenterAcrossSelection Then
.HorizontalAlignment = xlGeneral
Else
Selection.HorizontalAlignment = xlCenterAcrossSelection
End If
End With
End Sub


Gord Dibben MS Excel MVP

On Sun, 25 Jun 2006 07:39:20 -0500, "Don Guillett"
wrote:

select columnsright clickformatalignmenthorizontalcenter across.
You can customize your toolbar to put the icon for this on the toolbar
I do NOT recommend merge cells.