Two ways to rename each cell in an Excel table

Each cell in an Excel table has a default name, named after the column and banner, for example, A1 represents the first column, the first row of cells. If you want to rename a cell, you can use the following two methods.

Tools/raw Materials

Microsoft Office

WPS Office

Method One

1, open the Excel table. Double-click the left mouse button or right-click to select Open option.

2, select the cell you want to rename. Move the mouse cursor to the left click of the cell you want to select.

3, click the right mouse button in the selected range of cells, pop-up shortcut menu.

4, select the "Define name" option on the shortcut menu.

5, in the pop-up dialog box to find the name of the existing name of the column and select.

6, enter a new name to be named, and then select the OK option to determine. When you name 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, cannot be the same as cell references, and the cell default name cannot appear. For example: A19,m89 and the like.

7. Save the Excel table after renaming the cell. You can select the Save option icon for the floppy disk in the upper-left corner of the Excel table or hold down CTRL and s while holding it.

Method Two

1, open the Excel table. Double-click the left mouse button or right-click to select Open option.

2, select the cell you want to rename. Move the mouse cursor to the left click of the cell you want to select.

3. In the upper-left corner of the worksheet, locate the name box that displays the current cell name.

4, with the mouse to select the Name box. Click the left mouse button at the Name box position.

5, enter a new name to be named. When you name 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, cannot be the same as cell references, and the cell default name cannot appear. For example: A19,m89 and the like.

6. Save the Excel table after renaming the cell. You can select the Save option icon for the floppy disk in the upper-left corner of the Excel table or hold down CTRL and s while holding it.

　Attention matters

Method Two some versions do not apply, please choose the best method by yourself.

The small series is illustrated with Microsoft Office 2010 as the Office software.

WPS Office is set up in a similar way to Microsoft Office to simulate operations.

These are the two ways to rename each cell in the Excel table, and hopefully it will help!