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: 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.
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.
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: That’s it!
