What you're editing when you change a dropdown
A dropdown list in Excel is a set of choices you've locked into a cell using the Data Validation feature. When you click that cell, a small arrow appears and shows you the options you can pick from. To edit the dropdown, you're changing what those options are — you can add new choices, remove old ones, or swap them out entirely.
The dropdown itself lives in two places at once: the cell where you see it, and the list of values it pulls from (which might be hidden elsewhere in your spreadsheet, or typed directly into the validation rule). Editing means finding that source and changing it.
Key Takeaways
- Open the Data Validation dialog by clicking the cell with the dropdown, then going to Data > Data Validation (or Data Tools > Data Validation on Mac).
- If your dropdown pulls from a cell range, edit the source list directly in those cells, and the dropdown updates automatically.
- If your dropdown has values typed directly into the validation rule, you edit them in the Source field of the Data Validation dialog itself.
- You can add, remove, or reorder choices without deleting the dropdown — the validation rule stays in place.
Finding the Data Validation dialog
Click the cell that contains the dropdown you want to change. On Windows, go to the Data tab in the ribbon, then click Data Validation (it may say "Validity" in some versions). On Mac, click the Data menu at the top, then choose Validity.
A dialog box opens with several tabs. Click the Settings tab (or Criteria tab on some versions). You'll see a field labeled Source or List. This is where the dropdown's choices come from.
Editing a dropdown that pulls from a cell range
If the Source field shows something like $A$1:$A$10 or Sheet2!$B$2:$B$5, your dropdown is pulling its choices from cells elsewhere in the spreadsheet. To edit it, close the Data Validation dialog and go directly to those cells. Change, add, or delete the values there, and the dropdown updates automatically the next time you click it.
This method is cleaner if you have a long list or if multiple dropdowns share the same choices. You edit once, in one place, and all the dropdowns that point to that range reflect the change.
Editing a dropdown with values typed into the rule
If the Source field shows a list of values separated by commas or line breaks — for example, Red, Blue, Green, Yellow — the choices are stored directly in the validation rule itself. To edit this dropdown, stay in the Data Validation dialog and click in the Source field.
You can now add, remove, or change the text. If the list uses commas, separate new items with commas. If it uses line breaks, press Ctrl+Enter (Windows) or Cmd+Enter (Mac) after each item to move to the next line. When you're done, click OK, and the dropdown now shows your new choices.
Adding a new choice to an existing dropdown
If your dropdown pulls from a cell range, click on the last cell in that range and add your new value below it. Then go back to the Data Validation dialog for the dropdown cell, and edit the Source field to include the new row. For example, change $A$1:$A$10 to $A$1:$A$11.
If your dropdown has values typed into the rule, open the Data Validation dialog, click in the Source field, and add your new choice at the end. Separate it with a comma (or a line break, depending on how the list is formatted). Click OK.
Removing or reordering choices
For a dropdown that pulls from a cell range, delete the value from the source cell. You don't need to shrink the range in the Source field — Excel ignores empty cells. If you want the range to stay clean, you can edit the Source field to exclude that row, but it's not required.
To reorder choices in a cell-range dropdown, straightforward rearrange the values in the source cells. The dropdown will show them in the new order. For a dropdown with values typed into the rule, edit the Source field to rearrange the text in the order you want.
Copying a dropdown to other cells
Once you've edited a dropdown the way you want it, you can copy that validation rule to other cells. Click the cell with the dropdown, then copy it (Ctrl+C or Cmd+C). Select the cells where you want the same dropdown, and paste (Ctrl+V or Cmd+V). Excel pastes only the validation rule, not the cell's content.
If the original dropdown pulls from a cell range using relative references (like A1:A10 instead of $A$1:$A$10), the range will shift when you paste. Use absolute references (with dollar signs) if you want the dropdown to point to the same source cells no matter where you paste it.
Frequently Asked Questions
Can I edit a dropdown without opening the Data Validation dialog?
Only if the dropdown pulls from a cell range. Edit the source cells directly, and the dropdown updates automatically. If the values are typed into the validation rule itself, you must open the Data Validation dialog to change them.
What happens if I delete a choice that someone already selected?
The cell keeps the old value, but it no longer appears in the dropdown list. The cell will show a small error indicator (usually a green triangle) because the current value is no longer in the valid list. You can clear the cell or pick a new value from the updated dropdown.
Can I have the same dropdown in multiple cells?
Yes. Copy the cell with the dropdown and paste it into other cells. If you later edit the source list (either the cell range or the values in the rule), all dropdowns that point to that source will update together.
How do I know if my dropdown pulls from a range or has values typed in?
Open the Data Validation dialog and look at the Source field. If it shows cell references like $A$1:$A$5, it's pulling from a range. If it shows text like Yes, No, Maybe, the values are typed into the rule.
Can I edit a dropdown if I don't remember where the source list is?
Open the Data Validation dialog and check the Source field. If it shows a cell range, that's where to look. If the range is on a different sheet, the field will show the sheet name (like Sheet2!$A$1:$A$5). Click that sheet tab to find it.