Show Existing Names
 

I have just inherited a spreadsheet with lots of names in it. Is there a way
to print out the names and the corresponding formulas instead of having to go
to Names-Define and looking at each one individually.

thanks!

Go to the Insert menu, choose Name, then Paste. Click the Paste
List button. It will create a list of names and values in the
active cell.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"hk29" wrote in message
...
I have just inherited a spreadsheet with lots of names in it.
Is there a way
to print out the names and the corresponding formulas instead
of having to go
to Names-Define and looking at each one individually.

thanks!

Thanks for your help!

"Chip Pearson" wrote:

Go to the Insert menu, choose Name, then Paste. Click the Paste
List button. It will create a list of names and values in the
active cell.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"hk29" wrote in message
...
I have just inherited a spreadsheet with lots of names in it.
Is there a way
to print out the names and the corresponding formulas instead
of having to go
to Names-Define and looking at each one individually.

thanks!