How to allow multiple options to select in a cell?

[ishpahuja]

Hi, there are many rows in my worksheet. For all cells in one column of this worksheet, I want that user can enter multiple options from a list. How can that be done?
For e.g. I have 10 rows, and each cell from A1 to A10 represents a person. Then, there is a list of items that a person can posses i.e. food, drink, house, clothes, car, bike, bag etc. (there are 7-8 items in the list).

I want to give option to each person (aka in each cell from A1 to A10) to select multiple items in their respective cells from the list provided. How can I do that?
I used data validation but for "list" option in data validation, the user can only select one, and not multiple.

Please help.

 

[6StringJazzer]

You can't do it in one cell using data validation. Having multiple values in one cell isn't very easy to work with either.

How will you use this after they make a selection? I would just use multiple columns on each row, up to the maximum number of items someone could choose.

 

[ishpahuja]

You can't do it in one cell using data validation. Having multiple values in one cell isn't very easy to work with either.

How will you use this after they make a selection? I would just use multiple columns on each row, up to the maximum number of items someone could choose.

OK. Is there any other way (i.e. if data validation is not an option) I can capture this?
The user will indicate (check) the items and the cell output will be "xxx, yyyy, zzzz" depending on the number of items checked by user.