How To

How to Change or Remove or Add a Drop-Down List in Google Sheets

Google Sheet is a handy platform provided by Google. Here you can see so many features which you want to know. Google Sheets makes adding and removing items from the existing drop-down menus in your spreadsheets. You can also change your drop-down settings and remove them if you want. Here’s how to do that.

Sheets let 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.

Check more how to guide

How to Change the Word Effects in Facebook Messenger 

Do You Know Markdown Feature And How to Use Markdown in Google Docs

How to Change the Google Phone App on Your Android 

How To Work A Twitter Alternative Mastodon Work?

How to Setup a Drop-Down List in Google Sheets

  1. first, launch a web browser on a computer laptop and
  2. And open Google Sheets.
  3. Then open the spreadsheet of Google Sheet in which your drop-down lists are located.
  4. Select the cells containing drop-down items that you want to tweak on your spreadsheet screen.
  5. While your drop-down menus are selected, in Google Sheets’ menu bar, click Data > Data Validation.
  6. A “Data Validation” window will open where you’ll customize your drop-down list of items.
  7. In this window, the “Criteria” menu defines the kind of items your drop-down menus have.
  8. To add or remove items, use the box next to this menu.
  9. When you’re done, at the bottom of the “Data Validation” window, click “Save.”
  10. Your spreadsheet will now display the updated items in your drop-down lists.

To Top