how do i get the full name list in a workbook ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Voyager - 09 Feb 2007 07:48 GMT

In Excel 2003 I used to click Insert>Names>Define
and i could view and manage the full Name list.
How can I do it in Excel 2007 ?

Thanks.

Reply to this Message

Nick Hodge - 09 Feb 2007 08:31 GMT

Voyager

This has been 'improved' in 2007. The name tools are on the formulas tab,
defined name chunk.

You can get the old style dialog by clicking define name, but if you want
more control use the name manager

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
www.nickhodge.co.uk

> In Excel 2003 I used to click Insert>Names>Define
> and i could view and manage the full Name list.
> How can I do it in Excel 2007 ?
>
> Thanks.

Reply to this Message

Bob Phillips - 09 Feb 2007 10:37 GMT

You reckon?

You can always use Ctrl-F3 to get there, in 2003 and 2007, but I would use
Jan Karel Pieterse's NameManger utility, a utility designed to improve
working with defined names.
It is a free add-in, and you can get it at
http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp

Signature

HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Voyager
>
[quoted text clipped - 9 lines]
> >
> > Thanks.

Reply to this Message