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.

To save them time and make sure you get the information you need, you can create a drop-down box that limits the users to certain selections.

In Excel, the common reason for getting This action won't work on multiple selections error is because of a bad selection. Here's how to fix it.

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.