Displaying All Named Ranges

H

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
 
B

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
 
Top