Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Mar 2004
    Thanked 0 Times in 0 Posts

    Using dropdown box in spreadsheet (2000)

    I would like to put a dropdown list where the names in red are. Rather than having to type out the names every time.
    Is this possible?
    I would like to refer to the names on a seperate worksheet, is this possible.
    see attachment.


  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Using dropdown box in spreadsheet (2000)

    Create the list of names on another worksheet, and assign a name to the list: select the list, then type the name in the box on the left hand side of the formula bar. For example: MyNames
    Switch to your worksheet, and select the range where you want the dropdown list to appear.
    Select Data | Validation...
    Select List in the Allow box, then type =MyNames in the Source box.
    Click OK.

Posting Permissions

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