How To Add A Dropdown In Google Sheets

How To Articles

When working with Google Sheets, adding dropdown menus can be incredibly useful for data validation and user-friendly input options. I’ll walk you through the steps to add a dropdown in Google Sheets.

Creating a Dropdown Menu

To add a dropdown menu, first select the cell or range of cells where you want the dropdown to appear. Then, navigate to the Data tab in the menu at the top of the page. Click on Data Validation from the dropdown menu.

From the criteria dropdown, choose List of items. Here, you can input the items you want to appear in the dropdown. For example, if I’m creating a dropdown for selecting project status, I might input options like “Not Started”, “In Progress”, and “Completed”.

After entering the list of items, you can choose whether to show a dropdown arrow in the cell. Click Save, and the dropdown menu will appear in the selected cell(s).

Personal Touch

For me, using dropdowns in Google Sheets has been a game-changer. It not only adds a professional look to my spreadsheets, but also helps streamline data entry and reduces the chances of errors.

Customizing the Dropdown

If you want to make changes to the existing dropdown, simply click on the cell with the dropdown, and then click Data Validation from the Data tab. Here, you can modify the list of items, the cell range, and other settings as needed.

Using the Dropdown in Formulas

One of the great things about dropdown menus is that you can use them in formulas. For instance, you can use the dropdown selection as a criterion in functions like IF and VLOOKUP. This adds another layer of functionality and automation to your spreadsheet.


Adding dropdown menus in Google Sheets is a simple yet powerful feature that enhances the usability and organization of your spreadsheets. Whether it’s for project management, data entry, or any other use case, dropdowns can make your Sheets more efficient and user-friendly.