Named Range

 

Create a named range or a named constant and use these names in your Excel formulas. This way you can make your formulas easier to understand.

To create a named range, execute the following steps.

1. Select the range A1:A4.

Select Range

2. On the Formulas tab, in the Defined Names group, click Define Name.

Define Name

3. Enter a name and click OK.

New Named Range

There's an even quicker way of doing this.

4. Select the range, type the name in the Name box and press Enter.

Name Box

5. Now you can use this named range in your formulas. For example, sum Prices.

Named Range in Excel

To create a named constant, execute the following steps.

6. On the Formulas tab, in the Defined Names group, click Define Name.

Define Name

7. Enter a name, type a value, and click OK.

New Named onstant

8. Now you can use this named constant in your formulas.

Named Constant in Excel

If the tax rate changes, use the Name Manager to edit the value and Excel automatically updates all the formulas that use TaxRate.

9. On the Formulas tab, in the Defined Names group, click Name Manager.

Click Name Manager

10. Select TaxRate and click Edit.

Edit Value

Note: you can use the Name Manager to view, create, edit and delete named ranges.