Displaying All Named Ranges

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

Insert>Name>Paste

--
Kind regards,

Niek Otten

"Henry Stockbridge" <hstockbridge5@hotmail.com> wrote in message
news:1136906364.622113.315820@z14g2000cwz.googlegroups.com...
> 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
>

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" <hstockbridge5@hotmail.com> wrote in message
news:1136906364.622113.315820@z14g2000cwz.googlegroups.com...
> 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
>

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" <hstockbridge5@hotmail.com> wrote in message
news:1136906364.622113.315820@z14g2000cwz.googlegroups.com...
> 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
>

Works like a charm. Thanks.