How to Create Drop Down Options in Google Sheets ?
|
docs.google
|
Jul 17, 2024
|
![document-icon](https://kopist-zehntech.s3.ap-south-1.amazonaws.com/icon/1721206078blob.png)
13 Steps
Drop-down lists are a powerful tool in Google Sheets that allow you to create predefined lists of options for users to select from. This feature is particularly useful when you want to standardize data entry, prevent errors, or make it easier for users to choose from a set of options. In this document, we'll guide you through the simple process of creating drop-down options in your Google Sheets spreadsheet.
How to Create Drop Down Options in Google Sheets ?
![document-icon](https://kopist-zehntech.s3.ap-south-1.amazonaws.com/icon/1721206078blob.png)
13 Steps
1
Navigate to https://docs.google.com/spreadsheets/
2
Go to the "Menu" and Click on "Data".
![Merged Image](https://kopist-zehntech.s3.ap-south-1.amazonaws.com/documents/5991/step_38502_1732599962.png)
3
Select "Data Validation".
Adding the drop down to google sheets requires adding a data validation.
![Merged Image](https://kopist-zehntech.s3.ap-south-1.amazonaws.com/documents/5991/step_38503_1732599963.png)
4
Click the "Data Range" icon.
![Merged Image](https://kopist-zehntech.s3.ap-south-1.amazonaws.com/documents/5991/step_38504_1732599963.png)
5
Select the "Cells" you'd like to add your dropdown.
![Merged Image](https://kopist-zehntech.s3.ap-south-1.amazonaws.com/documents/5991/step_38505_1732599963.png)
6
Click "OK"
![Merged Image](https://kopist-zehntech.s3.ap-south-1.amazonaws.com/documents/5991/step_38507_1732599963.png)
7
Click the "Criteria" field.
And select the dropdown
![Merged Image](https://kopist-zehntech.s3.ap-south-1.amazonaws.com/documents/5991/step_38508_1732599964.png)
8
Click the "Value" field.
And add their own items
![Merged Image](https://kopist-zehntech.s3.ap-south-1.amazonaws.com/documents/5991/step_38509_1732599964.png)
9
Click the "Value" field.
And add their own items
![Merged Image](https://kopist-zehntech.s3.ap-south-1.amazonaws.com/documents/5991/step_38510_1732599964.png)
10
Click the "Add Another Item".
Add one more item in your list
![Merged Image](https://kopist-zehntech.s3.ap-south-1.amazonaws.com/documents/5991/step_38512_1732599965.png)
11
Click the "Value" field.
And add their own items
![Merged Image](https://kopist-zehntech.s3.ap-south-1.amazonaws.com/documents/5991/step_38513_1732599965.png)
12
Click "Done"
![Merged Image](https://kopist-zehntech.s3.ap-south-1.amazonaws.com/documents/5991/step_38514_1732599965.png)
13
Click the "Dropdown" icon.
You have a list of items in google sheets. select the drop down icon to test your list.
![Merged Image](https://kopist-zehntech.s3.ap-south-1.amazonaws.com/documents/5991/step_38515_1732599965.png)