What a drop-down list does and why you'd use one

A drop-down list in Google Sheets is a cell that shows a small arrow when you click it. Click the arrow and you see a list of choices you set ahead of time. The person filling out the sheet picks from that list instead of typing. This prevents typos, keeps data consistent, and makes the sheet faster to fill.

Drop-downs are useful when you have a repeating set of answers — department names, yes/no/maybe, product codes, status values like "pending" or "complete". Anyone using the sheet picks from your list instead of inventing their own spelling or abbreviation.

Google Sheets calls this feature data validation. It's built in and free. You don't need any add-ons or special setup beyond a few clicks.

Key Takeaways

  • Select the cell or cells where you want the drop-down, then open the Data menu and choose Data validation to set it up.
  • You can type your list directly into the validation box, paste a list from elsewhere, or point to cells in your sheet that contain the list.
  • The drop-down arrow only appears when someone clicks the cell — it's not visible until then.
  • You can set the drop-down to reject entries that aren't on your list, or allow them but show a warning.

Select the cells that will have the drop-down

Click the cell where you want the first drop-down. If you want drop-downs in multiple cells, select them all at once. You can click one cell, then hold Shift and click another to select a range. Or click a cell and drag down to select several in a column.

If you want every cell in a column to have a drop-down (like a whole "Status" column), click the column letter at the top. The entire column turns blue, and the drop-down will explore to all cells in it.

You can also select cells that aren't next to each other. Click one cell, then hold Ctrl (or Cmd on Mac) and click other cells. They'll all highlight, and the drop-down will explore to all of them at once.

Open Data validation and choose your list source

With your cells selected, click the Data menu at the top. A dropdown menu appears. Click Data validation. A box opens on the right side of your screen.

The box shows a dropdown that says "List of items" by default. This is what you want. Below it, you'll see a text field. This is where you tell Google Sheets what choices to show.

You have three ways to create your list. The simplest is to type the items directly, separated by commas. Type Pending, In Progress, Complete and Google Sheets will create three choices. You can also paste a list from another document — just paste it into that field and Google Sheets will split it into separate items.

The third way is to point to cells in your sheet that already contain the list. Click the field, then click the small icon that looks like a grid or spreadsheet. Now click and drag to select the cells that hold your list. Google Sheets will use those cells as your choices.

Decide what happens if someone enters something else

Below the list field, you'll see a checkbox that says "Show warning" or "Reject input". By default, "Show warning" is checked. This means if someone types something that's not on your list, Google Sheets shows a message but lets them enter it anyway.

If you want to force people to pick from your list and block anything else, uncheck "Show warning" and check "Reject input" instead. Now if someone tries to type a value that's not on the list, Google Sheets will refuse it and show an error message.

For most sheets, "Show warning" is the safer choice. It catches typos and keeps data mostly clean without frustrating people who have a legitimate reason to enter something different.

Add a custom message so people know what to do

Below the warning or rejection setting, you'll see a field that says "Show validation help text". Check this box if you want to add instructions. Type a message like "Choose a status from the list" or "Select your department name".

This message appears when someone clicks the cell, right above the drop-down arrow. It's optional but helpful if your sheet is used by people who aren't familiar with it.

You can also add a title for the message in the field above it. Keep both short — one or two sentences is enough.

Click Done and test your drop-down

Once you've set up your list and chosen your settings, click the Done button at the bottom right of the validation box. The box closes and you're back to your sheet.

Click one of the cells where you added the drop-down. A small arrow appears on the right side of the cell. Click the arrow and your list of choices appears. Click one to select it. The cell now shows that choice.

If you selected multiple cells, the drop-down works in all of them. If you selected a whole column, every cell in that column now has the drop-down, even cells you add later.

Edit or remove a drop-down later

To change the list, click any cell that has the drop-down. Open the Data menu again and click Data validation. The box opens showing your current settings. Edit the list, change the warning setting, or update the help text. Click Done when you're finished.

To remove a drop-down entirely, select the cells, open Data validation, and click the trash icon at the bottom right of the box. Click Done. The drop-down is gone but your data stays.

If you used cells in your sheet as the source for your list and you want to change those cells later, the drop-down updates automatically. You don't have to redo the validation.

Frequently Asked Questions

Can I use a drop-down list from another sheet in the same file?

Yes. When you click the grid icon to select cells, you can click the sheet tab at the bottom to switch to a different sheet, then select the cells there. Google Sheets will use those cells as your list, even though they're on a different sheet.

What if I want to add a new choice to my drop-down list later?

If you typed the list directly, you have to edit the validation again and add the new item. If you pointed to cells in your sheet, just add the new item to those cells — the drop-down updates on its own.

Can I make a drop-down that shows different lists depending on what's in another cell?

Google Sheets doesn't have built-in dependent drop-downs, but you can use a formula-based approach with FILTER or QUERY. This is more advanced and requires some knowledge of formulas. For most sheets, a single list works fine.

Why doesn't the drop-down arrow show up when I click the cell?

Make sure you actually created the data validation. Click the cell, open Data menu, and check Data validation. If the box is empty, the validation wasn't saved. Set it up again and click Done. Also check that you're not in edit mode — if you're typing in the cell, the arrow won't appear until you press Enter.

Can I copy a drop-down to other cells?

Yes. Click a cell that has the drop-down you want to copy. Press Ctrl+C (or Cmd+C on Mac) to copy. Select the cells where you want the same drop-down and press Ctrl+V (or Cmd+V). The validation copies to all selected cells.