How to edit or replace an existing drop-down list

To change a drop-down list in Excel, select the cell or range containing the list, then go to the Data tab and click Data Validation. The dialog box will show your current settings. You can edit the source list directly in the Source field, delete entries, add new ones, or point to a different cell range entirely. Click OK to save your changes.

The exact steps depend on whether your list is typed directly into the validation rule or linked to cells elsewhere in the workbook. If you typed the list as comma-separated values (like "Red, Blue, Green"), you can edit that text directly. If you pointed to a range of cells (like $A$1:$A$10), you can change which cells the list pulls from, or edit the values in those cells and the drop-down will update automatically.

Key Takeaways

  • Select the cell with the drop-down, open the Data tab, and click Data Validation to see and edit the current list.
  • You can add or remove items by editing the Source field, or change which cells the list pulls from.
  • If your list is linked to cells, editing those cells updates the drop-down without opening Data Validation again.
  • Removing a drop-down entirely requires selecting the cell and clicking Data Validation, then choosing Clear All.

Editing a list typed directly into the validation rule

If you created the drop-down by typing values directly into the Source field (separated by commas or line breaks), you edit them the same way. Select the cell, open Data > Data Validation, and look at the Source box. You will see something like Red, Blue, Green, Yellow or each item on its own line.

To add an item, place your cursor at the end and type a comma (or press Enter for a new line) and the new value. To remove an item, select and delete it. To change the spelling or wording of an existing item, click into that word and edit it. Click OK when you are done, and the drop-down will reflect your changes immediately.

Changing a drop-down that pulls from a cell range

Many drop-downs are built to pull their values from a range of cells — for example, a list of product names in cells A1:A20. If you want to change which cells the list uses, select the cell with the drop-down, open Data > Data Validation, and look at the Source field. You will see a cell range like $A$1:$A$20.

To point to a different range, clear the current range and type the new one, or click the small button to the right of the Source field and drag to select the cells you want. This is useful if your list moved to a different part of the sheet or if you want to use a completely different set of values. Click OK to apply the change.

If you want to keep the same range but add or remove items from it, you do not need to open Data Validation at all — just edit the values in those cells directly. The drop-down will show the updated list the next time someone clicks it.

Expanding or shrinking the range a drop-down uses

If your list is in cells A1:A10 but you want to add more items below it, you have two options. The first is to edit the Data Validation rule to expand the range to A1:A15 or A1:A20. The second is to add your new values to the cells below and then adjust the range to include them.

To expand the range, select the cell with the drop-down, open Data > Data Validation, and change the Source field from $A$1:$A$10 to $A$1:$A$15. To shrink it, do the same but use a smaller range. This approach works well if you know exactly how many items you will need. If your list grows unpredictably, consider using a named range or a dynamic formula instead — both allow the drop-down to adjust automatically as you add or remove values.

Removing a drop-down list entirely

To delete a drop-down and return the cell to normal, select the cell, go to Data > Data Validation, and click the Clear All button. The dialog will close and the drop-down will be gone. The cell will retain whatever value was selected, but users will no longer see the dropdown arrow.

If you want to remove the drop-down from multiple cells at once, select all of them together (click the first cell, hold Shift, and click the last cell, or select a range), then open Data Validation and click Clear All. This removes the validation rule from the entire selection in one step.

Copying a drop-down to other cells

Once you have created or edited a drop-down, you can copy it to other cells without retyping the rule. Select the cell containing the drop-down, copy it (Ctrl+C or Cmd+C), then select the cells where you want the drop-down to appear and paste (Ctrl+V or Cmd+V). Excel will copy the validation rule along with any cell content.

If the drop-down is linked to a cell range, Excel will adjust the range automatically when you paste. For example, if the original drop-down pointed to $A$1:$A$10 and you paste it one row down, it may adjust to $A$2:$A$11 — unless you used absolute references (dollar signs) to lock the range. To keep the range exactly the same across all cells, make sure the Source field uses absolute references like $A$1:$A$10.

Frequently Asked Questions

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

Yes, if the list is linked to cells. Edit the values in those cells directly and the drop-down updates automatically. If the list was typed directly into the validation rule, you must open Data Validation to edit it.

What happens to the cell value if I remove an item from the drop-down?

If a cell contains a value that is no longer in the list, Excel will not delete it — the cell keeps the old value. However, users will not be able to select it from the drop-down anymore. To prevent errors, remove items carefully or update cells that contain them first.

How do I make a drop-down list that updates automatically when I add new items?

Use a dynamic range or a named range with a formula. Instead of pointing to $A$1:$A$10, use a formula like =OFFSET($A$1,0,0,COUNTA($A:$A),1) in the Source field. This counts how many cells have values and adjusts the range automatically.

Can I change the order of items in a drop-down?

Yes. If the list is typed directly, edit the Source field and rearrange the items. If the list is linked to cells, rearrange the values in those cells and the drop-down order will change. Users will see the new order the next time they click the dropdown arrow.