What shortcut for marge more than one cell in Microsoft Excel?

Thank you for your question.

Here is the fastest way you can use. Use the below shortcut

Alt+H+M+C

to Unmerge use the same shortcut.

 

Regards

This image is a shortcut to the merge tool that merges more than one cell

 

Merging cartels two or more cells to generate a new, larger cell. This is a prodigious way to create a label that spans numerous columns.

 

1. Select two or more adjacent cells that you want to merge.

2. On the HOME tab, JUST select Merge & Center.

 

 

 

 

 

If  "Merge & Center" is dimmed, make sure that you’re not editing a cell and the cells you want to merge aren’t formatted as an Excel table. Cells formatted as a table usually have alternating shaded rows and filters on the column headings.

To merge cells without centering, click the arrow next to Merge and Center, and then click Merge Across or Merge Cells.

 

 

 

 

 

 

 

Excel allows you to merge cells together in two ways: using the Merge and Center tool on the ribbon or toolbar, or by using the controls in the Alignment tab of the Format Cells dialog box. If you merge cells quite a bit, you might long for a shortcut that will merge whatever cells you've selected.

Unfortunately, Excel doesn't include such a shortcut. You can, however, create one using a macro. The following is a simple macro to merge whatever cells you've selected:

Sub MergeCells1() Selection.Merge End Sub

After you create the macro, you can assign it to a keyboard shortcut and you are set to go. If you instead want a macro that is a shortcut for the Merge and Center tool, then you can use the following:

Sub MergeCells2() With Selection .HorizontalAlignment = xlCenter .Merge End With End Sub