Exceljet

Quick, clean, and to the point

Named range

Example of Named Range in Excel

A named range is one or more cells that have been given a name. Using named ranges can make formulas easier to read and understand. They also provide simple navigation via the Name Box.

In the example, the formula in F6 is:

=MAX(sales)

where "sales" is the named range C4:C10. Other examples of formulas that use this same named range are:

=MIN(sales)
=AVERAGE(sales)
=SUM(sales)

Note: named ranges are absolute references by default. 

Create a named range

To quickly create a named range:

  1. Select the range
  2. Type a name into the name box and hit return