As a selection of a range of cells, and the copy and paste action are afected
when crossing a merged cell, I prefer to center cells across selection, not
to merge them; it will be usefull to have a bar button with this command.

----------------
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/comm...et.f unctions

While I agree this would be a great built-in option, you can build your
own.

I use this macro

Public Sub CenterAcrossSelection()
On Error Resume Next
Selection.HorizontalAlignment = xlCenterAcrossSelection
On Error GoTo 0
End Sub

attached to a button on my custom toolbar.

In article ,
Plantimacros wrote:

As a selection of a range of cells, and the copy and paste action are afected
when crossing a merged cell, I prefer to center cells across selection, not
to merge them; it will be usefull to have a bar button with this command.