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.
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.
Insert a range in a formula
- Start typing your formula as necessary.
- With the cursor still in the formula cell, click Formulas > Use in Formula > Paste Names.
- In the Paste Name list, select a named range that you want to insert into your formula.
- Optionally, repeat step 2 and 3 to add as many ranges as necessary.