Edit Dropdown list in Google Sheets

  • Reading time:2 mins read
  • Post category:Utility
  • Post comments:0 Comments

Dropdown lists is an excellent data validation tool provided by Google Sheets. It’s a great tool to standardize data, provide ease of input to users and help create dynamic Google Sheets views.

Sample Dropdown List in Google sheet

However, at times you may require to edit dropdown cells in Google Sheet. For example, you created a dropdown list of products and a new product gets added, a dropdown list of Food Menu options and a menu option gets discontinued.

We have talked about creating a dropdown sheet in detail in another post. In this tutorial we will go through various ways of editing a dropdown list.

Sample Google Sheet File

In this tutorial we will be using the below Google Sheet Document to work. Feel free to create a copy of for yourself.

Create Dropdown list in Google Sheet

Edit “List of Items” type Dropdown List

Below are the steps to edit list of items type dropdown lists.

  1. Select the cell whose dropdown list you want to edit
  2. Goto Data-> Data Validation
  3. Add/Edit/Remove elements from List of Items as required
  4. Click Save

Step 1: Select the Cell with Dropdown list.

Sample Dropdown List

Step 2: Goto Menu bar, Data -> Data Validation

Data Validation Menu Option in Google Sheet

Step 3: Edit the “List of items” cell as per need. In our case we will add a new country, Australia to the list. Click Save.

Edit Dropdown Cell in Google Sheet

Step 4: The Dropdown lists gets updated with “Australia”

Updated Dropdown List in Google Sheet

Edit a “Range Type” Dropdown list in Google Sheet

There are two ways you would want to edit a “Range” type dropdown list.

1. Update a value from Existing Range.

This is fairly straightforward. Just go-over to your range and edit the value you require. The Dropdown list will be updated accordingly.

In the below demo we have replaced USA with India and the Dropdown list is updated automatically

Editing Dropdown list Range

2. Add a new value to the existing range.

To add a new value to your dropdown list. Simply add it to the range.

Now go to Cell E3 and then to Data Validation Option. Now update the range here.

Edit Dropdown list Range

Closing Remarks

Mastering dropdown list is a very useful skill that every user to aspire to have. There are multiple connected topics like creating a dependent dropdown list, adding color to dropdown list which you can also read about.

That’s it on this topic. If you face any issues in implementing the above methods then leave a comment down below. Keep browsing SheetsInfo for more such useful information 🙂

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

Liked the content?? Then share the word!!!

Rishav

I love Google Sheets and heavily rely upon it on a day to day basis. SheetsInfo is my attempt to share my learning with all of you. Hope you find the articles easy to read and simple to understand.

Leave a Reply