List of defined names

[coa01gsb]

Hi All,

Is there a way to get a list of the names, that one has defined in a worksheet, whilst entering a formula into a cell or a graph?

If not is it something other people would find useful?

[Duke Carey]

When you're ready to insert the range name, press the F3 function key

"coa01gsb" wrote:

>
> Hi All,
>
> Is there a way to get a list of the names, that one has defined in a
> worksheet, whilst entering a formula into a cell or a graph?
>
> If not is it something other people would find useful?
>
>
> --
> coa01gsb
> ------------------------------------------------------------------------
> coa01gsb's Profile: http://www.excelforum.com/member.php...o&userid=31214
> View this thread: http://www.excelforum.com/showthread...hreadid=524826
>
>

[Niek Otten]

Not easily with a formula.
On an empty sheet, choose Insert>Name>Paste>Paste List

--
Kind regards,

Niek Otten

"coa01gsb" <[email protected]> wrote in message
news:[email protected]...
>
> Hi All,
>
> Is there a way to get a list of the names, that one has defined in a
> worksheet, whilst entering a formula into a cell or a graph?
>
> If not is it something other people would find useful?
>
>
> --
> coa01gsb
> ------------------------------------------------------------------------
> coa01gsb's Profile: http://www.excelforum.com/member.php...o&userid=31214
> View this thread: http://www.excelforum.com/showthread...hreadid=524826
>

[Niek Otten]

You obviously understood the OP's question better than I did!

--
Kind regards,

Niek Otten

"Duke Carey" <[email protected]> wrote in message news:[email protected]...
> When you're ready to insert the range name, press the F3 function key
>
> "coa01gsb" wrote:
>
>>
>> Hi All,
>>
>> Is there a way to get a list of the names, that one has defined in a
>> worksheet, whilst entering a formula into a cell or a graph?
>>
>> If not is it something other people would find useful?
>>
>>
>> --
>> coa01gsb
>> ------------------------------------------------------------------------
>> coa01gsb's Profile: http://www.excelforum.com/member.php...o&userid=31214
>> View this thread: http://www.excelforum.com/showthread...hreadid=524826
>>
>>

[coa01gsb]

Thanks,

That F3 bit is going to save me a load of hassle with functions, shame it doesn't work for graphs