Excel keyboard shortcut....?

Question

Easy points.....

Is the a keyboard shortcut for merging cells in excell? and what is it?

cheers. DG.

Answer 1

There is no predefined shortcut for this action built into Excel. However, you can use the following sequence to achieve the result.



Ctrl+1 A Alt+M Enter



If you need to repeat the process just press F4 to repeat your last action.



You could also create a macro to do the same thing.



Code:

Sub MyMerge()

On Error Resume Next

Selection.Merge

End Sub



Sub TurnOnMyMerge()

Application.MacroOptions "MyMerge", ShortcutKey:="M"

End Sub



Sub TurnOffMyMerge()

Application.MacroOptions "MyMerge", ShortcutKey:=""

End Sub



Execute the "TurnOnMyMerge" macro, and that will make Control Shift M the shortcut for merge.

Answer 2

No BUT it is easy enough to create a macro to do that and then assign a shortcut key to that macro.



In Excel press ALT+F11, this will bring up a Visual Basic Editor (where macro's are stored). Hopefully on hte left hand pane you will see something called VBAProject(PERSONAL.XLS). Expand that, Expand Module. If you do not have any modules right click on the VBAPRoject bit and select Insert Module. Double click on the module to activate it. On the right hand window you will see a blank page. Copy and paste the following into it.



Sub MergeMe()



' Keyboard Shortcut: Ctrl+Shift+M



With Selection

.MergeCells = True

End With



End Sub



Now. Close the VB editor and return to main Excel Screen. Go back to Tools>Macros and click on the play button. A popup window should appear. Look for "PERSONAL.XLS!MergeMe" in the list and click on it once to select it. Then click on the Options button. Another pop-up should appear (this is where you can specify the shortcut key) click in the little box next to CTRL+and then select the keys you want to be the shortcut. I held down the SHIFT key and M for mine. then click on OK and the cancel.



All being well, when you select a continuous range of cells and press CTRL+SHIFT+M the cells should merge.



Good Luck



ps when you exit excel it will prompt you asking if you want to save changes to personal.xls - SAY YES.

Answer 3

There is no built in shortcut to merge, however, you can create one yourself. Create a macro with the following code



Sub merge()

Call Selection.merge

End Sub



And you can then assign it a keyboard shortcut from the Macro Options panel (access via Alt+F8 and click the 'Options...' button.

Answer 4

In Excel 2004, and presumably 2003, you can go to Tool>Customize>Keyboard and create a shortcut for (from the Format menu) "Merge and Center"

Answer 5

in Excel 2003 press F1, fill keyword "keyboard shortcuts" in "Search for" box

Answer 6

CTRL+SHIFT+* (asterisk)