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
- At the bottom of the list of names, click Paste Names (In Excel 2003, click Insert | Name | Paste)
- In the Paste Name dialog box, click Paste List.
A 2-column list of names will be inserted, starting in the selected cell, so make sure you have room for your 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.
______________
Good stuff Debra.
Might be useful to mention (inserting shameless plug here…) Charles Williams’ and my Name Manager:
http://www.jkp-ads.com/officemarketplacenm-en.asp
Mrs D, when are you going to step into the 21st century and start using the Real NameManager?
Bob,
Sometimes add-ins just take all the fun out of Excel. 😉
@Jason, Good to see you are still around! You are right but sometimes we have to resist geeking out (again), and get productive 🙂
Okay, Jan Karel and Bob, you’re right! I’ve added a link to the fabulous (and real) Name Manager. And I’ve finally installed the Excel 2007 version on this machine, even if Jason’s right, and it does take all the fun out of Excel 😉
… and for the gazillions out there still using Excel 2003, the steps are
Insert – Name – Paste – Paste list