There is also a video that shows the multiple selection drop down list.To try it for yourself, follow the download link for the sample file, near the end of this article.
You also learn how to define well-organized data as an Excel table; then use Table features to work with the data.
In Lesson 1 you learn how to organize columns and rows of data into a range so that you can effectively sort, filter, subtotal, and outline the data.
You also learn how to define well-organized data as an Excel table; then…
" Microsoft® Excel® 2013: Working with Data Ranges and Tables is a two-lesson intermediate level course that guides you through organizing, entering and validating worksheet data and then effectively sorting, filtering, subtotaling, and outlining the data.
You have a status tracking spreadsheet where each employee enters the status for each of the projects they are working on.
They enter the status by first selecting the department and then selecting a project (from that department). Remember the offset() and match() formulas we discussed in the last spreadcheats?
You can display all the selected items across a row, or down a column, or keep them in the same cell.
Keep reading, to see some examples of this technique, and how it works.
You might want all the items in a single cell, or in adjacent rows or columns.