How to create an in-cell dropdown list in Google Sheets

[.blog-callout]

TL;DR

• Select the cells, go to Insert > Dropdown, add your options, and click Done to create an in-cell dropdown list in Google Sheets.
• Dropdowns cut down on typos and keep your data consistent, but they don't solve permissions, automation, or multi-user access.
• Once your sheet needs real user roles, workflows, or a proper interface, that same dropdown logic becomes a select field you can build on top of in a tool like Softr. [.blog-callout]

An in-cell dropdown list in Google Sheets restricts what a cell can contain to a predefined set of options. Instead of letting anyone type "In Progress," "in progress," or "WIP" into the same status column, you give them a list to pick from. That keeps your data clean and consistent, which matters a lot once you start filtering, sorting, or building reports on top of it.

Below is a step-by-step guide to setting one up. Toward the end, we'll also cover what to do when a spreadsheet dropdown stops being enough, and your sheet starts acting like it wants to be an app.

Select the cells to which you want to add the in-cell dropdown list

Select the cells you want to restrict to a fixed list of options. This can be a single cell, a full column, or a custom range.

Insert the in-cell dropdown list

At the top, click on the Insert menu and then on Dropdown.

Add options to the in-cell dropdown list

On the Data validation rules panel, in the "Criteria" section, type the options you want to add to your in-cell dropdown list. For illustrative purposes, we chose "Option 1" and "Option 2," but you can choose whatever text you want, and click on Add another item to add more options. Once you're done, click on Done.

Customize the in-cell dropdown list

The appearance of your in-cell dropdown list can be modified by changing the color of the cells based on the selected option, and by changing its display style. Let's look at each option.

Change the color of cells based on the selected option

You can make a cell's color change automatically based on which option is selected. On the Data validation rules panel, change the color of each option by clicking on the circle to the left of it.

Change the display style of the in-cell dropdown list

Google Sheets offers three display styles for dropdown lists:

• Chip, which displays the options as small, rectangular buttons.
• Arrow, which displays the options with a down arrow.
• Plain text, which displays the options as plain text.

Save the in-cell dropdown list

Once you've finished setting up your in-cell dropdown list, click Done, found at the bottom of the Data validation rules panel. This saves your setup and applies the dropdown to your selected cells.

When a dropdown isn't enough anymore

A dropdown list solves one specific problem: inconsistent data entry. It doesn't help once your spreadsheet needs to do more, like restrict who can see or edit which rows, notify someone when a status changes, or give clients and vendors their own view instead of a raw sheet full of formulas.

If you can build a Google Sheets GUI on top of your spreadsheet, the same "select from a list" logic becomes a select field: an option you configure once in your data structure, then reuse across every table, form, and view connected to it. Softr Databases support select fields the same way, but they're also tied into permissions, Softr Workflows, and database AI agents that can set a value automatically instead of leaving it to whoever fills out the row.

You can still connect directly to your existing Google Sheet if you're not ready to move your data, or you can bring your data into a native Softr Database once you outgrow the spreadsheet entirely. Either way, you keep the same dropdown-style consistency, just with an actual interface, user roles, and automation layered on top.

"I found it useful to switch from Airtable's backend to Softr's internal database to avoid API limits. I was able to replace a WordPress site and a management system made in Excel." - Marco D., .NET Analyst Developer, G2 review

Build past the spreadsheet, not around it

Dropdown lists are a small fix for a real problem: spreadsheets have no guardrails unless you add them yourself. That's fine for a one-person sheet, but it breaks down the moment more people touch the data.

If you're at the point where your Google Sheet has more dropdowns, more tabs, and more manual rules than it should, describe what you're trying to build to Softr's AI Co-Builder, or start from a template, and turn that spreadsheet into an app with real permissions, workflows, and a proper interface for everyone who needs to use it.