How to Add Drop Down in Google Sheets

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.

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

6. 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.