There is no icon for "center across selection"

I wrote my own and assigned it to a button on my toolbar.

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

You could assign to a shortcut key.


Gord Dibben MS Excel MVP

On Wed, 14 Nov 2007 13:55:01 -0800, K Bronson <K
wrote:

I agree with this way to fix the problem; i have looked for a long time for
an icon I could put in my toolbar to save the multiple steps to make it work.
Does anyone know of such an icon?

"JE McGimpsey" wrote:

One way:

Put "Burger" in the heading cell of the left-hand column. Select that
cell and the one to the right. Choose Format/Cells/Alignment, and choose
Center across Selection from the Horizontal: dropdown.

You *could* also merge the two cells and center the text, but merged
cells are the devil's invention, and should never, ever, be used. Not
even once...

In article . com,
wrote:

I need to put two columns under one heading in Excel. Is there any
way this can be done? For example, let's say I need the heading
Burger, and underneath that heading I need one column reading
cheeseburger and the other hamburger, both under the same heading.
Does that make sense? Can this be done? Thank you for your help.