View Single Post
  #3   Report Post  
Old November 5th 08, 01:55 PM posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
First recorded activity by ExcelBanter: Jul 2006
Posts: 10,124
Default "Center across selection" rather than "Merge cells"

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

With Selection
If .HorizontalAlignment = xlCenterAcrossSelection Then
.HorizontalAlignment = xlGeneral
Selection.HorizontalAlignment = xlCenterAcrossSelection
End If
End With
End Sub

Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bob Phillips" wrote in message
You could easily create a macro to do it and assign it to a toolbar



"Elardus" wrote in message
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
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....
create an icon through a macro.

Can you please add an icon for "Center across selection" in the
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
Agree" button in the message pane. If you do not see the button, follow
link to open the suggestion in the Microsoft Web-based Newsreader and
click "I Agree" in the message pane.