Excel lets you assign a name to a single cell or range of cells. Using meaningful names makes it easier when referencing cells. For example, in Excel 2002, you can assign a name to represent a range of cells in a column using the steps described below:

  1. Within Excel, select a range of cells within a column. 
  2. Click the Insert menu, point to Name, and click Define.
  3. Type in the name you want to assign to the range of cells.
  4. Click the Add button.
  5. Click OK.

When you select the range of cells, the name you typed in for step three will appear in the Name Box.