Tech Tip – Creating Drop-down Lists in Google Sheets

June 30, 2021 by Mike Knight

Tech Tip – Creating Drop-down Lists in Google Sheets

If you use Google Sheets and need to simplify data-entry, adding dropdown lists can really help. Here’s how to add them:

– In Google Sheets, select the cell where you want the dropdown list.

– Click on ‘Data’, select ‘Data Validation’, and select ‘List of items’.

– In the field that loads, type the items you want to include in the dropdown list, separated by commas, and select ‘Save’.