How Excel renames a cell

Source: Internet
Author: User

Excel has a default name for each cell, and its naming convention is the column label plus banner, for example, D3 represents the fourth and third rows of cells. If you want to rename a cell, you can use the following two methods:

Method One:

Just click a cell with the mouse, you will see its current name in the upper-left corner of the table, and then use the mouse to select the name, you can enter a new name.

Method Two:

Select the cell you want to name, click the insert → name → definition command, display the Define Name dialog box, enter a name in the name in the current workbook box, and click OK.

Attention:

When you name a cell, be aware that the first character of the name must be a letter or Chinese character, it can contain up to 255 characters, can contain large, lowercase characters, but the name cannot have spaces and cannot be the same as cell references.

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.