How To Add Drop Down List In Google Sheets

3 min

How To Add Drop Down List In Google Sheets
How To Add Drop Down List In Google Sheets
How To Add Drop Down List In Google Sheets

The Google Sheets is a free online tool like Microsoft Excel that allows you to gather data in list form. You can also share this file with others on the internet. Not many people can afford to buy Microsoft, due to which Google has provided a free tool to ensure that those people are not left behind. Learn how to add Drop Down List In Google Sheets.

Making a Drop-down menu can be beneficial in many ways. If you are working with colleagues, it is a great way to ensure that the written data is correct. In that case, we create a drop-down menu so that the employees don’t mess up the formulas due to incorrect input data.

Use the Data Validation Option to create a drop-down list so let’s get right into this fantastic guide.

Adding Drop-Down List From Data Validation Option

To add the much-needed drop menu, we will use two ways. One will automatically add all the details, and in the second, you will manually add the values. So let’s discuss both of them one after the other.

Range of Cells (option)

Firstly, we will see the automatic method. We will start by selecting the cell in which you want to create the drop-down menu. Now navigate your Google sheet and find the Data button on the top bar with the Insert and other tabs.

How To Add Drop Down List In Google Sheets

Here you can see the Data Validation menu, the one we will use to create the drop-down list. Click on it, and a pop-up screen will appear in front of you. Now you can see that there are many different options.

How To Add Drop Down List In Google Sheets

You can see some tabs in the front of the Criteria. Here you will see a drop-down on which “list from a range” will be displayed. You don’t need to change this in this method. You can see the cells you want to choose to contain the list’s data in front of it.

You can either manually write the first and last cell name or click on the icon in front and select the cells containing the data. Now check-mark the box that says “show drop-down list in cell.” If you don’t do it, you won’t be able to see your drop-down list. Now click Save and check the list you have just created.

List of Items (option)

In this, the steps will remain almost the same. You will again go into the Data validation tab, but this time, from the drop-down menu in front of the criteria, you will choose the “list of items” option. Now a box will appear in front of it in which you will manually write all the data and numbers you want to show inside the drop-down list.

Once you have added all the details, check-mark the ” show drop-down list in cell” to ensure it appears inside the cell. Now click Save, and your drop-down list will appear in the selected cell.

How to Remove the Drop Down List In Google Sheets

To remove the drop-down menu, you need to select or click on the cell from which you want to delete the data. Now go to the top bar and navigate to the Data tab. Inside this menu, you can easily see the data validation tab, so why wait, go and click on it.

How To Add Drop Down List In Google Sheets

A pop-up will appear in front of your screen that will include some different options. You have used this pop-up before to create the drop-down menu, so you will use it again to remove it permanently. Here you can see the Remove Validation button. So click on it quickly and get rid of the drop-down menu. These steps will clear how to add Drop Down List In Google Sheets.

Must Read: How To Put A Border in Google Docs


Now that you are familiar with the exact steps that you need to follow to add a drop-down list, try to make one for yourself. As you might have heard that if you want to memorize something, practice it as much as you can.

So I hope there are no more confusions left to address here. I will try to bring up more important stuff that will help you in daily life issues.

Bernard Harris
Staff, Reviews at Tecbotic. PC Gamer, Maximum PC. Love to help people in Technology. Done Information Technology Management, B.S... FaceBook Twitter


Your email address will not be published. Required fields are marked *