"Center across selection" rather than "Merge cells"

[Elardus]

I use "Center across selection" and almost never "Merge cells", which is
generally a bad choice (across columns anyway).

I wish to add an icon or otherwsie modify the "Merge Cells" icon through the
toolbars "Customization" process but unfortunately I cannot find "Center
across selection" amonst the "Commands - Fomat"choices.

Which means I have to do my "Cnter cross seletionâ€always via the menu.... Or
create an icon through a macro…

Can you please add an icon for “Center across selection†in the "Formatting"
toolbar? Better still, don’t even have the “Merge cells†icon there.
Horizontal merging leads to all kind of problems…..


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...7-18dbccc13740&dg=microsoft.public.excel.misc

 

[Bob Phillips]

You could easily create a macro to do it and assign it to a toolbar button.

 

[Don Guillett]

Here is the one I use in my personal.xls assigned to a toolbar button right
next to the unmerge button

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

 

[Don Guillett]

I didn't realize that you had posted and posted and posted. GEEZ

 

[Don Guillett]

Not meant for you Bob

 

[Bob Phillips]

No, nobody calls me GEEZ <G>

 

[Gord Dibben]

I posted the same code to his other thread.

Time to start ignoring these multi-posts re: center across selection


Gord

 

[Don Guillett]

Are you sure??

 

[John C]

It is Bob's pre-First name, as in GEEZ Bob, what'd you do this time?

 

[Bob Phillips]

No, that is usually WTF Bob, what'd you do this time? <bg>

 

[John C]

Sorry, you're right, I saw it on the edited for TV portion, it was badly
dubbed on further inspection