Save for Later
This guide was created with Scribe in
14 seconds.
Sign in and create your own!
How do I add a drop-down list to a Google Sheets spreadsheet?
Drop-down lists are a great way to ensure data accuracy and consistency in a Google Sheets spreadsheet. They can be used to limit the range of values that can be entered into a cell, making it easier to quickly identify and correct any errors. Additionally, drop-down lists can be used to quickly filter and sort data, allowing you to quickly find the information you need. Knowing how to add a drop-down list to a Google Sheets spreadsheet can help you save time and ensure accuracy in your data.
Grace Everwood
|
0 step
|
14 seconds
Google Account
1
Go to [https://sheets.google.com](https://sheets.google.com) and open the spreadsheet you want to add a drop-down list to.
2
Click the cell where you want to add the drop-down list.
3
Click the “Data” tab at the top of the page.
Zoom Saved
4
Click the “Data Validation” button.
Zoom Saved
5
In the “Criteria” section, select “List from a range” from the drop-down menu.
6
In the “Range” field, enter the range of cells that contain the list of items you want to appear in the drop-down list.
Zoom Saved
7
Click the “Save” button.
Zoom Saved
Was this Scribe helpful?
Save this document for future reference.
Save for Later
Have something to say?
Create an account to leave messages for the author to see!
Create an account
Feedback
This Scribe is in tip-top shape!
Leave feedback if there are any issues with this Scribe