Displaying All Named Ranges

[Henry Stockbridge]

Hi,

I once saw all named ranges displayed on the screen, but I cannot
remember how to do this. I think it has something to do with zooming
the display <40.

Any help you can lend with this would be apprecieated.

Henry

 

[Niek Otten]

Insert>Name>Paste

 

[Bernie Deitrick]

Henry,

You're exactly right: zoom to less than 40% and the named ranges will be highlighted with borders
and names shown.

HTH,
Bernie
MS Excel MVP

 

[Henry Stockbridge]

Works like a charm. Thanks.