Determine what a name refers to

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.