Unlocking named ranges
 

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

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

"JohnL" wrote:

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

Thanks Duke, works like a charm.

"Duke Carey" wrote:

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

"JohnL" wrote:

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

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

JohnL wrote:

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

--

Dave Peterson