ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Namebox hidden by Functionlist (https://www.excelbanter.com/new-users-excel/50331-namebox-hidden-functionlist.html)

Richard

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



Bob Umlas

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

"Richard" wrote in message
. ..
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




Ricky Gibson

Thank you Bob,
This makes life a lot easier.

Richard

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

"Richard" wrote in message
. ..
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







All times are GMT +1. The time now is 03:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com