Data validation is one of our favorite tools in Google Spreadsheets, because it gives the Spreadsheet owner even more control over the data that’s entered. But, did you know that you can create custom drop-down menus with data validation?
This feature is very useful for controlling what collaborators can enter into cells and for allowing you to enter values very quickly, by simply typing the first character or two of a value and then pressing Enter.
The video above will guide you through the following steps. To see the sample document featured in the video, click here. You can create an editable copy by clicking ‘File’, then ‘Make a copy’.
- Create or open a Google Spreadsheet.
- Create a new worksheet and name it Values.
- Enter the values you want to have appear in your drop-downs.
- Go back to the original worksheet and highlight the cells where you’d like the drop-downs to appear.
- Right click and select Data Validation.
- Set Criteria to be “”List from a range”” and select the values you entered on the Values worksheet.
- Select Reject Input if you’d like to prevent any value not in your list.
- Enter help text if desired (optional).
- Click Save and return to the original worksheet.
The drop-down icons appear in the cells. You can either click the down arrow to select from the list, or you can begin typing a value in the cell.