How to define, use and delete names in Excel formulas

Defining and using names in Formulas in Excel can make it easier for you and to understand data. Besides, it also serves as a more efficient way to manage the various processes that you create in your worksheets. So, in the following post, we will help you to define and use names in Excel formulas.

Define & use names in Excel formulas

You can define a name for a cell range, function, constant, or table and once you become familiar with the technique, you can easily update, audit or manage these names. For this, you’ll first need to:

  1. Name a cell
  2. Use Create from selection option

The approach is useful if you want to reference it in a formula or another worksheet.

1] Name a cell

Let us say that we want to create a report of tax rates for different states.

Launch Excel and open a blank sheet.

Name the table as shown in the image and enter the values corresponding to the names.

Excel Formulas

Next, to define a name for a cell select it. Then, select the name box (adjacent to the left side of the formula bar), type a name and press Enter.

Now the cell has been named you can use it as a reference in the formula.

For instance, select a cell, put ‘=’ sign and the name you gave to the cell and press enter. You will notice that the data from the cell would appear there, replacing the name.

2] Use Name in formulas

You can also let Excel name a range or table cells for you.

For this, select the cells in the table you want to name.

Next, go to the ‘Formula’ tab on the ribbon bar and choose ‘Create from selection’ option.

In the ‘Create from selection’ dialog box, choose the locations of any labels that are in the selected table and hit the ‘OK’ button.

Naming a range makes it easier to reference cells even on a different worksheet.

How to define, use and delete names in Excel formulas

Wherever you are in your workbook, select a cell, type ‘=’ followed by any formula you would like to use followed by the name you defined for the cells.

That’s it, you should see the results displayed in the cell.

How to delete defined names in Excel

To delete Names in Excel:

  1. Open Formulas tab, in the Defined Names group
  2. Select Name Manager
  3. Next, click the name you want to delete
  4. Click Delete > OK.

That’s it!

Posted by on , in Category Office with Tags
The author Hemant Saxena is a post-graduate in bio-technology and has an immense interest in following Windows, Office and other technology developments. Quiet by nature, he is an avid Lacrosse player. Creating a System Restore Point first before installing a new software, and being careful about any third-party offers while installing freeware is recommended.