Dropdowns – Sheets
A drop-down lists can greatly facilitate data entry. Add the power and convenience of a data drop down to Google Sheets in seven easy steps.
Add drop-down cells to enhance your spreadsheet in seven easy steps.
Create a dropdown list
- Open a spreadsheet in Google Sheets.
- Select the cell or cells where you want to create a drop-down list.
- Click Data and then Validation.
- Next to “Criteria,” choose an option:
- List from a range: Choose the cells that will be included in the list.
- List of items: Enter items, separated by commas and no spaces.
- The cells will have a Down [ ] Arrow. To remove the arrow, uncheck “Display in-cell button to show list.”
- If you enter data in a cell that doesn’t match an item on the list, you’ll see a warning. If you want people to only enter items from the list, choose “Reject input” next to “On invalid data.”
- Click Save. The cells will show a drop-down list. To change the color of a cell based on the option selected, use conditional formatting.
Change or delete a dropdown list
- Open a spreadsheet in Google Sheets.
- Select the cell or cells you’d like to change.
- Click Data and then Validation.
- To change the options listed, edit the items next to “Criteria.”
- To delete a list, click Remove validation.
- Click Save. If you change the contents of the range you’ve selected, the changes will be made in the list automatically.
Walkthrough
½×
Video
HTML5