Dropdown lists in Google Sheets ensure data consistency and make data entry much faster by forcing users to select from predefined options.
How to Create a Dropdown
- Select the cell or column where you want the dropdown to appear.
- Click on Data in the top menu and select Data validation.
- Click + Add rule.
- Under the Criteria section, choose Dropdown and type your options into the text boxes.
- Click Done.