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...
Email this to someone
email
Share on Facebook
Facebook
Tweet about this on Twitter
Twitter
Share on LinkedIn
Linkedin

Post Author: David K. Kandie