How to Insert a Dropdown List in Google Sheets

When creating a spreadsheet for data entry, consistency is crucial. If you have a column for “Project Status,” you do not want users typing “Done,” “Finished,” “Completed,” or “Complete.” This variation makes it impossible to accurately sort or filter the data later. To force users to choose from a predefined, standardized set of options, you should insert a dropdown list directly into the cells.

How to Create a Basic Dropdown List

Google Sheets makes it incredibly easy to add a dropdown menu and customize the available options.

1. Open your document in Google Sheets.
2. Click on the specific cell (or click and drag to highlight multiple cells) where you want the dropdown list to appear.
3. Click on Insert in the top menu bar.
4. Scroll down and select Dropdown.
5. A “Data validation rules” sidebar will slide out on the right side of your screen.

Configuring the Dropdown Options

Inside the sidebar, you will define the rules for the cell.

1. Under “Criteria,” ensure the dropdown menu is set to Dropdown.
2. Below that, you will see two default text boxes labelled “Option 1” and “Option 2.”
3. Click inside the text box and type your desired status (e.g., “In Progress”).
4. To assign a specific color to that status, click the grey circle to the left of the text box and select a color from the palette. This creates a highly visible visual cue.
5. Click the Add another item button to create additional choices (e.g., “Completed,” “On Hold”).
6. To remove an option, hover over it and click the trash can icon on the right.
7. Once you have added all your options, click the blue Done button at the bottom of the sidebar.

How to Remove a Dropdown List

If you no longer need the dropdown menu and want the cell to return to a standard text input field, you must remove the validation rule.

1. Click on the cell containing the dropdown list.
2. The “Data validation rules” sidebar should appear on the right. If it does not, click Data in the top menu and select Data validation.
3. In the sidebar, hover over the specific rule applied to that cell.
4. Click the trash can icon (Remove rule) to instantly delete the dropdown menu.

Tip: If you apply a dropdown to an entire column and later add new rows to the bottom of the sheet, you can easily copy the dropdown list by clicking a cell with the list, pressing Ctrl + C, clicking the empty cell, and pressing Ctrl + V.