Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Sep 2005
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pick List In Excel (Excel 97)

    Hi,

    Do you know how to create a pick list please in Excel? I'm trying to set up a questionnaire and have a category for 'Source Of Referral' - relating to the NHS.

    I am hoping to show a list of patients and then would like the option of being able to click into each cell in the column for Source of Referral and select from 'GP,A&E, Clinic', but i'm not sure how you do this.

    Ideally I would like to be able to drag this down so when you click in each cell in this column a drop down box appears and you can select one of these categories.

    Many thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Pick List In Excel (Excel 97)

    You can use Data | Validation for this.
    Start by creating a list of the available options in a range of cells.
    Select the range, then type a name in the cell address box in the formula bar, e.g. Source.
    Next, select the cells in which you want a dropdown list.
    Select Data | Validation...
    Select List from the Allow dropdown.
    Enter the following formula in the Source box:

    =Source

    If you wish, you can enter a help text in the Input Message tab, and an error message in the Error Alert tab.
    Finally, click OK.
    You should see a dropdown arrow in the active cell.

  3. #3
    New Lounger
    Join Date
    Sep 2005
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pick List In Excel (Excel 97)

    Thanks Hans that's very helpful - i've done it now.

Posting Permissions

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