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.

In this article we will show you how to display multiple columns in a validation list in Excel. We will show you a method that can then be applied to your data.

You can insert blanks rows above or below another in Excel, and you can even add them between each row that has data.