How To Create A Drop down List In Google Sheets: No Coding

Drop Down list in Spreadsheet looks more professional. And it helps out to input some data quickly.
Good Spreadsheet has an option called “data Validation” which allows us to create a decent drop-down without any coding at all.

Google Sheets drop down list can be set up to manage and enter a lot of data with ease.

It can also be useful to avoid spelling mistakes in the sheets, so that discrepancy in the final calculation can be ignored.

We can use a drop down to track a lot of things, example a status of your work, whether completed, Ongoing or even rejected. Which can be instantly updated.

Google Sheets drop down looks trendy and the metrics can be maintained effortlessly when you are working with a huge number of team.

Create a Drop down List in Google Sheets

Step 1. Login into your Google Drive and open a Spreadsheet on which you would like to create a drop down menu.

For an instance, I had taken a spreadsheet and entered some random data.

Step 2. Enter some data in the next column “H” which you want to be shown in the drop down menu.

Go through the below image for better insights. (You can add this data to another sheet as well.

And if you don’t want to show that information or even hiding that column is possible, here I had added in the same sheet just for the demo).

Create A Drop down List In Google Sheets

Step 3. Now make the selection where you want the drop down to be created (Refer below image selected Column “B”)

Step 4. Navigate To Data >> Data Validation from the menu to create Google sheets drop down, it can also be accessed by right click on the selected area.

Create A Drop down List In Google Sheets

Step 5. A pop-window will appear now, asking for some details.

Cell Range: It is basically the range of where the dropdown will be created (leave it the same as it is) as we already made the selection before.

Criteria: There would be some categories in the criteria in drop down list, List from a range, List of items, number, text, data, custom formula. We can select any one of them according to our requirement.

Step 6. Here we are going to create a dropdown list with the selected range, so select the first option “List from the range.”

Step 7. Now Enter the range H2: H in the range column, with the data from which we want to create the drop down list in B column. (Select data range button can also be used to auto select the data, click and drag the desired column fields).

Create A Drop down List In Google Sheets

Note: “By selecting H2:H, we had selected the entire column, just in case going forward if we want to add some more data in the same column, which will be automatically get included in the drop down list. We should do it just to avoid going through this process again and again.

Step 8. Click on “Save” Button.

Step 9.Now you will be able to see the drop down list created for the selected area with the same data or names we have entered.

Create A Drop down List In Google Sheets

The coolest thing, as mentioned above, whenever we add some data in the H column, same will be reflected in the drop down list.

Check for the below image for better insights earlier Olivia and Sophia names were not there, as we have added in the H column it automatically can be seen in the drop down list as well.
Create A Drop down List In Google Sheets

Manual Process To Create Google Sheet Drop Down List

By choosing “List of items” from the Criteria category we can manually enter the names or any other information by separating with commas for creating drop down list.
Disadvantages creating a drop down manually – Everytime you want to add the data you have to go through the data validation process for the selected columns.
Create A Drop down List In Google Sheets
Google Spreadsheets are very robust and useful if used in the proper way. Those can dominate any similar tools present in the market. In fact, if you are well versed with some functions or coding process, you can make use of the Code Editor in it. Tons of functions can be added to do sort the data. And calling the data from the other sheets.

Subscribe To QuestionCage

Glad to see your Visit at QuestionCage!

One more step to connect ahead "Subscribe to Us" and get the updates to your inbox directly.

You have Successfully Subscribed to QuestionCage!