Switching Between Viewing Names and Formulas

[JONTIMMIS]

Hi All.

I am a big advocate of the use of the name manager to name cells, ranges etc as it can often help understand what you are trying to achieve however a number of spreadsheets I use have upwards of 300+ names in then and it get annoying to having to go to the Name Manager to check if the name refer to the correct cell/range etc.

Is there any way of switching between the Name view and the formula view like you would using the Toggle Field Codes function on Word?

Cheers,

Jon

 

[Andrew Poulsom]

Welcome to MrExcel.

No, sorry.

 

[Adora]

Hello Jontimmis,

you can view the define name as a water mark filed into the cells when zooming the worksheet in 30% or less,
try it, hope if this way find you well

Thanks a lot,