Determine what a name refers to

Microsoft Office Excel 2003

previous page next page
  • On the Insert menu, point to Name, and then click Define.
  • 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 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.

    previous page start next page