[ad_1]
Google Sheets makes it easy to add and remove items from existing dropdown menus in your spreadsheets. You can also change the dropdown setting and even remove it entirely if you want. This is how you do it.
Sheets allows you to selectively make changes to your dropdown menus. This way you can select one dropdown and make changes to it, while keeping all other dropdowns as they are.
RELATED: How to Create a Dropdown List in Google Sheets
Add or remove items from dropdown menus in Google Sheets
To modify dropdown list items in your spreadsheets, first, launch a web browser on your computer and open Google Sheets. Then access the spreadsheet where your dropdowns are located.
On your spreadsheet screen, select the cells that contain the dropdown items you want to modify.
While your dropdowns are selected, on the Google Sheets menu bar, click Data > Data Validation.
In this window, the “Criteria” menu defines the type of items that your dropdowns have. To add or remove items, use the box next to this menu.
You can add a new list item by typing a comma and then entering the name of your item. Or, you can remove an item by deleting it from the list. Feel free to change any other options you want in 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 dropdown lists.
You’re probably wondering what happens to cells where you’ve selected a list item that’s no longer available. In those cells, Sheets displays a warning message that the item entered is invalid. You will want to select a new valid item from the dropdown list in these cells.
If you want to remove a dropdown from a cell, select that cell and choose Data > Data Validation from the menu bar. Then, in the “Data Validation” window, click “Remove Validation”.
Your dropdown is now removed, but the values ​​you previously selected are still there for you to use.
And that’s how you edit your dropdown lists in Google Sheets to add new items and remove existing ones. Very useful!
You can also edit existing dropdown menus in Microsoft Excel.
RELATED: How to Edit a Dropdown List in Microsoft Excel
[ad_2]
