Results 1 to 3 of 3
  1. #1
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Pick from List (Excel 97 and 2000)

    When I right click in any cell (in either version of Excel), the shortcut menu includes a "Pick from List" option. But when I select that option nothing happens.
    Two questions:

    * What is supposed to happen? I imagine it does something that what I get if I got to Data..Validation. I have worked out that I can do what I need to do from there, but I am interested to know what the menu command is supposed to do.
    * Why might mine not work ? I don't have any unusual add-ins installed.
    Attached Images Attached Images
    Regards
    John



  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Pick from List (Excel 97 and 2000)

    It works ONCE you have some text filled in the column.

    After you have some entries in a column, goto any other contiguous cell and when you select "pick from cell" it will display a list of all the unique values in the cells. It is like the autocomplete in a column.

    Steve

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Pick from List (Excel 97 and 2000)

    I see now, thanks.

    I also notice now that when I thought it was doing nothing, it was actually presenting me with an empty list to pick from.
    Regards
    John



Posting Permissions

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