Five examples of using named ranges in Excel

Posted on:  07/08/2017
Five examples of using named ranges in Excel

You can create a named range that refers to a single cell in Excel. You can also select a group of cells on the worksheet and make it a named range. After you define Excel names, you can use the names in a formula, instead of using a constant value or cell references.

For example, a cell that contains the revenue for each state could be named Revenue or Rev. Then you could use functions and reference the named range. Example: =Sum(Revenue) or =Average(Revenue).

YouTube Video of using Named Ranges by Chris Menard

Shown in the video below:

  1. A single cell named range.
  2. Using a named range in a formula.
  3. Creating named ranges from a selection.
  4. Applying named ranges.
  5. Using named ranges in a data validation.

You can create a named range quickly

  1. Select the cell(s) to be named.
  2. Click in the Name box, to the left of the formula bar.
  3. Type a valid one-word name for the list, e.g. Revenue.
  4. Press the Enter key.
Chris Menard

Chris Menard is a Microsoft Certified Trainer (MCT) and is employed full-time as a Trainer for BakerHostetler, one of the nation’s largest law firms. Menard has a YouTube channel with over 900 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 15 million viewers have appreciated. Menard also does public speaking at conferences for CPAs and Administrative Professionals. Connect with Chris on LinkedIn at or on YouTube at