Displaying All Named Ranges

's Computer Specifications

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

's Computer Specifications

Insert>Name>Paste

--
Kind regards,

Niek Otten

"Henry Stockbridge" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

's Computer Specifications

Works like a charm. Thanks.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Named ranges and pasting formulas with named references	Dude3966	Microsoft Excel Programming	2	8th Oct 2008 04:15 PM
Named ranges scope / workbook/worksheet level named ranges- changeswith variable use...	christian_spaceman	Microsoft Excel Programming	3	24th Dec 2007 01:15 PM
Displaying all Named Ranges in workbook	=?Utf-8?B?QmFyYiBSZWluaGFyZHQ=?=	Microsoft Excel Programming	4	21st Aug 2006 06:03 PM
Copy data in named ranges to a newer version of the same template to identical ranges	handstand	Microsoft Excel Programming	0	21st Aug 2006 03:51 PM
Like 123, allow named ranges, and print named ranges	=?Utf-8?B?V1A=?=	Microsoft Excel Misc	1	8th Apr 2005 06:07 PM