Excel table Merge cell shortcut key settings method

Source: Internet
Author: User

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.