Changing a dropdown list means editing the items that appear when someone clicks the cell

A dropdown list in Excel (also called data validation) is a cell that shows a small arrow when clicked, revealing a list of preset choices. To change what appears in that list, you go back to the data validation settings where the dropdown was created and edit the source — either the range of cells it pulls from, or the typed list itself.

The fastest way depends on whether the dropdown pulls from a list of cells elsewhere in the sheet, or whether the items were typed directly into the validation rule. Both take about two minutes once you know where to look.

Key Takeaways

  • Right-click the cell with the dropdown, select Data Validation, and you will see exactly what the dropdown is pulling from — either a cell range or a typed list.
  • If the dropdown pulls from cells, edit those cells directly and the dropdown updates automatically without touching the validation rule.
  • If the items were typed into the validation rule itself, open Data Validation again and edit the list in the Source field.
  • Adding a new item to a cell-based list is simpler than editing a typed list, because you just type in the next empty cell in that range.
  • Deleting items from a dropdown requires either deleting the source cells or editing the typed list — the dropdown will not update if you just delete from the sheet.

Find where the dropdown list is pulling from

Right-click the cell that contains the dropdown arrow. A menu appears. Click Data Validation (in Excel for Mac, it may say Validity). A dialog box opens showing the validation rule.

Look at the Source field. This tells you everything. If it shows something like $A$1:$A$10, the dropdown is pulling from cells A1 through A10 — you can edit those cells directly and the dropdown updates on its own. If the Source field shows a list of items separated by commas, like Red, Blue, Green, those items were typed into the rule itself, and you will need to edit them here.

Write down or remember what you see in the Source field. This determines which method you use next.

Edit a dropdown that pulls from cells

If the Source field showed a cell range like $A$1:$A$10, find those cells on your sheet. They contain the actual list. You can now edit them like any other cells: click one, type a new value, and press Enter. The dropdown updates when ready.

To add a new item, type it in the next empty cell within that range. If your range is A1 through A10 and A10 is empty, type the new item in A10. To remove an item, delete the text from that cell. The dropdown will no longer show it.

If you need to add more items than the original range allows — for example, the range was A1:A10 but you now have 15 items — you will need to edit the validation rule itself. Right-click the dropdown cell again, open Data Validation, and change the Source from $A$1:$A$10 to $A$1:$A$15. Click OK.

Edit a dropdown with a typed list

If the Source field showed a comma-separated list like Red, Blue, Green, the items live inside the validation rule, not in cells. Right-click the dropdown cell and open Data Validation again. Click in the Source field and edit the list directly.

To change an item, find it in the list and type the new text. To add an item, place your cursor at the end of the list, type a comma, a space, and the new item name. To remove an item, select its text including the comma and space before it, and delete it.

For example, if the Source shows Red, Blue, Green and you want to change Blue to Yellow, click in the field and change it to Red, Yellow, Green. If you want to add Purple, change it to Red, Yellow, Green, Purple. Click OK when you are done.

Expand or shrink the range a dropdown uses

If your dropdown pulls from cells and you need to change how many cells it includes, right-click the dropdown and open Data Validation. In the Source field, change the range. If it currently says $A$1:$A$10 and you want to include 20 items, change it to $A$1:$A$20. Click OK.

You can also change which cells the dropdown pulls from entirely. If it currently pulls from column A but you want it to pull from column B instead, change $A$1:$A$10 to $B$1:$B$10. This is useful if you reorganize your sheet and move the list to a different location.

Copy a dropdown to other cells with updated lists

If you have created a dropdown in one cell and want to copy it to other cells, you can do that — but the copied dropdown will point to the same source cells. If you want each dropdown to have a different list, you will need to create separate validation rules for each one.

To copy a dropdown that uses the same list, click the cell with the dropdown, copy it (Ctrl+C or Cmd+C), select the cells where you want the dropdown, and paste (Ctrl+V or Cmd+V). All copies will reference the same source range and update together.

If you want different dropdowns with different lists, create each one separately by right-clicking the cell, choosing Data Validation, and setting up the Source for that specific cell.

Delete a dropdown list entirely

To remove a dropdown from a cell, right-click it and open Data Validation. Click the Clear All button (or on Mac, the trash icon). Click OK. The dropdown disappears, but the cell content stays. The source cells (if you were using a range) are not affected.

If you want to delete the dropdown and also clear the cell content, select the cell and press Delete. If you want to delete the source cells that the dropdown was pulling from, select those cells separately and delete them — this will break the dropdown in any cells that reference it.

Frequently Asked Questions

Can I change a dropdown list without opening the Data Validation dialog?

Yes, but only if the dropdown pulls from cells. Edit the source cells directly and the dropdown updates automatically. If the list was typed into the validation rule, you must open Data Validation to edit it.

What happens if I delete a cell that the dropdown pulls from?

The dropdown will show a blank space where that item was. If you delete all the source cells, the dropdown will show an error when clicked. To fix it, either restore the cells or edit the Data Validation rule to point to a new range.

Can I make a dropdown pull from a different sheet?

Yes. In the Data Validation Source field, type the sheet name followed by the range, like Sheet2!$A$1:$A$10. The dropdown will pull from that range on the other sheet.

How do I sort the items in a dropdown list?

If the dropdown pulls from cells, sort those cells using the standard sort function — select them, go to Data menu, and choose Sort. If the list was typed into the validation rule, you must edit it manually in the Source field to rearrange the order.

Can I add a dropdown to multiple cells at once with different lists?

Not in one step. You must create each dropdown separately by right-clicking each cell and setting up its own Data Validation rule. If all the dropdowns should have the same list, copy one dropdown to the others instead.