Applies ToExcel for Microsoft 365 Excel 2024 Excel 2021 Excel 2019 Excel 2016

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.

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?

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.