Create List of Names In a Workbook

Well, I finally finished creating all the names in my client’s Excel workbook, and sent the file back to them.
To help my client see what I’d done, I created a list of the names in the workbook, and sent it along with the main file. It was also a quick way for me to double-check the names and their formulas.

Create the List of Names

Here are the steps to create a list of names:

  • Insert a new worksheet, or select a cell in a blank area of an existing worksheet. On the Ribbon, click the Formulas tab.
  • In the Defined Names group, click Use in Formula

Excel Name Use in Formula

  • At the bottom of the list of names, click Paste Names (In Excel 2003, click Insert | Name | Paste)

Excel Name Paste Names

  • In the Paste Name dialog box, click Paste List.

Excel Name Paste Name
A 2-column list of names will be inserted, starting in the selected cell, so make sure you have room for your list.
Excel Name List

What’s in the List?

The list of names will contain all the workbook level names, unless there’s a duplicate sheet level name on the sheet where the name list is pasted. In that case, the sheet level name appears in the list, instead of the workbook level name.

Name Manager Add-In

I’ve mentioned Jan Karel Pieterse’s Name Manager before, as one of my favourite Excel add-ins. If you’re working with names, in any version of Excel, you should download and install it. It’s free, easy to install, and simple, but powerful, to use.
You can download Name Manager for Excel 2007 or earlier versions.
______________