What you're changing when you edit a drop-down list

A drop-down list in Excel is a cell (or group of cells) that shows a small arrow when you click it, and lets you pick from a set of options you've already created. When you change the drop-down list, you're changing what those options are — you're not changing which cells have the arrow, but what words or numbers appear when someone clicks it.

The list itself lives in one of two places: either in a hidden range of cells somewhere on your sheet, or in a separate list you've typed directly into the drop-down settings. Most people use the hidden range method because it's easier to update later. This guide covers both, starting with the simpler one.

Key Takeaways

  • Drop-down lists pull their options from either a cell range you've hidden or from a list you typed into the validation settings.
  • To change what appears in the drop-down, find where the list lives, then edit those cells the same way you'd edit any other data.
  • If the drop-down won't update after you change the cells, you may have used absolute references and need to re-enter the range in the validation settings.
  • The fastest way to add new options is to add them to the end of your hidden list, then update the cell range in the validation settings to include the new rows.

Finding where your drop-down list is stored

Before you can change the list, you need to know where it lives. Click on a cell that has the drop-down arrow. Then go to the Data tab at the top of Excel, and click Data Validation (in older versions of Excel, this is called Validity). A box will open showing the settings for that drop-down.

Look for a field labeled Source or List. This field will show either a range like $A$1:$A$10 (which means cells A1 through A10 on your sheet) or a list of words separated by commas, like Red, Blue, Green. If you see a range, your list is stored in those cells. If you see words separated by commas, your list is typed directly into the settings — skip to the section "Editing a list typed directly into the settings".

Write down the range you see (for example, Sheet2!$B$2:$B$8). This tells you exactly where to find the list to edit it.

Editing a list stored in hidden cells

If your list is stored in a cell range, those cells might be hidden so they don't clutter your sheet. To unhide them, right-click on the column header (the letter at the top) or row number (the number on the left) where your list is stored. Select Unhide from the menu. The cells will now be visible.

You'll see your list — probably a single column of words or numbers. Edit these cells exactly as you would any other cells in Excel. Click on a cell, type the new text, and press Enter. Add new options by typing them into empty cells below the last item. Delete options by clearing the cell (select it and press Delete).

Once you've made your changes, test the drop-down by clicking on a cell that uses it. The new options should appear. If they don't, go back to the Data Validation settings and check that the range still matches where your list is. If you added new items below the original range, you'll need to update the range to include them — for example, change $A$1:$A$10 to $A$1:$A$15 if you added five new items.

Editing a list typed directly into the settings

If your list is stored as text in the validation settings (you saw words separated by commas), you'll edit it there instead of in cells. Click on a cell with that drop-down, open Data Validation again, and look at the Source or List field.

Click inside that field and edit the text directly. To add a new option, type a comma, then the new word (for example, change Red, Blue, Green to Red, Blue, Green, Yellow). To remove an option, delete it and the comma next to it. To change an option, select the word and type the replacement.

Click OK when you're done. The drop-down will update when ready. This method works well for short lists that rarely change, but if you have many options or update them often, storing the list in cells is easier because you can see all the options at once.

Adding new options without losing the old ones

The safest way to add options is to add them to the end of your existing list. If your list is in cells, click on the first empty cell below your last option and type the new item. Then update the range in Data Validation to include the new rows.

If your list is typed into the settings, add a comma at the end of the last item and type the new option. This way you won't accidentally delete something while editing.

Test the drop-down after each change to make sure the new option appears. If it doesn't, check that the range in Data Validation includes the cell where you typed it.

Why your changes might not show up

If you edited the cells but the drop-down still shows the old options, the range in Data Validation might be using absolute references that don't expand when you add new rows. The range might also be pointing to the wrong cells — for example, if you moved your list to a different column and forgot to update the range.

Open Data Validation again and check the Source field. Make sure it points to the cells where your list actually is now. If you added new items, make sure the range includes them. For example, if your list is in cells A1 through A15, the range should be $A$1:$A$15, not $A$1:$A$10.

If you're not sure which cells contain the list, look at the range in the Source field, then go to your sheet and click on the first cell in that range. Excel will highlight the entire range so you can see exactly what's included.

Hiding your list again after editing

Once you've finished editing, you can hide the cells again so your sheet looks clean. Right-click on the column header or row number where your list is stored, and select Hide. The cells will disappear from view, but the drop-down will still work — it's just pulling from hidden cells now.

You can unhide them anytime you need to make changes. The drop-down itself (the cells with the arrow) stays visible and works the same way whether the list is hidden or not.

Frequently Asked Questions

Can I have the same drop-down list in multiple cells?

Yes. Once you've created a drop-down in one cell, click on it, copy it (Ctrl+C), then select the other cells where you want the same drop-down and paste (Ctrl+V). All of them will pull from the same list, so editing the list updates all the drop-downs at once.

What if I want different drop-down lists in different cells?

Create each list in a separate range of cells (for example, one list in column A, another in column B). Then create a drop-down in the cells where you want it, and point each one to its own list range in the Data Validation settings.

Can I delete a drop-down list entirely?

Yes. Click on the cell with the drop-down, go to Data Validation, and click Clear All. The arrow disappears and the cell becomes a normal cell. The list of options (if it was stored in cells) stays in place — you can delete those cells separately if you want.

Why does my drop-down show an error when I try to use it?

This usually means the range in the Data Validation settings points to cells that no longer exist — you may have deleted the column or moved the list. Open Data Validation, check the Source field, and make sure it points to cells that actually contain your list. Update it if needed.