Determine what a name refers to

  1. On the Insert menu, point to Name, and then click Define.
  2. In the Names in workbook list, click the name whose reference you want to check.

The Refers to box displays the reference, formula, or constant (constant: A value that is not calculated and, therefore, does not change. For example, the number 210, and the text "Quarterly Earnings" are constants. An expression, or a value resulting from an expression, is not a constant.) the name represents.

ShowTip

You can also create a list of the available names in a workbook. Locate an area with two empty columns on the worksheet (the list will contain two columns — one for the name and one for a description of the name). Select a cell that will be the upper-left corner of the list. On the Insert menu, point to Name, and then click Paste. In the Paste Name dialog box, click Paste List.

 
 
Applies to:
Excel 2003