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:


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. 

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