Merge Shortcuts in Excel

Anyone using Excel is familiar with the Merge tool, which is used to combine adjacent cells into one. However, not all users are proficient in using Merge shortcuts to save time. Today, Software Tips will introduce readers to some shortcuts for merging cells in Excel.

Utilizing Available Shortcut Combinations

For example, suppose you have the following spreadsheet. You need to merge cells A1, B1, C1, E1, F1, and G1 into a single header cell.

Step 1: Highlight cells A1, B1, C1, E1, F1, G1.

Step 2: Press and hold the ALT key on your keyboard. The Excel Ribbon will display black squares with characters.

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

Step 4: While still holding the ALT key, continue to press M to choose the Merge tool.

Step 5: Still holding the ALT key.

• To select Merge and Center, press the C key;
• To select
  Merge Across, press the A key;
• To select Merge Cells, press the M key;
• To undo Merge settings, press the U key.
• The outcome if Ad chooses the C key in Step 5.

Setting Merge Shortcut via Macro

You can easily create your own shortcut for the Merge tool by setting up a small Macro in Excel.

To display the Developer tab, click here (https://Mytour/macro-trong-excel-la-gi-cach-tao-va-chay-1-macro-trong-excel/)

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

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

Step 3: Copy the code snippet below into the Module.

Sub CombineCells()
  Selection.MergeCells = True
End Sub

Step 4: Return to the Excel interface by pressing the Alt + Q key combination. Then press Alt + F8 to open the Macro window. Select the MergeColumns macro you just created, and click on the Options… button.

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

Step 6: Highlight the cells you want to merge, press the Ctrl + Q key combination. And you will get the result:

Note: It's advisable to avoid default Excel shortcuts to prevent confusion.

Best wishes for success!