add 'centre across selection' to ribbon?

[merlin777]

Is it possible to add the 'centre across selection' function to the ribbon? I use it a lot and it's quite fussy to get to.
thanks!

its excel 2007.

thanks

 

[UniMord]

As a simple shortcut, the best I could find was to add Alignment Settings to the QAT. This opens up the alignment dialog box, saving you a few extra clicks.

Alternatively, you can drop the following, one-line macro, into your Personal.xlsb, and add it to your QAT, making it a one-click operation:

Sub CenterAcrossSelection()
    Selection.HorizontalAlignment = xlCenterAcrossSelection
End Sub

 

[merlin777]

thanks!