Excel table Merge cell shortcut key settings method

As you all know, in the use of Excel tables, you often need to use this feature of "merged cells." When you need to manipulate the "merge cells" feature, you need to move the hand to the mouse to choose, very time-consuming. If you have the "Merged cells" feature shortcut keys are much more convenient! Today, Xiao-bian will introduce you to the Excel table table merge cell shortcut key setting method. Hurry up and learn!

One, Excel table merge cell shortcut keys simple usage:

1, first merge the cell, and then merge the keys of the cell handy car: ALT + ENTER.

2 This method is suitable for short term use of the shortcut keys of merged cells, if you need to use them frequently, please see the tutorial below.

Second, Excel table merge cell shortcut key complex usage:

1. Open the Excel table and click the Custom Quick Access Toolbar in the upper-left corner of the Excel table. After clicking, select another command

2, "Select commands from the following location", select the Start tab here. Then find "Center after merge", then click the "Add" button, add to the right, click Save.

3, after the Save, Excel table in the upper left corner of the quick access to the column has the option to merge cells, as shown in the following figure.

4, press ALT will be able to see the Quick Access Toolbar cable corresponding to the number. As shown in the following figure, the corresponding number for the small-combined cell is 4. Then my Excel table merge cell shortcut keys is alt+4. If you are 6, then the shortcut key for your merged cell is alt+6. Note that the number here is the row of digits above the letter. If the number on the right side of the keyboard is not available.