Unlocking named ranges

J

JohnL

I am working with a spreadsheet created by a former employee. He used named
ranges a lot. I am trying to understand the worksheet. When I see an
equation in a cell like =Sum(Shipments) I feel I know what it means.
But how do I learn what the actual cell reference is ie = Sum(D2:G2).?

TIA
 
D

Duke Carey

Insert a new, empty worksheet into the workbook. Then you can use The
Insert-> Name-> Paste menu option and click on the Paste List button to get a
listing of all the names and the definitions
 
J

JohnL

Thanks Duke, works like a charm.

Duke Carey said:
Insert a new, empty worksheet into the workbook. Then you can use The
Insert-> Name-> Paste menu option and click on the Paste List button to get a
listing of all the names and the definitions
Click to expand...
 
D

Dave Peterson

If you work with names, do yourself a favor and get a copy of Jan Karel
Pieterse's (with Charles Williams and Matthew Henson) Name Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp
 
Top