I have created a worksheet in which I have defined names for a lot of the cells. Until recently, the names would always appear in the Name Box instead of the location. I have no idea why, but most are no longer displaying, though working. I find it quite helpful to have them display and was wondering if something had changed to cause this problem. Is there a way to restore it the way it was?
Name box contains “B4” instead of the defined name, “mCovWid”
Manage Names shows