Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    387
    Thanks
    0
    Thanked 1 Time in 1 Post

    Pick from list (XP)

    right clicking on a cell allows you to select the option Pick from List but I can't work out how to populate the list and Help isn't and help so Please can someone help!

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Pick from list (XP)

    The values in the "Pick from list" option are based on the values in the contiguous cells above the active cell.

    If you want to control values that are entered you can use Data Validation instead.
    Select "Data > Validation", and on the Settings tab select "List" in the Allow field. In the Source field type in your allowable items separated by a comma, or you can enter the range (preceded by an equal sign) to point to the list of allowable items from another part of the worksheet (you can also use a named range, which can be on another sheet in the workbook). If you want you can use the Message & Alert tabs to give the user some info about what is expected.

  3. #3
    3 Star Lounger
    Join Date
    Mar 2003
    Location
    Beddau, Mid Glamorgan, Wales
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pick from list (XP)

    Hi Kent:
    <hr>. . . values in the contiguous cells above the active cell . . .<hr>
    Just for completeness, the values in the "Pick from list" option are based on the values in the contiguous cells both above and below the active cell.
    Regards,

    Tony
    [s] [/s]
    www.SylviArtist.com

Posting Permissions

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