+ Reply to Thread
Results 1 to 2 of 2

with a drop down list in excel how do I select multiple values

  1. #1
    Keith H
    Guest

    with a drop down list in excel how do I select multiple values

    I have a validation on one of my columns for Users to select values from a
    list in a different worksheet. This works fine, but now the Users need to
    select multiple values in the one cell. How do you do that? A simple
    example.
    Pet Type
    Dog Retriever, Beagle

  2. #2
    Gord Dibben
    Guest

    Re: with a drop down list in excel how do I select multiple values

    I think what you need is a dependent DV list.

    Select Dog from DV list and a second DV list appears with the Type of dog

    See Debra Dalgleish's site for instructions.

    http://www.contextures.on.ca/xlDataVal02.html


    Gord Dibben MS Excel MVP

    On Thu, 13 Jul 2006 08:57:02 -0700, Keith H <Keith H@discussions.microsoft.com>
    wrote:

    >I have a validation on one of my columns for Users to select values from a
    >list in a different worksheet. This works fine, but now the Users need to
    >select multiple values in the one cell. How do you do that? A simple
    >example.
    >Pet Type
    >Dog Retriever, Beagle



+ 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