Excel Named Range

Cell references can be confusing, especially when you're working with formulas. However, cell and range names can help. You can define a name for a cell, cell range, non-adjacent cells, formula, constant, or table.

For example, you could name the cell range B16:H16 “Total Sales.” Then, instead of totaling sales with the formula =SUM(B16:H16), you could use the defined name to create the more readable formula, =SUM(TotalSales).

Create a Name

  1. Select the cell(s) you want to name.
  2. Click the Name box in the Formula bar.
  3. Type the name you want for the cell or range.
    Cell and Range Names

    A cell or range name cannot include spaces. Use a period or underscore instead.

  4. Press Enter.

Now, when you create a formula, use the name to reference the cell(s) instead.

Use a Cell or Range Name in a Formula

  1. Click the cell where you want to add the formula.
  2. Type = followed by the formula you want to use.
  3. When you want to use a name, just type it.
  4. Click Enter when you’re finished.
    Cell and Range Names

    You can also click the Formulas tab on the Ribbon, click the Use in Formula button, and select a name from the list.

Go to a Name

Cell and range names also make it easier to navigate a workbook. You can select a range name to jump to it in the workbook.

  1. Click the Name box list arrow.

    A list of all the named ranges in the workbook appears.

  2. Select the name you want to go to.
    Cell and Range Names

Excel takes you to your named cell or cell range.

Edit and Delete Cell or Range Names

When you need to change or remove a named range, use the Name Manager.

  1. Click the Formulas tab.
  2. Click the Name Manager button.
    Cell and Range Names
  3. Select the name you want to edit or delete.
  4. Click Edit or Delete.
    • Use Edit to change the name or update which cell or range the name refers to.
    • Use Delete if you no longer need the named cell or range.
  5. Click Close when you’re finished.
    Cell and Range Names

FREE Quick Reference

Click to Download

Free to distribute with our compliments; we hope you will consider our paid training.