How To Add a Drop Down List in Google Sheets

In Google Sheets, you can add a drop-down list using the “Data validation” feature. Here’s how you can do it:

1. Open your Google Sheets document:
   • Go to Google Sheets and open the spreadsheet where you want to add a drop-down list.
2. Select the cell or cells where you want the drop-down list:
   • Click on the cell or drag to select a range of cells where you want the drop-down list.
3. Go to “Data” in the top menu:
   • Click on the “Data” menu in the top menu bar.
4. Select “Data validation”:
   • In the “Data” menu, hover over “Data validation” and click on “Data validation” in the submenu.
5. Set up the data validation:
   • In the “Criteria” section, choose “List of items” from the drop-down menu.
   • In the “List of items” field, enter the items you want in the drop-down list, separated by commas.
6. (Optional) Adjust other settings:
   • You can customize other settings such as allowing or disallowing invalid entries, showing a warning for invalid entries, etc.
7. Click “Save”:
   • Click on the “Save” button to apply the data validation.

Now, the selected cell or cells will have a drop-down arrow, and users can choose from the items you specified in the data validation settings.

Note: If you want to edit or remove the data validation later, you can click on the cell, go back to “Data” > “Data validation,” and make the necessary changes.

This method allows you to create drop-down lists in Google Sheets, providing a way to control and restrict the input options in a specific range of cells.