Merge and Center

[Michael]

Hi All
Does anyone know the keyboard shortcut for merge and
center (UK Keyboard)

Thanks in advance

 

[Frank Kabel]

Hi
AFAIK there's no shortcut for this. You may record a macro while doing
this manually and assign a shortcut to this macro

 

[RagDyeR]

Isn't there a "Merge & Center" icon on the default toolbar?

Since I don't use "Merge" I always delete it immediately after sitting at a
new machine, but it should be there.
It can be found on the Format toolbar.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hi All
Does anyone know the keyboard shortcut for merge and
center (UK Keyboard)

Thanks in advance

 

[Ken Wright]

Would strongly suggest considering 'Centre across selection' long before going
anywhere near merged cells. Hate the things myself - can cause more trouble
than they are worth.

 

[Don Guillett]

You could use this
Sub CenterAcross()
Selection.HorizontalAlignment = xlCenterAcrossSelection
End Sub