Is there a keyboard shortcut for Merge and Centre?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike Barnard - 30 Jul 2008 23:06 GMT

Excel 2003 on XP. As header.

This will be even quicker than my last post.

I know I can use the button, or I can go into format cell properties,
but is there a keypress I can use? Ctrl something?

Thanks.

Reply to this Message

Wigi - 30 Jul 2008 23:50 GMT

Nope.

See http://exceltips.vitalnews.com/Page/T003095_Shortcut_to_Merge_Cells.html

Signature

Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music

> Excel 2003 on XP. As header.
>
[quoted text clipped - 4 lines]
>
> Thanks.

Reply to this Message

Mike Barnard - 31 Jul 2008 18:44 GMT

>Nope.
>
>See http://exceltips.vitalnews.com/Page/T003095_Shortcut_to_Merge_Cells.html

Nice, thanks.

Reply to this Message

Gord Dibben - 31 Jul 2008 17:11 GMT

Mike

My suggestion is you lose the merge and center button somehwere and forget
about a shortcut key.

You will be much better off without any merged cells which create no end of
problems.

Gord Dibben MS Excel MVP

>Excel 2003 on XP. As header.
>
[quoted text clipped - 4 lines]
>
>Thanks.

Reply to this Message

Mike Barnard - 31 Jul 2008 18:42 GMT

>Mike
>
[quoted text clipped - 3 lines]
>You will be much better off without any merged cells which create no end of
>problems.

Agree, but I'm working with sheets designed by someone else 3 years
ago. There are lots of cells that are 3 cells merged and my updates
have to fit it.

Thanks anyway.

>Gord Dibben MS Excel MVP
>
[quoted text clipped - 6 lines]
>>
>>Thanks.

Reply to this Message

Jim Rech - 31 Jul 2008 19:54 GMT

You can always create your own shortcuts with a macro. Copy these two to a
workbook and run the first. Then Ctrl-Shift-M will toggle Merge and Center.

Sub SetMandC()
Application.OnKey "^M", "MandC"
End Sub

Sub MandC()
If Selection.MergeCells Then
Selection.MergeCells = False
Selection.HorizontalAlignment = xlGeneral
Else
Selection.MergeCells = True
Selection.HorizontalAlignment = xlCenter
End If
End Sub

Signature

Jim

|
| >Mike
[quoted text clipped - 21 lines]
| >>
| >>Thanks.

Reply to this Message