How to change the names of Excel cells

If you have ever worked with Excel you know that it is organized in the form of a table of cells.

These cells are referenced using their coordinates. The columns are letters and the rows are numbers, so the cells have coordinates of type A1, B5, D57, etc.

This nomenclature is very simple to learn but difficult to remember. What did cell C34 contain? What did the contents of cell A33 refer to? Applying formulas of the SUMA type (A1: A5) also makes it difficult to know why you are doing this addition.

In this simple Excel tutorial, we will show you how to change the names of Excel cells. Instead of being called A3 or B6 you can call them Salary or Expenses of the month, and it will be easier for you to remember what they contain, or apply formulas.

Start Excel and open any document to which you want to change the name of the cells. You can also do this on a blank page. This method works with any version of Excel, except the free version of Excel Online.

Click on a cell and you will see its name in the upper left corner of the screen, to the left of the formula bar. By default, the name will be the coordinates of the cell (its column and its row). If it is in column A and row 2, it will be cell A2.

To change the name of the Excel cell, simply click on the current name and type in the new name. For example Rent. Press Enter / Enter / Enter to make the change:

From this point on, every time you click on the cell, you will see its name in the corner. And you can use it in formulas or in any reference. This way it will be easier to remember what formulas of the type Rent + Food = Expenses were used for.

Leave a Reply

Your email address will not be published.