Edit or Replace an Existing Drop-Down List

To change a drop-down menu in Excel, you need to access the Data Validation tool where the list was originally created. Select the cell or range containing the drop-down, then open the Data menu and choose Validity (in some versions) or Data Validation. The dialog box shows the current list source — you can edit the entries directly, swap in a new list, or change the validation type altogether.

The fastest route depends on what you want to change. If you only need to add or remove a few items from the existing list, edit them in the Source field. If the list pulls from a named range or another sheet, you can update that source instead, and the drop-down updates automatically. If you want to replace the entire list with something different, clear the current source and enter the new one.

Key Takeaways

  • Select the cell with the drop-down, open Data Validation, and edit the Source field to change the list items.
  • If your list is linked to a named range, update the range itself and the drop-down refreshes without touching the validation settings.
  • You can change the validation type from a list to a number, date, or text length requirement using the Allow dropdown in the dialog.
  • To remove a drop-down entirely, select the cell, open Data Validation, and click Clear All.

Edit Items in a straightforward List

If your drop-down contains a short list you typed directly into the Source field, you can edit it in place. Select the cell with the drop-down, go to Data > Validity or Data Validation, and look at the Source box. Each item should be separated by a line break or comma, depending on how it was set up.

Click in the Source field and add, delete, or reorder the items. If items are separated by line breaks, press Ctrl+Enter (Windows) or Cmd+Enter (Mac) to move to the next line when typing new entries. When you finish editing, click OK. The drop-down now shows your updated list.

Change a List Linked to a Named Range

If your drop-down pulls from a named range — a set of cells you named and referenced in the validation — you do not need to touch the Data Validation dialog at all. Instead, go to the named range itself, usually on another sheet or in a hidden area, and edit the cells directly. The drop-down updates automatically.

To find which named range your drop-down uses, select the cell and open Data Validation. The Source field shows the range name (for example, "ProductList" or "RegionNames"). Navigate to that range on your sheet, add or remove items, and save the file. Every drop-down using that range will reflect the change when ready.

Replace the Entire List with a Different Source

If you want to swap the list for a completely different one, select the cell, open Data Validation, and clear the Source field. You can then enter a new list by typing items separated by line breaks, or point to a different range of cells.

To point to a range, type the sheet name and cell range — for example, =Sheet2!A1:A10 — or use a named range if one exists. If you are replacing a list that many cells use, consider creating a new named range for the new list, then updating the validation source to that name. This keeps your spreadsheet organized and makes future changes simpler.

Change the Validation Type Entirely

The Data Validation tool does more than lists. You can change a drop-down to validate whole numbers, decimals, dates, times, or text length instead. Select the cell, open Data Validation, and click the Allow dropdown (the first field in the dialog). Choose the type you want — for example, Whole Number or Date.

When you change the type, the dialog options shift to match. A whole number validation asks for a minimum and maximum; a date validation asks for a start and end date. You can also add an error message that appears if someone enters invalid data. This is useful when you want to restrict input without showing a list of choices.

Remove a Drop-Down Completely

To delete a drop-down and return the cell to normal input, select the cell, open Data Validation, and click Clear All. The validation rule disappears, and the cell accepts any entry without restriction.

If you want to remove the drop-down from multiple cells at once, select the entire range, open Data Validation, and click Clear All. This removes validation from every cell in the selection in one step.

Troubleshoot Common Changes

If you edited the list but the drop-down still shows the old items, make sure you clicked OK to save the changes. If the drop-down is linked to a named range and your edits did not appear, check that you edited the correct range — navigate to the named range location and verify the cells contain your new data.

If the drop-down arrow disappears after you make changes, the validation may have been accidentally cleared. Reopen Data Validation and re-enter your list or range. If you are working with a shared file, save and close it, then reopen it to refresh the validation display across all cells.

Frequently Asked Questions

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

Yes, if the list is linked to a named range. Edit the cells in the range directly, and the drop-down updates automatically. If the list was typed directly into the Source field, you must open Data Validation to edit it.

What happens if I delete items from a drop-down but cells already contain those values?

The cells keep their current values, but users cannot select those items from the drop-down anymore. The old values remain in the cells unless you manually delete them or use Find & Replace to remove them.

Can I change a drop-down to allow both a list and free text entry?

No. Data Validation enforces either a list (users must pick from it) or free text (users can type anything). You cannot combine both restrictions in a single cell.

How do I change a drop-down in Excel on a Mac?

The process is the same. Select the cell, go to Data > Validity, and edit the Source field. The dialog layout and options match the Windows version.