Apply named ranges to an existing formula

You can insert a named range into an existing formula. This is particularly helpful when you want to replace cell references with named ranges to make formulas easier to manage, and look more user-friendly. For instance, in the following example you could have a named range for TaxRate set at 10%, and use =D2*TaxRate to calculate total tax due on a purchase.

An example of a named range being applied

Note: The procedure outlined in Insert a named range into a formula is for inserting a named range when building a new formula. This topic talks about inserting a range (or applying a named range) into an existing formula.

  1. Select the cell that contains the formula

  2. Go to Formulas > Define Name > Apply Names.

  3. In the Apply Names dialog box, select the named range(s) you want to insert.

    Important: Make sure that the named range (you are applying) refers to a single cell only.

  4. Click OK.

See Also

Define and use names in formulas

Create a named range in Excel

Insert a named range into a formula in Excel

Use the Name Manager in Excel

Why am I seeing the Name Conflict dialog box in Excel?

Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×