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 Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. Chris runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Copilot, Google Calendar, and Outlook. To date, the channel has helped over 20 million viewers. Menard also does 2 to 3 public speaking events yearly, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at https://chrismenardtraining.com/linkedin or watch his videos on YouTube at https://chrismenardtraining.com/youtube.

Categories