How to rename a cell and delete a cell name

Source: Internet
Author: User
Tags naming convention

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. Sometimes it's easy to remember or to make it easy. We'd like to name the cell as our own. Yes, of course, if you want to rename a excel2003 cell, you can do the following:

One, cell renaming

Select the cell you want to name, click insert → name → define command in the menu bar

When you display the Define Name dialog box, enter a name in the name in the current workbook box, click the Add button, and then click OK, and then rename the selected cell to total score.

Second, delete Excel cell naming

If we want to delete a previous Excel cell name, simply open the Define Name window in the previous way, select the previous cell name, the Delete button to the right of the point, and then click the Close button so that the previous cell name is deleted. This allows the name of the original cell to be renamed in alphanumeric terms.

Note: When naming a cell, note that the first character of the name must be a letter or kanji, it can contain up to 255 characters, can contain large and 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.