Microsoft Excel 2007 with Example

2 Formulas and Functions

2.3 Names in Formulas

Named Range    |   Named Constant    |   Name Manager

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

Named Range

To create a named range, execute the following steps.

1. Select the range A1:A4.

2. On the Formulas tab, click Define Name.

Click 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.

Quickly Define Name

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

Use this Named Range in Your Formulas

Named Constant

To create a named constant, execute the following steps.

1. On the Formulas tab, click Define Name.

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

New Named onstant

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

Use this Named Constant in Your Formulas

Note: if the tax rate changes, use the Name Manager to edit the name and Excel automatically updates all the formulas that use TaxRate.

Name Manager

To edit and delete defined names, execute the following steps.

1. On the Formulas tab, click Name Manager.

Click Name Manager

2. For example, select TaxRate and click Edit.

Edit Name