TechAdvisory.org

Technology Advice for Small Businesses

Identify Excel cells easily by name

Office365_Mar24_CMicrosoft Office is a collection of desktop applications from Microsoft, designed for Windows and Mac computers. In 2011, Office 365, which is a cloud-based version of the suite, was introduced. This allows users to access these applications on the Web, including Excel. Microsoft Excel contains spreadsheets which are often used in creating and managing databases, finances, and more. Did you know that the rows and columns of cells can be renamed for easy identification?

Like other spreadsheet applications, Microsoft Excel documents are based on cells that can be arranged into rows and columns. It is within these cells that data is entered when creating a worksheet for various functions including data management and computations, etc. Each cell in the spreadsheet has a corresponding name, which is identified by its column letter and row number.

For instance, the cell under column A that belongs to row 1 has the default name A1. You will see this in the name box, which is located on the upper left side of the spreadsheet, next to the formula bar. This name can actually be changed however.

Why name cells in Excel

As mentioned, the default name for each cell in an Excel spreadsheet is based on the relevant column and row. One of the reasons why you may want to change this name is to make it easier to find what you are looking for, especially when there’s a lot of information in a particular spreadsheet. For instance, if you name a particular cell ‘Total’, searching for this word is much faster than scrolling through the spreadsheet to find the correct cell or trying to remember its specific column and row.

This is also the case when creating formulas for computations. Instead of using the cells’ column letter and row number, it’s more convenient to use a name that you can easily understand. For example, naming one cell ‘GrossIncome’ and the other one ‘Deductions’ makes it easier for you to compute net income by subtracting Deductions from GrossIncome for the result.

Another benefit of naming cells is that it is easier for other users to understand. If you are sharing the spreadsheet or workbook with other colleagues or business associates, using cell names that are easy for everyone to identify reduces potential confusion.

How to name cells in Excel

Naming cells in Excel can be done in two ways. The first is by changing the name directly on the name box and the other one is by defining names under the Formulas menu. The difference is that when naming a cell through the define name feature of the menu you can select its specific scope.

This determines where the specific name will be recognized as having the same value, such as in the entire workbook or in a specific spreadsheet only. Changing the name in the name box will automatically determine the workbook as its scope rather than the whole spreadsheet.

Changing a cell name in the name box:

  1. Select the cell that you want to name.
  2. Go to the name box and type the name you prefer.
  3. Hit enter on your keyboard.

Defining a cell name:

  1. Select the cell that you wish to name.
  2. Click the Formulas menu.
  3. Choose Define Name.
  4. Type the name of the cell in the new window that pops up.
  5. Select the Scope.
  6. Click OK.

Remember that a cell name should not contain any spaces. The uppercase and lowercase letters R and C are also not available as cell names, since they represent column and row. Furthermore, aside from letters, the first character of a cell name can also be a backslash or an underscore. The rest can be a combination of letters, underscores, periods and numbers, which can be up to 255 characters.

If you have further questions about changing the cell name in Excel, please don’t hesitate to give us a call.