Wednesday, June 7, 2023
HomeTechnologyHow to add a drop down list in Google Sheets

How to add a drop down list in Google Sheets

Getty Photos/iStockphoto

Are you a daily Google Sheets person? If that’s the case, including drop-down lists to your workflow might prevent numerous time. That is very true should you’re constructing a spreadsheet that requires deciding on from a number of choices again and again. It is one factor if you need to kind one thing a few occasions, however when you need to kind those self same gadgets repeatedly, that repetition provides up. 

Additionally: add conditional formatting to a Google Sheets drop-down listing

Or possibly you are sharing the brand new Sheet with different customers, and also you need to restrict or simplify the info entry course of as a lot as attainable. 

Ergo… drop-downs.

Making a drop-down in Google Sheets is definitely a lot simpler than you may assume, due to a useful, built-in GUI. Let me present you two totally different strategies for caring for this useful job.

Additionally: What’s Google Bard? This is all the things it is advisable to know

And thus, with out additional ado, let’s get to creating.


The one factor you may have to comply with alongside is a Google account and the power to create a brand new Sheet inside both Google Drive or Google Docs. That is it, let’s get to work.

Replace: The best Sheets drop down methodology

Since scripting this piece, Google has made including drop downs even simpler than it was. 

Should you right-click a cell in your Google sheet, you may see an choice labeled Dropdown. Click on that. 

The Dropdown entry in the Google Sheets cell right-click menu.

Making a drop down in a Google Sheet is even simpler now.

Picture: Jack Wallen/ZDNET

A sidebar will open on the proper facet of the window, the place you’ll be able to add the choices that can seem within the drop down. Ensure that to call every choice, choose a coloration for it, and click on Add One other Merchandise so as to add to the listing.

The Sheets drop-down configuration pane.

You too can apply the drop right down to a spread of cells.

Picture: Jack Wallen/ZDNET

Should you broaden the Superior Choices part, you’ll be able to allow assist textual content, act on invalid knowledge, and alter the show type for the drop down.

The Google Sheets drop-down advanced options.

Should you allow Assist Textual content, you’ll be able to then kind the textual content in a textual content discipline that can seem.

Picture: Jack Wallen/ZDNET

After configuring the drop down, click on Carried out and it is prepared to make use of.

Creating your Sheets drop down the outdated means

Log into your Google Account and head to Google Drive. Click on New > Google Sheets to create the spreadsheet.

Click on on the cell within the spreadsheet you need to home the drop-down, then click on Knowledge > Knowledge Validation.

The Google Sheets Data menu.

The Knowledge menu inside Google Sheets contains the software we have to create a drop down listing.

Picture: Jack Wallen/ZDNET

Within the Knowledge Validation window, you may need to choose Listing of Objects from the Standards drop-down after which enter the gadgets (separated by a comma) within the textual content discipline to the correct of that.

The Google Sheets Data Validation window.

Creating the brand new drop-down listing in Google Sheets.

Picture: Jack Wallen/ZDNET

You may additionally test the field related to Present Validation Assist Textual content, as that can give the person assist; ought to they enter invalid knowledge, they are going to get a warning.

After configuring your drop down listing, click on Save to save lots of the knowledge. 

Utilizing the drop down listing

After creating the drop down listing, it’s going to seem in a sheet with a downward-pointing arrow. All a person has to do is click on the drop down and choose from the choices you’ve got made accessible (Determine 3).

An example of a Google Sheets drop-down list.

Our new drop down listing in motion.

Picture: Jack Wallen/ZDNET

You may additionally think about including a cell both above or on to the left of the drop down and add content material to that new cell indicating what the drop down is used for.

An explanitory cell added for a Google Sheets drop-down list.

Add a cell that explains the contents of your drop-down to make it simpler for customers.

Picture: Jack Wallen/ZDNET

And that is all there’s to including a drop down listing in Google Sheets. And right here you thought it was going to be a sophisticated job. Subsequent time round, we’ll learn to add conditional formatting to your drop-down lists for much more spreadsheet enjoyable.




Please enter your comment!
Please enter your name here

Most Popular

Recent Comments