What you're actually editing when you change a drop-down menu

A drop-down menu in Excel is called data validation, and it's a rule attached to a cell that limits what you can type there. When you edit it, you're changing that rule — the list of options, the source the list comes from, or whether the drop-down exists at all. The cell itself doesn't hold the list; the list lives in the validation settings behind the cell.

This matters because editing a drop-down is different from editing the cell's contents. If you click a cell with a drop-down and just start typing, you're replacing what's in the cell, not changing the menu itself. To change the menu, you have to go into the validation settings.

Key Takeaways

  • Drop-down menus in Excel are data validation rules, not the cell contents, so you edit them through the Data menu, not by typing in the cell.
  • You can change the list of options, point the validation to a different range of cells, or delete the validation entirely to remove the drop-down.
  • The fastest way to edit a drop-down is to select the cell, go to Data > Data Validation, and change the settings in the dialog that opens.
  • If you want the same edited drop-down on multiple cells, you can copy the validation rule from one cell and paste it to others using Paste Special.

Finding and opening the data validation settings

Click the cell that has the drop-down you want to edit. If you're not sure which cell it is, click any cell in the spreadsheet and look for a small arrow on the right side of the cell — that arrow means data validation is active there.

Once you've selected the cell, go to the Data menu at the top of the screen. In Excel on Windows, click Data and look for Data Validation (or sometimes Validity depending on your version). In Excel on Mac, it's under Data > Validation. Click it, and a dialog box opens showing the current validation rule.

The dialog has tabs or sections. The one you need is usually called Settings or Criteria. This is where you see what type of validation is set up — whether it's a list, a number range, a date range, or something else.

Changing the list of options in an existing drop-down

If your drop-down currently shows a list of options (like "Red", "Blue", "Green"), the Settings tab will show Allow set to List. Below that, you'll see a field called Source or List.

There are two ways the list can be stored. The first is typed directly into the Source field — you'll see the options separated by commas or line breaks, like Red,Blue,Green. To change it, click in that field and edit the text. Add new options, remove old ones, or reorder them. Then click OK.

The second way is that the Source field contains a cell range, like $A$1:$A$10. This means the list is pulled from cells A1 through A10 somewhere else in your spreadsheet. To change the options, you don't edit the validation rule — you edit the cells in that range. Add or delete items in cells A1 through A10, and the drop-down updates automatically. If you want the drop-down to pull from a different range entirely, click in the Source field and change the cell range.

Removing a drop-down menu completely

Select the cell with the drop-down you want to remove. Open Data > Data Validation again. In the Settings tab, look for the Allow dropdown (the one at the top of the dialog). Change it from List to All. Then click OK.

The drop-down arrow disappears, and the cell becomes a normal text cell. The data that was in the cell stays there — you're only removing the validation rule, not the cell's contents.

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 in the range), then open Data Validation and change Allow to All. This removes the validation from every selected cell in one step.

Copying a drop-down to other cells

If you've edited a drop-down and want to use the same edited version on other cells, don't recreate it. Copy the validation rule instead. Select the cell with the drop-down you just edited. Copy it normally (Ctrl+C on Windows, Cmd+C on Mac).

Now select the cells where you want the same drop-down to appear. Right-click and choose Paste Special (or use Ctrl+Shift+V on Windows, Cmd+Shift+V on Mac). A dialog opens. Look for an option called Validation or Data Validation and make sure it's checked. Uncheck everything else so you're only pasting the validation rule, not the cell contents. Click OK.

The drop-down now appears on all the selected cells with the exact same list and settings as the original.

Fixing a drop-down that stopped working

Sometimes a drop-down stops showing options or shows an error. This usually happens because the source range was deleted or moved. Open Data Validation on the broken drop-down. In the Settings tab, check the Source field. If it points to a range like $A$1:$A$10, go to that range and make sure those cells still exist and still contain the list you want.

If the range was deleted, you'll need to either recreate the list in a new range and update the Source field to point to it, or type the list directly into the Source field instead of using a range. If the range still exists but the drop-down still isn't working, try deleting the validation rule entirely and recreating it from scratch.

Frequently Asked Questions

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

No. Clicking the cell and typing only changes what's in the cell, not the drop-down rule itself. You must go through Data > Data Validation to edit the menu. The only exception is if the list is stored in a cell range — then you can edit the options by changing the cells in that range directly.

What if I want different drop-downs on different cells?

Create each one separately. Select a cell, open Data Validation, set up the list you want, and click OK. Then select the next cell and repeat with a different list. You can also copy and paste validation rules between cells using Paste Special if some of them should be identical.

Will editing a drop-down change the data already in the cells?

No. Changing the validation rule doesn't touch the cell contents. If a cell contains "Red" and you edit the drop-down to remove "Red" from the list, the cell still shows "Red" — it just won't let you select "Red" if you edit the cell again.

Can I make a drop-down that pulls from a list in a different sheet?

Yes. In the Source field, type the range with the sheet name included, like Sheet2!$A$1:$A$10. Make sure the sheet name is spelled exactly as it appears in your workbook, and use an exclamation mark to separate the sheet name from the cell range.