![]() |
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" 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 |
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