Merge keyboard shortcuts in Excel

Anyone who uses Excel knows the Merge tool to mix adjacent cells together into one cell. However, not all users are proficient in using the Merger shortcut to save time. Today Dexterity Software will introduce you to read some keyboard shortcuts to Merge in Excel.

Merge keyboard shortcuts in Excel Picture 1

Use the available shortcut combinations

For example, if you have the following worksheet, you need to mix cells A1, B1, C1, E1, F1, G1 into one header cell.

Merge keyboard shortcuts in Excel Picture 2

Step 1 : You select (blacken) cells A1, B1, C1, E1, F1, G1.

Step 2: Press and hold the ALT key on the keyboard. On the Ribbon of Excel will appear black squares with characters.

Merge keyboard shortcuts in Excel Picture 3

Step 3 : Keep holding the ALT key , press the H key to select the Home tab .

Merge keyboard shortcuts in Excel Picture 4

Step 4: Keep holding the ALT key , continue to press the M key to select the Merge tool .

Merge keyboard shortcuts in Excel Picture 5

Step 5 : Keep holding the ALT key .

1. To select Merge and Center (Mix and Align) press C;
2. To select Merge Across (Merge cells of the same line into one cell), press A;
3. To select Merge Cells, press the M key;
4. To delete the Merge setting (Split merged cells into single cells), press the U key.
5. The result is obtained if Ad selects the C key in Step 5 .

Merge keyboard shortcuts in Excel Picture 6

Set up the Merge shortcut by running Macro

You can create your own keyboard shortcuts for the Merge tool by creating a small Macro for Excel.

To show Developer card, click here (http://TipsMake.vn/macro-trong-excel-la-gi-cach-tao-va-chay-1-macro-trong-excel/)

Step 1: Open the VBA window by selecting the Developer tab (1) => click on the Visual Basic icon (2) .

Merge keyboard shortcuts in Excel Picture 7

Step 2: Microsoft VBA window appears, select Insert (1) => click on the Module icon (2) .

Merge keyboard shortcuts in Excel Picture 8

Step 3: Copy the following code into the Module .

Sub MergeColumns() Selection.MergeCells = True End Sub

Merge keyboard shortcuts in Excel Picture 9

Step 4: Return to the Excel interface by pressing Alt + Q . Press the key combination Alt + F8 to open the Macro window. Select the Marco MergeColumns you just created, click the Options button .

Merge keyboard shortcuts in Excel Picture 10

Step 5 : Macro Options dialog box appears. In the Shortcut key section,  type the character you want to set, for example Q (when calling Macro, press Ctrl + Q). Click OK to close the Macro Options window . And Cancel to close the Macro window .

Merge keyboard shortcuts in Excel Picture 11

Step 6: You need to mix black-box, press Ctrl + Q . And get the results:

Merge keyboard shortcuts in Excel Picture 12

Note: You should avoid Excel's default keyboard shortcuts to avoid confusion.

Good luck!