What a dropdown list does and why you'd use one

A dropdown list in Google Sheets lets you click a cell and choose from a set list of options instead of typing. The person filling out the sheet clicks the cell, sees a small arrow, and picks from the choices you set. This prevents typos, keeps data consistent, and makes it faster to fill in repeated information like department names, status values, or product codes.

Dropdowns are most useful when the same values appear over and over in a column — like "Approved," "Pending," "Rejected" for a status tracker, or "North," "South," "East," "West" for a sales region sheet. They also work well when you want to control what gets entered so that later sorting and filtering actually work the way you expect.

Key Takeaways

  • Open the Data Validation tool from the Data menu, select the cells where you want dropdowns, and choose "List of items" or "List from a range."
  • Type your options directly into the validation box, separated by commas, or point to cells elsewhere in the sheet that contain your list.
  • Turn on "Show dropdown arrow" so users see the arrow icon that signals a dropdown is available in that cell.
  • Use a separate column or hidden area to store your master list if the same options appear in multiple dropdowns across the sheet.
  • Test the dropdown by clicking the cell and confirming the arrow appears and the choices show up.

Creating a dropdown from a typed list

The fastest way to make a dropdown is to type your options directly into Google Sheets. First, click the cell or cells where you want the dropdown to appear. If you want the same dropdown in multiple cells, select the whole range — for example, click cell A2, then hold Shift and click A10 to select A2 through A10.

Open the Data menu at the top and click "Data validation." A panel will open on the right side. Under "Criteria," click the dropdown that says "List of items." Type your options into the box below, separated by commas. For example, type Approved, Pending, Rejected (with or without spaces after the commas — Google Sheets handles both). Check the box next to "Show dropdown arrow" so the arrow icon appears in the cell. Click Done.

The dropdown is now live. Click any of the cells you selected, and you'll see a small arrow on the right side of the cell. Click the arrow and your options appear as a list. Select one and it fills the cell.

Creating a dropdown from a list elsewhere in your sheet

If your options already exist in cells — for example, a list of department names in column F — you can point the dropdown to those cells instead of retyping them. This is useful because if you update the list later, the dropdown updates automatically.

Select the cells where you want the dropdown. Open Data > Data validation. Under Criteria, click the dropdown and choose "List from a range." In the box that appears, type the range of cells that hold your options. For example, if your department names are in cells F2 through F8, type F2:F8. Check "Show dropdown arrow" and click Done.

Now when you click the dropdown arrow, it shows whatever values are currently in that range. If you add a new department to column F later, it automatically appears in the dropdown without you having to edit the validation rule.

Controlling what happens when someone enters the wrong value

By default, Google Sheets warns the user if they type something that's not on the dropdown list, but it still lets them enter it. If you want to be stricter — for example, in a form where only specific values are allowed — you can change this behavior in the Data validation panel.

After you set up your list, look for the option that says "If invalid: Show warning" or "If invalid: Reject input." Choose "Reject input" if you want to prevent any value that's not on the list from being entered. Choose "Show warning" if you want to let people type something else but alert them that it's not a standard choice. You can also add a custom message that explains what values are allowed.

Using dropdowns across multiple columns

You often need the same dropdown in different columns — for example, a "Status" dropdown in column C and a "Priority" dropdown in column D. You can set them up separately, or you can create them all at once by selecting multiple columns.

To set up different dropdowns in different columns, select just the cells in the first column, create the dropdown, then repeat the process for the next column. To set up the same dropdown in multiple columns at once, select all the cells you want (for example, C2:C100 and D2:D100 together by holding Ctrl and clicking each range), then create one validation rule — it applies to all selected cells.

Organizing your dropdown lists in a hidden area

If you have many dropdowns or the lists are long, storing all your options in one visible place and then referencing them keeps the sheet cleaner. Create a separate area — often at the far right or bottom of the sheet — where you list all your options. You can even hide those columns so they don't clutter the view.

For example, put all your department names in column Z, rows 1 through 20. Create your dropdown using the range Z1:Z20. Then right-click column Z, click "Hide column," and the list disappears from view but the dropdown still works. If you ever need to update the list, unhide the column, make your changes, and hide it again.

Testing and troubleshooting your dropdown

After you create a dropdown, click the cell and look for the small arrow on the right side. If you don't see it, open Data validation again and make sure "Show dropdown arrow" is checked. Click the arrow — your options should appear as a list. Select one and confirm it fills the cell correctly.

If the dropdown doesn't appear or shows the wrong options, check that you entered the range correctly (no typos in the cell references) and that the cells you pointed to actually contain your list. If you used "List of items" and typed the options, make sure they're separated by commas. If nothing works, delete the validation rule and create it again — sometimes a fresh start is faster than debugging.

Frequently Asked Questions

Can I use a dropdown that pulls from a list in a different sheet?

Yes. In the Data validation panel, use "List from a range" and type the sheet name followed by the range, like SheetName!A1:A10. Google Sheets will pull the options from that other sheet and update them automatically if you change the list.

What if I want to allow people to enter values not on the dropdown list?

Set up the dropdown with "Show warning" instead of "Reject input." This displays the dropdown arrow and suggests your list, but lets users type something else if they need to. It's useful for forms where most entries are standard but occasional exceptions exist.

Can I copy a dropdown from one cell to another?

Yes. Click the cell with the dropdown, copy it (Ctrl+C or Cmd+C), then select the cells where you want the same dropdown and paste. Google Sheets copies the validation rule along with any content. If the dropdown references a range, it adjusts the range automatically based on where you paste.

How do I remove a dropdown from a cell?

Click the cell, open Data > Data validation, and click the trash icon in the bottom right of the panel. The dropdown disappears but the value in the cell stays. If you want to remove dropdowns from many cells at once, select them all, then delete the validation rule.

Can I make a dropdown that shows different options based on what's in another cell?

Google Sheets doesn't have built-in dependent dropdowns, but you can use a workaround with formulas and named ranges if you're comfortable with more advanced setup. For most everyday sheets, it's simpler to use separate dropdowns in different columns and let users choose from each independently.