J-Walk Name Lister

Excel page

Excel files

Description:

The Name Lister add-in displays a list of all names in a workbook. In addition, you can display names that fall into any of the following categories:

• Workbook level names
• Sheet level names -- names that are defined only for a specific worksheet
• Hidden names -- these names are normally not accessible
• Linked name -- names that refer to other workbooks
• Bad names -- invalid names that should be deleted. These names are often the cause of "phantom links."

The utility also lets you:

• Delete names
• Activate name ranges interactively without closing the Name Lister dialog box.

NOTE: This add-in requires Excel 97, and it will not work with Excel 5 or Excel 95. This add-in is fully functional, not crippled, not password-protected, and has no nag messages. It is absolutely free, with no strings attached.

• Download the Name Lister add-in (69K)
• A significantly enhanced version of this utility is available in Power Utility Pak.
  

Installation:

1. Download the J-Walk Name Lister add-in (it's a self-extracting EXE file).
2. Extract the XLA add-in file by double-clicking the NAMELIST.EXE file.
3. Start Excel and select the Tools - Add-Ins command. Don't even try using it with previous versions of Excel.
4. In the Add-Ins dialog box, click the Browse button and locate namelist.xla (the file you extracted in Step #2).
5. Click OK
6. Select the cell that you want to format.
7. Select Tools - J-Walk Name Lister from the menu.