Everyone knows that when using Excel tables, we often need to use the "merge cells" function. When you need to operate the "Merge Cells" function, you need to move your hand to the mouse to make a selection, which is very time-consuming. It would be much more convenient if there was a shortcut key for the "Merge Cells" function! Let’s find out with the editor of Huajun.

1. Simple usage of shortcut keys for merging cells in Excel tables:

1. Merge cells once first, and then the shortcut key for merging cells is available: Alt+Enter.

How to set shortcut keys for merging cells in Excel tables

2 This method is suitable for short-term use of the shortcut key function of merging cells. If you need to use it frequently, please see the tutorial below.

2. Complex usage of shortcut keys for merging cells in Excel tables:

1. Open the Excel table, and then click the custom quick access toolbar in the upper left corner of the Excel table. After clicking, select other commands

How to set shortcut keys for merging cells in Excel tables

2. "Choose a command from", here select the Home tab. Then find "Merge and Center" and click the "Add" button. After adding it to the right, click Save.

How to set shortcut keys for merging cells in Excel tables