1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

How to Create a Named Range in Excel

Use a Named Range in Excel Formulas, Functions, and Charts


Excel Named Range

Excel Named Range

© Ted French

How to Create a Named Range in Excel

Related Tutorial: Excel Range Name Overview

  1. Drag select the cell or range of cells to be named, such as B2 to B5

  2. Click in the Name box, to the left of the formula bar

  3. Type a name for the list, e.g. Jan_sales

  4. Press the Enter key on the keyboard

  5. The name appears in the Name box

Named Range Examples

A named range can be used when creating charts, and in formulas and functions such as:

= SUM( Jan_sales )

= Jan_total + Feb_total + Mar_total

Since a named range doesn't change when a formula is copied to other cells, it provides an alternative to using absolute cell references in functions and formulas.

Related Tutorial

See More About

©2014 About.com. All rights reserved.