Insert a named range into a formula in Excel

You can quickly insert a named range to a formula that you are building in your Excel spreadsheet. What are named ranges?

Using named ranges in formulas makes it easier to build and maintain formulas. Using a named range in a formula also makes the formula look more user-friendly.

An example of a SUM function with a named range An example of a SUM forrmula

An example of a SUM formula

An example of a SUM formula with a named range

Insert a range in a formula

  1. Start typing your formula as necessary.

  2. With the cursor still in the formula cell, click Formulas > Use in Formula > Paste Names.

  3. In the Paste Name list, select a named range that you want to insert into your formula.

  4. Optionally, repeat step 2 and 3 to add as many ranges as necessary.

    Note: Updating a range itself will not automatically update the reference to the range in the formula. You will have to manually re-insert the named range in the formula.

Paste the range list in the spreadsheet

You can get a list of all named ranges that the current sheet or workbook uses, and paste them as a list in your sheet. This is particularly useful when you need to quickly see the list of ranges along with the data reference associated to your current spreadsheet.

  1. Select a cell or a blank range where you want to paste the range details in the worksheet.

  2. Click Formulas > Use in Formula > Paste Names.

  3. In the Paste Name dialog box, click Paste List.

  4. Click OK.

    You will now see two columns in the spreadsheet—range names and the cell references that each range holds.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

See Also

Define and use names in formulas

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.

×