How Excel renames a cell

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. 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.


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.

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.