How To Create Drop Down Google Sheets. We first highlight the cells where we want the list to appear and in the Menu select Data Data validation. In the case of Google Sheets you can pull in your drop-down.
From the Criteria drop-down choose either List From a Range or List of Items. Creating a drop-down list in Excel is fairly easy. In the case of Google Sheets you can pull in your drop-down.
Select the cells that have the fruits A2A5.
Next to Criteria choose an option. Go to Data Named Ranges. Next to Criteria choose an option. In the Data Validation dialog box please do the following operations.