+ Reply to Thread
Results 1 to 3 of 3

Namebox hidden by Functionlist

  1. #1
    Richard
    Guest

    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. #2
    Bob Umlas
    Guest

    Re: Namebox hidden by Functionlist

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

    "Richard" <[email protected]> wrote in message
    news:[email protected]...
    > 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. #3
    Ricky Gibson
    Guest

    Re: Namebox hidden by Functionlist

    Thank you Bob,
    This makes life a lot easier.

    Richard

    "Bob Umlas" <[email protected]> wrote in message
    news:[email protected]...
    > Press the F3 key -- will bring up a list of the define names to paste in.
    > Bob Umlas
    > Excel MVP
    >
    > "Richard" <[email protected]> wrote in message
    > news:[email protected]...
    >> 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1