Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy without Hidden Cols - How | Excel Discussion (Misc queries) | |||
Hidden Columns in Shared Workbooks | Excel Discussion (Misc queries) | |||
How to "ignore" hidden columns? | Excel Discussion (Misc queries) | |||
hidden rows & columns slow file open | Excel Discussion (Misc queries) | |||
Hidden page bracks in Excel should be deactivated | Excel Discussion (Misc queries) |