Multiple answers in one cell?

Question

How can I create a list in Excel (in a cell), that gives people the option to choose multiple answers and then have only those answer be visible when the box is not highlighted.

Answer 1

click on data validation and go to list. it will require you to put the range of values you require in the list and will then operate as you requested