Merge and Center

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

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

Thanks in advance
 
Hi
AFAIK there's no shortcut for this. You may record a macro while doing
this manually and assign a shortcut to this macro
 
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
 
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.
 
You could use this
Sub CenterAcross()
Selection.HorizontalAlignment = xlCenterAcrossSelection
End Sub
 
Back
Top