Chat with us, powered by LiveChat

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.

How to Insert a Range Name in Excel

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.
Share with your followers...
Share on Facebook
Facebook
Tweet about this on Twitter
Twitter
Share on LinkedIn
Linkedin

Post Author: David K. Kandie

ga('send', 'pageview');