"Center across selection" rather than "Merge cells"


E

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
 
Ad

Advertisements

B

Bob Phillips

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

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
 
Ad

Advertisements

G

Gord Dibben

I posted the same code to his other thread.

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


Gord
 
Ad

Advertisements

J

John C

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

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top