In Excel: a standard Data Validation list stores one value per cell, so multiple selection needs a workaround — most commonly a Worksheet_Change macro that appends each new pick to the existing text (desktop Excel, saved as .xlsm), or one checkbox or helper column per option combined with TEXTJOIN. Excel for the web cannot create, run, or edit VBA macros. Open the workbook in the Excel desktop app to work with macros.
On this page7
Create the normal list first: Data ▸ Data Validation ▸ Allow: List with your options.
Right-click the sheet tab, choose View Code, and add a Worksheet_Change procedure limited to the list range.
In it, turn events off, capture the new value, use Application.Undo to read the previous value, and write both joined with ", ".
Turn events back on (also in an error handler), then save the workbook as .xlsm.
Without macros: give each option its own column of checkboxes or Yes/No cells and combine the ticked ones with =TEXTJOIN(", ",TRUE,IF(C2:E2=TRUE,$C$1:$E$1,"")) (TEXTJOIN needs Excel 2019 or later; in versions without dynamic arrays confirm this IF-array formula with Ctrl+Shift+Enter).
What this does
Data Validation lists are single-selection by design: choosing a second item replaces the first. There is no setting in the Data Validation dialog that changes this. To collect several choices in one cell you need something that remembers the previous value — an event macro that runs after each pick and joins old and new values — or a layout that stores each option separately and combines them with a formula. The macro route keeps the familiar arrow but only runs where VBA runs. A macro runs in the desktop app's VBA environment, not in the cell grid: the workbook has to be saved in a macro-enabled format such as .xlsm to keep the code, and your macro security settings — or a file that arrived from the internet — can block it until you trust it. Excel for the web cannot run VBA at all. Treat “drop down menu excel multiple selection” as a small repeatable workflow rather than a one-off click you hope to remember next time. Use a small test block before the live file, so any surprise in the affected dropdown shows up while it is still harmless. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. That turns a data step that keeps your analysis trustworthy into a method you can reuse, explain, and defend when the workbook leaves your screen.
Worked example to check
Worked example: Task 17 needs Red and Blue labels. A standard Data Validation list stores one selection: Blue replaces Red. Without macros, use separate Label 1 and Label 2 columns, each with a list, or one row per task-label pair. Rows (Task 17, Red) and (Task 17, Blue) remain easy to filter and count. Combining selections in one cell requires extra logic; In-cell dropdown does not enable it. Excel for the web does not run VBA.
In Google Sheets
Google Sheets does not run VBA. A macro written for Excel has to be rewritten in Google Apps Script (Extensions ▸ Apps Script), and an .xlsm file converted to Sheets keeps its cells but drops the code. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. For “drop down menu excel multiple selection”, the checks are about the environment as much as the code: desktop Excel with macros enabled for this file, a macro-enabled workbook and a saved copy to fall back on. Run it once on test data, compare the result with what the code says it does, and only then run it on the real sheet.
Common mistakes
- Looking for a "multiple selection" option in the Data Validation dialog — there is none.
- Forgetting Application.EnableEvents = True in an error path, which silently stops every event macro in the workbook.
- Saving as .xlsx, which strips the macro.
- Expecting the macro to run in Excel for the web, the mobile apps or Google Sheets — VBA does not run there.
- Selecting the same item twice and getting it twice; add a check with InStr if duplicates matter.
Frequently asked questions
Can Excel's Data Validation allow multiple selections natively?
No. A Data Validation list holds one value per cell; multiple selection needs a macro or a separate layout.
Does the combined value break the validation rule?
Validation only checks typed entries, so a value written by the macro is kept even though "Red, Blue" is not in the list.
How do I count or filter cells with several selections?
Use a wildcard: =COUNTIF(B:B,"*Blue*") counts cells that include Blue among their selections.