Strictly speaking, no. But you could write some code which will enable to
enter a function in a cell and have that do what you want. Create a macro
module in personal.xls and copy the following into it:

Public Function ShowName(number)
ShowName = Names(number).Name
End Function

Public Function ShowNameRef(number)
ShowNameRef = Names(number).RefersTo
End Function

Now enter into cell A1:
   =ShowName(1)
and you will see the first name in use in that workbook.

Now enter into cell B1:
   =ShowNameRef(1)
and you will see the reference pointed to by the first name in use in that
workbook.

If you copy the formulas down for as many names as you have and change the
number in brackets, you will end up with a sheet containing all the names.
Alternatively, use:

=ShowName(Row(A1))    ; and
=ShowNameRef(Row(A1))

and you can just copy this formula down as far as necessary.

Bear in mind that, since you're using custom functions, this will only work
on your machine.

Paul C,