Excel drop-down list

Create a drop-down list

1. Select the cells that you want to contain the lists.
2. On the ribbon, click DATA > Data Validation.
3. In the dialog, set Allow to List.
4. Click in Source, type the text or numbers (separated by commas, for a comma-delimited list) that you want in your drop-down list, and click OK.

1. How do I create a drop-down list in Excel with multiple columns?
2. Can an Excel drop-down list multiple selection?

How do I create a drop-down list in Excel with multiple columns?

In the same or in another spreadsheet, select a cell or several cells in which you want your primary drop-down list to appear. Go to the Data tab, click Data Validation and set up a drop-down list based on a named range in the usual way by selecting List under Allow and entering the range name in the Source box.

Can an Excel drop-down list multiple selection?

Excel Data Validation - Select Multiple Items. Instead of limiting an Excel data validation drop down list to a single selection, you can use this macro to allow multiple selections. Video and written instructions, and get the free workbook to see how it works.