![]() There is also a video that shows the multiple selection drop down list. Keep reading, to see some examples of this technique, and how it works. You can display all the selected items across a row, or down a column, or keep them in the same cell. Instead of limiting users to a single selection, you can use a bit of programming, combined with the data validation list, and allow multiple selections. Select Multiple Items From the Drop Down List ![]() ![]() In the worksheet shown below, you can select a month from the drop down, and it overwrites any previous selection in that cell. With a bit of programming, you can customize a drop down list, to select multiple items.īy default, data validation drop downs only allow you to select one item. You’ve probably used an Excel data validation drop down list, where you can click the arrow, and select an item to fill the cell.
0 Comments
Leave a Reply. |