How to define, use and delete names in Excel formulas

Defining and using names in formulas in Excel can make it easier for you to understand the data. In addition, it is also a more efficient way to manage the various processes you create in your spreadsheets. So, in the next post, we'll help you define and use names in Excel Formulas.

Define and use names in Excel formulas

You can define a name for a range of cells, a function, a constant, or a table. Once familiar with the technique, you can easily update, audit or manage these names. For this, you must first:

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

This approach is useful if you want to reference it in a formula or other spreadsheet.

1) Name a cell

Let's say we want to create a report on tax rates for different states.

Start Excel and open a blank sheet.

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

Then, 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 that the cell has been named, you can use it as a reference in the formula.

For example, select a cell, put the "=" sign and the name you gave to the cell, and press enter. You will notice that the cell data would be there, replacing the name.

2) Use the name in formulas

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

To do this, select the cells of the table that you want to name.

Then go toFormula"In the ribbon bar and choose"Create from selection'Option.

In the & #39;Create from selectionIn the 'dialog box, choose the locations of the labels in the selected table and click on the & #39;D & #39; agreement& #39; button.

Naming a range makes it easy to reference cells even on another worksheet.

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

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

How to delete names defined in Excel

To delete names in Excel:

1. Open the Formulas tab in the Defined names group
2. Select the name manager
3. Then click on the name you want to delete
4. Click Delete> OK.

That's it!