When I click on a cell and if it is named then its name appears in the dropdown Name Box (just above the A1 cell).
But if I have a named range...
Name => "Example"
Refers To => Sheet1!$B$1:$B$4
when I click on say cell B3 then the dropdown Name Box shows B3.
How can I quickly see that it's part of the named range "Example"?
Bookmarks