• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Naming Cells and Ranges

To make working with ranges easier, Excel allows you to name them. The name BookTitle, for example, is easier to remember than the range reference B6:B21. Named ranges can be used to navigate large worksheets. Named ranges can also be used in formulas instead of typing or pointing to specific cells. If the cell or range you want to name has labels, you can have Excel automatically name the cell or range for you. If you have already entered a cell or range address in a formula or function, you can apply a name to the address instead of re-creating it.

Name a Cell or Range

Select the cell or range you want to name.

Click the Name box on the formula bar.

Type a name for the range. A range name can include uppercase or lowercase letters, numbers, and punctuation, but no spaces. Try to use a simple name that reflects the type of information in the range, such as BookTitle.

Press Enter. The range name will appear in the Name box whenever you select the range.

Select a Named Cell or Range

Click the Name box list arrow on the formula bar.

Click the name of the cell or range you want to use.

The range name appears in the Name box, and all cells included in the range are highlighted on the worksheet.

Let Excel Name a Cell or Range

Select the cells, including the column or row header, you want to name.

Click the Insert menu, point to Name, and then click Create.

Select the check box with the position of the labels in relation to the cells.

Excel automatically tries to determine the position of the labels, so you might not have to change any options.

Click OK.

Apply a Name to a Cell or Range Address

Select the cells in which you want to apply a name.

Click the Insert menu, point to Name, and then click Apply.

Click the names you want to apply.

Click OK.

Did You Know?

Should I select the Use Row And Column Names option? When you select this option, Excel uses the range row and column headings to refer to the range you've selected (if a cell does not have its own name but is part of a named range).

You can delete a name range. Click the Insert menu, point to Name, click Define, select the range name, and then click Delete.


  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint