Dropdown menus in Google Sheets - Step-by-Step Guide

Introduction

Dropdown menus let you pick a value from a list inside a cell. This helps avoid typing mistakes and makes data entry faster and clearer.

When you want to limit answers to specific choices, like Yes or No.

When filling out a form where only certain options are allowed, like selecting a country.

When you want to make a checklist with fixed items to choose from.

When you want to create a menu for users to select product categories.

When you want to avoid errors by restricting input to valid options.

Steps

Step 1: Select the cell or cells

- Spreadsheet grid

The chosen cells are highlighted

💡 You can select multiple cells by clicking and dragging

Step 2: Click Data

- Top menu bar

A dropdown menu appears

Step 3: Select Data validation

- Data dropdown menu

The Data validation dialog opens

Step 4: Click the Criteria dropdown

- Data validation dialog

A list of criteria options appears

Step 5: Choose List of items

- Criteria dropdown

A text box appears to enter items

Step 6: Type your list items separated by commas

- List of items text box

Items are set as dropdown options for the selected cells

💡 For example, type: Yes,No,Maybe

Step 7: Click Save

- Data validation dialog

Dropdown menus appear in the selected cells

Before vs After

Before

Cell A1 is empty and can accept any text or number

After

Cell A1 shows a dropdown arrow and only allows selection of Yes, No, or Maybe

Settings Reference

Criteria

📍 Data validation dialog

Defines what kind of data is allowed in the cell

Default: List of items

Show dropdown list in cell

📍 Data validation dialog

Shows or hides the dropdown arrow in the cell

Default: Checked

On invalid data

📍 Data validation dialog

Controls what happens if someone enters data not in the list

Default: Show warning

Appearance

📍 Data validation dialog

Shows a message to help users enter correct data

Default: Hide validation help text

Common Mistakes

Typing list items without commas between them

Google Sheets does not recognize separate items without commas

Separate each item with a comma, like Yes,No,Maybe

Not selecting the correct cells before applying data validation

Dropdown menus will only appear in the selected cells

Always select all cells where you want the dropdown before setting data validation

Forgetting to click Save after setting criteria

Changes will not apply until you save

Click Save to apply the dropdown menu to the cells

Summary

Dropdown menus let you pick from a list inside a cell to avoid typing errors.

You create them using Data > Data validation and choosing List of items.

Remember to separate items with commas and save your settings.