Forum Discussion
Is there a formula / function for displaying the "Name" of a reference cell?
I am trying to see if there is an Excel function to display the "Name" of another cell. I looked through all of the options using the =CELL() function (there are many) but none seem to return the "N...
Not exactly what you ask but perhaps acceptable anyhow. Press F3 to display a window with all named ranges/cells in your sheet. Then press "Paste List". This will create a list with all names and their cell addresses. Not dynamic but it may work when you don't change the named ranges very often.