Show Existing Names

H

hk29

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!
 
C

Chip Pearson

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
 
H

hk29

Thanks for your help!

Chip Pearson said:
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
Click to expand...
 
Top