Edit your drop-down list by changing the data source or the list itself

A drop-down list in Excel is a cell or range of cells that shows a small arrow when you click it, letting you pick from preset options instead of typing. To edit one, you either change what options appear in the list, or you change which cells have the drop-down attached to them. The method depends on whether you want to add a new choice, remove an old one, or point the drop-down to a different set of options entirely.

Excel stores drop-down lists using a feature called Data Validation. When you edit the list, you are editing the rule that Data Validation applies to those cells. The fastest way is to go back to the cell with the drop-down, open Data Validation again, and change the source.

Key Takeaways

  • Click a cell with a drop-down, go to the Data tab, select Data Validation, and change the "Source" field to edit what options appear.
  • If your list is stored in cells (like A1:A5), you can edit the options directly in those cells and the drop-down updates automatically.
  • To add a single option to an existing drop-down, expand the cell range in the Source field — for example, change A1:A5 to A1:A6.
  • Removing an option means either deleting it from the source cells or removing the drop-down from specific cells and reapplying it to others.
  • If you type a list directly into the Data Validation dialog instead of linking to cells, you must edit the dialog itself to change the options.

Find the drop-down and open Data Validation

Click any cell that has the drop-down arrow. When you select it, you should see a small downward-pointing arrow appear on the right side of the cell. If you do not see an arrow, the cell does not have a drop-down attached.

Go to the Data tab at the top of the ribbon. Look for a button labeled Data Validation (in some older versions of Excel, it says "Validity"). Click it. A dialog box opens showing the rules applied to that cell.

The dialog has several tabs. Make sure you are on the Settings tab. This is where you see the "Source" field, which controls what options appear in your drop-down.

Change the source if your list is in cells

If the Source field shows a cell range like $A$1:$A$5, your drop-down is pulling options from those cells. This is the easiest type to edit. You can change the options by editing the cells themselves, and the drop-down updates right away.

Close the Data Validation dialog. Go to the cells listed in the Source field (in this example, cells A1 through A5). Edit the text in those cells as you would any other cell. Delete an option, type a new one, or change the wording. When you click back to a cell with the drop-down and click the arrow, you will see your changes.

If you need to add more options than the current range holds, you can expand the range. Open Data Validation again on the drop-down cell, and change the Source from $A$1:$A$5 to $A$1:$A$10 (or however many cells you need). Then type your new options into cells A6, A7, and so on.

Change the source if your list is typed directly

If the Source field shows text like "Option 1, Option 2, Option 3" instead of a cell range, the options were typed directly into the dialog. You must edit them in the dialog itself — changing the cells will not work.

In the Data Validation dialog, click in the Source field and edit the text. Options are separated by commas or line breaks, depending on how the list was set up. Delete the option you want to remove, add a new one with a comma or line break between it and the others, or change the wording of an existing option.

Click OK when you are done. The drop-down now shows your updated list.

Remove a drop-down from specific cells

If you want to delete the drop-down from some cells but keep it on others, select only the cells you want to remove it from. Go to Data > Data Validation, and click the Clear All button. This removes the drop-down rule from those cells only.

The cells you did not select will keep their drop-downs. This is useful if you set up a drop-down across a large range and later decide only some cells need it.

Copy a drop-down to new cells

If you have a drop-down you like and want to use it elsewhere, select the cell with the drop-down. Copy it (Ctrl+C or Cmd+C). Select the cells where you want the drop-down to appear. Use Paste Special (Ctrl+Shift+V or Cmd+Shift+V), click the Validation checkbox, and click OK. The drop-down rule copies to the new cells.

If the original drop-down pointed to a cell range, the copied drop-down will adjust the range automatically based on the new location. For example, if the original pointed to A1:A5 and you paste it one column to the right, the new drop-down points to B1:B5. If you want all copies to point to the same cells, use absolute references like $A$1:$A$5 in the Source field.

Troubleshoot a drop-down that is not updating

If you edited the source cells but the drop-down still shows the old options, make sure you are looking at the right cells. Open Data Validation on the drop-down cell and check the Source field. It may point to a different range than you thought.

If the Source field shows a typed list instead of a cell range, editing the cells will not change the drop-down. You must edit the dialog itself. If you want to switch from a typed list to a cell-based list, clear the Source field, select the cell range option from the dropdown menu at the top of the dialog, and then click the cells or type the range you want to use.

Frequently Asked Questions

Can I edit a drop-down list without opening Data Validation?

Yes, if your drop-down points to cells. straightforward edit the text in those cells, and the drop-down updates automatically. You only need to open Data Validation if you want to change the range itself, add more options than the current cells hold, or if the list was typed directly into the dialog.

What happens if I delete a cell that the drop-down points to?

The drop-down will show a blank space where that option was, or it may show an error. To fix it, open Data Validation and either restore the deleted cell or change the Source to a different range that has all the options you want.

Can I have the same drop-down on multiple cells that all point to the same list?

Yes. Select all the cells you want the drop-down on, open Data Validation, set the Source to your cell range (using absolute references like $A$1:$A$5), and click OK. All selected cells will have the same drop-down pointing to the same list.

How do I change the order of options in a drop-down?

If your drop-down points to cells, rearrange the text in those cells. If the list was typed directly into the dialog, open Data Validation and rearrange the text in the Source field. The drop-down will show options in the order they appear in the source.