Google Sheets makes it easy to add and remove items from the existing drop-down menus in your spreadsheets. You can also change your drop-down settings, and even completely remove them if you want. Here’s how to do that.
Sheets lets you selectively make changes to your drop-downs. This way, you can select a drop-down and make changes to it, while keeping all other drop-downs as is.
Add or Remove Items From the Drop-Down Menus in Google Sheets
On your spreadsheet screen, select the cells containing drop-down items that you want to tweak.
While your drop-down menus are selected, in Google Sheets’ menu bar, click Data > Data Validation.
A “Data Validation” window will open where you’ll customize your drop-down list items.
On this window, the “Criteria” menu defines the kind of items your drop-down menus have. To add or remove items, then use the box next to this menu.
You can add a new list item by typing a comma and then entering your item name. Or, you can remove an item by clearing it in the list. Feel free to change any other options you want on this window.
When you’re done, at the bottom of the “Data Validation” window, click “Save.”
Your spreadsheet will now display the updated items in your drop-down lists.
You’re probably wondering what happens to the cells where you’ve selected a list item that’s no longer available. In those cells, Sheets displays a warning message saying the entered item is invalid. You’ll want to select a new valid item from the drop-down list in these cells.
If you’d like to remove a drop-down list from a cell, select that cell and choose Data > Data Validation in the menu bar. Then, on the “Data Validation” window, click “Remove Validation.”
Your drop-down list is now removed, but the values you selected previously are still there for you to use.
And that’s how you edit your drop-down lists in Google Sheets to add new items as well as remove existing ones. Very useful!
You can edit existing drop-down menus in Microsoft Excel, too.