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.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

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: and provide relevant evidence. A staff member will contact you within 5 working days.