How to Make a Drop Down Box to Allow Multiple Selections in Excel. Microsoft Excel allows you to create a drop-down list that gives you the ability to choose values or items listed in one cell.

A complex Excel 2007 workbook could require multiple sheets. By default, Microsoft provides three sheets on each workbook, but you can add as many as you need.