How to Add Drop Down in Google Sheets

Image Source - Google | Image by androidauthority

Follow these steps to add drop down in Google sheets in your computer, android, and IOS devices.

How to Add Drop Down in Google Sheets in computer

  1. Open the spreadsheet in Google Sheets, in which you wanted to add a drop-down list.
  2. Select the cell or multiple cells where you want to create a drop-down list.
  3. After selecting cells, click on data > data validation.

  1. Click on List from a range
  2. Enter the list of items by separating each item by a comma without any space. Then click on the Save

  1. The cells will show the down arrow. Click on the arrow then you will be able to see the items you have entered.

How to Add Drop Down in Google Sheets

  1. Open your spreadsheet in Google Sheet.
  2. Select the cell or cells you would like to change.
  3. Click on Data > Data validation.
  4. To delete the drop-down list, click on Remove validation.

What do you think?

164289 points
Upvote Downvote

Written by Hardik Tokas

Hardik Tokas is a law graduate from GGSIPU, Delhi. He is an analytical thinker, an active team player who is proactive in legal research and writing, and has highly motivated enthusiasm for business, start-ups, and entrepreneurship. He has the vision to deliver excellent support to the visionary entrepreneurs and educate them in all legal compliances of applicable laws considering their business level and long term growth. He is a goal-oriented professional and a valuable member of the organization.


Leave a Reply

Your email address will not be published.



What Constitutes a Legal Contract

How to Add Gmail Account in iPhone