Thread: Namebox hidden by Functionlist

At the left of the formula-bar we have the namebox.
I have created names for different array's.
From the arrow at the namebox I can show the list of names.
When I am using the Function wizard I have to put an array-name.
I forgot the names, and I want to review the name-list by clicking on the
arrow of the namebox.
However now the wizard has put the function in exactly the same place as the
namebox.
Is there a way to move the function-list so I can get at the namebox?

Richard

Press the F3 key -- will bring up a list of the define names to paste in.
Bob Umlas
Excel MVP

"Richard" <rickie_gibson@hotmail.com> wrote in message
news:536e8$434ed050$5038022a$14622@news.chello.nl...
> At the left of the formula-bar we have the namebox.
> I have created names for different array's.
> From the arrow at the namebox I can show the list of names.
> When I am using the Function wizard I have to put an array-name.
> I forgot the names, and I want to review the name-list by clicking on the
> arrow of the namebox.
> However now the wizard has put the function in exactly the same place as
> the namebox.
> Is there a way to move the function-list so I can get at the namebox?
>
> Richard
>

Thank you Bob,
This makes life a lot easier.

Richard

"Bob Umlas" <Excel_Trickster@msn.com> wrote in message
news:uEb0zBG0FHA.464@TK2MSFTNGP15.phx.gbl...
> Press the F3 key -- will bring up a list of the define names to paste in.
> Bob Umlas
> Excel MVP
>
> "Richard" <rickie_gibson@hotmail.com> wrote in message
> news:536e8$434ed050$5038022a$14622@news.chello.nl...
>> At the left of the formula-bar we have the namebox.
>> I have created names for different array's.
>> From the arrow at the namebox I can show the list of names.
>> When I am using the Function wizard I have to put an array-name.
>> I forgot the names, and I want to review the name-list by clicking on the
>> arrow of the namebox.
>> However now the wizard has put the function in exactly the same place as
>> the namebox.
>> Is there a way to move the function-list so I can get at the namebox?
>>
>> Richard
>>
>
>