How to add a dropdown list in Google Sheets

How to add a dropdown list in Google Sheets

Watch on Guidde

How to add a dropdown list in Google Sheets

This guide will show you how to add a dropdown list in Google Sheets.

Go to docs.google.com

1. Select a cell

Select the cell where you want to create a dropdown list

Select a cell

2. Click "Insert"

In the menu bar, click on "Insert".

Click 'Insert'

3. Select "Dropdown"

From the dropdown menu, select "Dropdown".

Select 'Dropdown'

4. Click "Add another item"

To add more options, click "Add another item".

Click 'Add another item'

5. Fill "option 3"

Enter "option 3" in the text field.

Fill 'option 3'

6. Click "Done"

Click "Done" to save the dropdown list

Click 'Done'

7. Click on the cell

Click on the cell to see all the dropdown list options

Click on the cell

8. Select a list item

Select a list item from the dropdown list

Select a list item

In this guide, you learned how to add a dropdown list in Google Sheets

Open in App