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