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, and tapping that arrow reveals a set of choices you've already written in. Instead of typing the same words over and over — or watching someone else type them wrong — you pick from a list. The person filling out the sheet sees only the options you want them to see.

Drop-down lists solve a real problem: they stop typos, they make data consistent, and they speed up data entry. If you're tracking a project status (On Track, At Risk, Complete), a budget category (Rent, Utilities, Supplies), or a person's name from a fixed team, a drop-down list means everyone enters it the same way. When you later sort or filter that column, all the "On Track" entries actually group together instead of scattering because someone typed "on track" or "ON TRACK" instead.

They also work across shared sheets. If you share a Google Sheet with your team and add a drop-down list to a column, everyone who opens that sheet sees the same choices and can only pick from them.

Key Takeaways

  • Select the cell or cells where you want the drop-down list, then open the Data menu and choose Data Validation to set it up.
  • You can type your list choices directly into the validation window, or point Google Sheets to a range of cells that already contain your list.
  • The drop-down arrow appears in the cell only when someone clicks on it, and they can only pick from the choices you set — they cannot type something else unless you allow it.
  • You can copy a cell with a drop-down list to other cells, and the validation rules copy along with it.
  • If you change your list of choices later, you update it in one place and the change shows up everywhere that drop-down is used.

Select the cells where you want the drop-down list

Open your Google Sheet and click on the cell where you want to add the drop-down list. If you want the same drop-down in multiple cells — for example, an entire column — click the first cell, then hold Shift and click the last cell in the range you want. Or click the column header letter to select the whole column.

You can also select cells that are not next to each other. Click the first cell, then hold Ctrl (or Cmd on a Mac) and click each additional cell you want to include. All of them will get the same drop-down list when you finish.

Open Data Validation and choose your list type

With your cells selected, click the Data menu at the top of the sheet, then click Data Validation. A window will open on the right side of your screen.

In the dropdown that says "Criteria," you'll see several options. For a straightforward list, click on List of items. This is the most common choice and the easiest to set up.

If your list of choices already exists in cells somewhere else in your sheet — for example, you have a list of team member names in column E — you can instead choose List from a range. This way, if you add a new team member to that list later, the drop-down automatically includes them without you having to edit the validation rule.

Type your list or point to a range

If you chose List of items, you'll see a text box that says "Items." Click in that box and type your choices, separated by commas. For example: On Track, At Risk, Complete. You can also press Enter after each item instead of using commas — Google Sheets accepts both.

If you chose List from a range, click in the text box and type the range of cells that contain your list. For example, if your choices are in cells E2 through E10, type E2:E10. You can also click the small range selector icon (it looks like a grid) next to the text box, then click and drag to select the cells on your sheet.

Make sure your list doesn't have blank cells in the middle. If you have names in E2, E3, E4, then a blank cell in E5, the drop-down will stop at E4 and won't include anything below the blank.

Set what happens if someone types something that's not on the list

Below your list, you'll see a checkbox that says "Show dropdown arrow." Leave this checked — it's what makes the arrow appear in the cell so people know a list is there.

Further down, there's a section called "Invalid data" with a dropdown menu. This controls what happens if someone tries to type something that's not on your list. The default is "Show warning," which lets them type it anyway but shows a message saying it's not a valid choice. If you want to force people to pick only from your list and prevent any other entry, change this to Reject input. This is stricter but ensures your data stays clean.

Finish and test your drop-down

Click the Done button at the bottom right of the validation window. The window will close, and your cells now have drop-down lists.

Click on one of the cells you just set up. You should see a small downward-pointing arrow appear on the right side of the cell. Click that arrow, and your list of choices will appear. Click any choice to select it. The cell will now show that choice, and the arrow will disappear until you click the cell again.

If you don't see the arrow, make sure you didn't uncheck "Show dropdown arrow" in the validation settings. Go back to Data Validation and check that box.

Copy a drop-down list to other cells

Once you've created a drop-down in one cell, you can copy it to other cells without setting up the validation again. Click the cell with the drop-down, then press Ctrl+C (or Cmd+C on a Mac) to copy it. Select the cells where you want the same drop-down, then press Ctrl+V (or Cmd+V) to paste. The validation rule copies along with the cell.

This also works if you select a range of cells with drop-downs and copy them all at once. The validation rules stay attached to each cell.

Frequently Asked Questions

Can I change the list of choices after I've set up the drop-down?

Yes. If you used "List of items," go back to Data Validation, click on the cell, and edit the list in the "Items" box. If you used "List from a range," the choices update automatically whenever you change the cells in that range — you don't have to touch the validation rule at all.

What if I want the drop-down to show different lists depending on what's in another cell?

Google Sheets doesn't have a built-in way to do this, but you can use a feature called Custom formula is in Data Validation combined with a helper column. This is more advanced and usually requires a formula. For most everyday uses, a single fixed list works better.

Can someone delete the drop-down list I created?

If you share the sheet with edit access, they can remove the validation rule by selecting the cell and going to Data Validation, then clicking Delete. If you want to prevent this, you can protect the sheet or specific cells so only you can edit them. Go to Data > Protect Sheets and Ranges to set this up.

Does the drop-down list work on mobile phones?

Yes, but the experience is slightly different. On a phone, tapping a cell with a drop-down shows the list as a popup menu instead of a small arrow. The choices work the same way — tap one to select it.

Can I use a drop-down list with a formula?

Yes. You can put a formula in a cell and also add data validation to that cell. The formula runs first, and the drop-down appears in the same cell. This is useful if you want a cell to show a calculated value but also let someone override it by picking from a list.