How to Edit Dropdown Lists in Excel

Edit a dropdown by changing its source list

To edit a dropdown in Excel, you change the list of options it shows. Open the sheet, click the cell with the dropdown, then go to the Data tab and select Data Validation. In the dialog box, look at the Source field — this is where the dropdown gets its options. You can edit the list directly here, delete items, add new ones, or point to a different range of cells.

The fastest way depends on how you set up the dropdown originally. If you typed the options directly into the Source field (separated by commas), you can edit them right there. If the dropdown pulls from a named range or a column elsewhere in the sheet, you edit the source cells instead, and the dropdown updates automatically.

Key Takeaways

Edit a dropdown's options by selecting the cell, opening Data Validation, and changing what appears in the Source field.
If the dropdown pulls from cells elsewhere in the sheet, edit those cells directly and the dropdown updates on its own.
You can add, remove, or reorder items in a dropdown without deleting the dropdown itself.
Dropdowns that reference a named range update automatically when you add rows to that range, so you do not have to edit the dropdown each time.

Edit options typed directly into the dropdown

If you created the dropdown by typing options into Data Validation (like "Red, Blue, Green"), you edit them the same way. Click the cell with the dropdown, go to Data > Data Validation, and look at the Source field. Delete an option by removing its text and the comma after it. Add a new option by typing a comma, a space, and the new text. Reorder by cutting and pasting text within the field.

After you make changes, click OK. The dropdown now shows your new list. This method works for small lists, but if you have many options or need to use the same list in multiple dropdowns, it is easier to put the options in cells and reference those instead.

Edit a dropdown that pulls from cells

If your dropdown references a range — like =Sheet1!A1:A10 or a named range called Colors — you edit the source cells, not the dropdown itself. Find the cells the dropdown points to, and change, add, or delete the text there. The dropdown updates when ready.

To find which cells a dropdown uses, click the cell with the dropdown, open Data Validation, and read the Source field. It will show either a cell range (like A1:A10) or a named range (like ProductList). Go to those cells and edit them. If you used a named range, you can also expand it by adding more rows — the dropdown will include them automatically without you touching the validation settings.

Add or remove items without breaking the dropdown

You can add items to a dropdown list without opening Data Validation again, as long as the dropdown references cells. If your dropdown points to cells A1 through A10, and you want to add a new item, type it in A11. Then edit the Data Validation source to =A1:A11 instead. The dropdown now includes the new item.

To remove an item, delete the text from that cell. If the cell becomes empty, the dropdown will show a blank line — delete that row entirely if you want to clean it up. Then update the source range in Data Validation to match the new size. For example, if you had =A1:A10 and deleted row 10, change it to =A1:A9.

Use a named range to make dropdowns easier to maintain

If you manage multiple dropdowns or expect to add items often, create a named range instead of typing cell references. Put your list in a column — say A1 through A20 — then select those cells. Go to Formulas > Define Name (or Name Manager) and give it a name like StatusOptions. Now create dropdowns using that name as the source.

When you need to add an item, type it in the next empty cell in that column, then edit the named range to include the new row. All dropdowns using that name update automatically. This saves time if you have the same dropdown in ten different cells — you change the source once, and all ten dropdowns reflect the change.

Delete a dropdown without losing the data

If you want to remove the dropdown from a cell but keep the value that is currently in it, click the cell, go to Data > Data Validation, and click Clear All. The dropdown disappears, but the text stays. The cell becomes a regular text cell.

If you want to delete the dropdown and the content, just delete the cell normally. To remove a dropdown from multiple cells at once, select all of them, open Data Validation, and click Clear All.

Common problems when editing dropdowns

If you edit the source cells but the dropdown does not update, check that you are editing the right cells. Open Data Validation and confirm the Source field points to where you made changes. If the source is a named range, make sure you expanded the range itself — adding a cell below the range does not automatically include it.

If the dropdown shows an error or blank lines, the source range may include empty cells. Delete those rows or adjust the range to exclude them. If you moved the source cells to a different location, the dropdown will break — you have to update the Source field in Data Validation to point to the new location. If the source was on a sheet you deleted, the dropdown stops working entirely and you have to recreate it.

Frequently Asked Questions

Can I edit a dropdown in multiple cells at once?

If all the dropdowns use the same source, edit the source cells or named range once and they all update. If each dropdown has its own list, you have to edit them individually. To save time in the future, use a named range so all dropdowns reference the same source.

What happens if I delete a row that the dropdown uses?

The item in that row disappears from the dropdown. If you deleted it by mistake, undo the deletion. If the dropdown now shows fewer items than before, you may also need to update the Source range in Data Validation to match the new size of your list.

Can I sort the items in a dropdown?

If the dropdown pulls from cells, sort those cells normally — select them and use Data > Sort. The dropdown will show the items in the new order. If you typed the items directly into Data Validation, you have to edit them manually by cutting and pasting text within the Source field.

How do I copy a dropdown to other cells?

Click the cell with the dropdown, copy it, then select the cells where you want the dropdown and paste. Excel copies the validation settings. If the dropdown references specific cells, make sure those cells exist in the new location or adjust the source after pasting.

What if the dropdown shows an item that is no longer in the source list?

Excel allows a cell to keep a value even if it is not in the current dropdown list. To fix this, either add the item back to the source, or delete the value from the cell and choose a new item from the dropdown. The dropdown itself will not show the old item, but the cell can still contain it.

This guide is for general information only and is not medical, financial, legal, or other professional advice. For decisions specific to your situation, consult a qualified professional. See our Editorial Policy.