+ Reply to Thread
Results 1 to 3 of 3

How to make a list with multiple choices?

  1. #1
    Registered User
    Join Date
    05-12-2020
    Location
    Hertzelya Israel
    MS-Off Ver
    16
    Posts
    22

    How to make a list with multiple choices?

    Hello Everyone,
    I need to make cells in Excel where in each will be a list, from which I can select several values and not just one.
    How do we do that? I found only how to a make a list from where I can select only one option.
    (At Data - Data validaion you can select list but it is a list where you can pick only one item.)


    Thanks,
    Koby

  2. #2
    Registered User
    Join Date
    07-12-2014
    Location
    USA
    MS-Off Ver
    2003
    Posts
    37

    Re: How to make a list with multiple choices?

    Take a look at this article, and if it doesn't solve your problem, maybe you could provide more detail about what obstacle you're encountering? Lists with multiple choices is a pretty standard Excel function.

    https://www.excel-easy.com/examples/drop-down-list.html

  3. #3
    Registered User
    Join Date
    05-12-2020
    Location
    Hertzelya Israel
    MS-Off Ver
    16
    Posts
    22

    Re: How to make a list with multiple choices?

    Thanks for the reply.
    This article show how to make a list with the option to select only one item. How do I make a cell with a list where I can select several Items?
    e.g citizensip, if a person has several citizenships ...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to make your Excel 'Options' choices persistent?
    By MathUKTeacher in forum Excel General
    Replies: 3
    Last Post: 01-11-2015, 08:17 PM
  2. Replies: 0
    Last Post: 04-15-2013, 09:22 AM
  3. Drop-down list choices restricting choices of other lists?
    By not_quite_excelling in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-25-2011, 06:04 AM
  4. How to make choices in a combo box from a macro?
    By Mojave in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-01-2010, 06:46 PM
  5. Make clicked button go bold and other choices go gray
    By szfoster in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-20-2009, 03:41 PM
  6. Muultiple userform 'reset' code question
    By peter.thompson in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-21-2006, 08:23 PM
  7. Replies: 3
    Last Post: 05-19-2005, 08:06 PM

Tags for this Thread

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