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:


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


Note: named ranges are absolute references by default. 

How to 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

Video: How to create a named range.

More detailed information: Named ranges in Excel.