How to show Overall 'Plan' View of Named Ranges

[PurrSent]

Using MS Excel 2010 on Windows 10

I seem to remember seeing an overall view of Named Ranges, in a diagramatic form, for instance, seeing your spreadsheet but with areas outlined, and in different colours, defining the Ranges, with the name of the Range associated with it.

I had understood/read that to achieve this, you merely zoomed out to less that 40% and this was displayed but, on trying this, it doesn't work, neither can I find any reference to it on searching the internet.

Does anyone know if this is possible and, if so, how to get this view, please?

Many thanks. I appreciate any help

 

[footoo]

https://stackoverflow.com/questions/33143668/how-to-display-the-names-over-named-ranges-in-excel

 

[PurrSent]

Many thanks Footoo

I think that was where I originally saw the possibility of seeing the Named Ranges identified visually. Unfortunately, using this method, ie zoom to less than 40%, I don't get the Ranges displayed as a 'watermark' as the original poster of that thread suggested.

I'm wondering if there is any other way of doing this???

Thanks very much