Excel Dropdown Like Google Sheets? Create One Easily

Yes. Excel can make a dropdown much like Google Sheets: select the cells, go to Data > Data Validation, choose List, and provide the choices or a cell range containing them. The result is an in-cell dropdown that helps people enter consistent values, although Excel does not display Google Sheets-style colored dropdown chips in the same way.

What an Excel dropdown does

In Excel, the standard dropdown is created with Data Validation. It restricts or guides what a user can enter in selected cells. A list dropdown shows choices such as Pending, In progress, and Complete, so a person can choose an existing value instead of typing it from scratch. The feature works in Excel for Microsoft 365 on Windows and is also available in other current Excel editions, though the interface can vary slightly.

A dropdown is useful for repeated categories, not just for making a sheet look tidy. If a task tracker uses the same three status labels throughout, a list reduces variations such as Done, complete, and Completed. Consistent entries are easier to filter, count, summarize in a PivotTable, and use in formulas. The validation rule applies to the cells you select; it does not automatically enforce the same choices everywhere in the workbook.

Excel’s dropdown is a cell-level control, not a separate menu object placed over the sheet. Its arrow generally appears when a cell with the validation rule is selected. That differs from a visible button or a persistent chip, and it is a common reason an Excel dropdown can seem missing when the cell is not active.

Create a basic dropdown in Excel

For a simple example, put the allowed status values in H2:H4, then add a dropdown to B2:B50. Keeping the list in worksheet cells makes it easier to revise later than embedding the words directly in the rule.

Enter the choices in separate cells, such as H2 = Not started, H3 = In progress, and H4 = Complete.
Select the cells that should have the dropdown, such as B2:B50. You can select a single cell or a larger range.
On the ribbon, choose Data > Data Validation.
On the Settings tab, set Allow to List. Make sure In-cell dropdown is selected.
In Source, enter =$H$2:$H$4 if the choices are on the same worksheet. Alternatively, select the source cells with the range picker.
Choose whether to allow blank cells. On the Input Message tab, you can add a short instruction that appears when a user selects a cell.
On the Error Alert tab, keep the alert enabled and use the Stop style if entries outside the list should be rejected when typed. Select OK.

Select B2 to see the arrow, then choose a value. The same rule is applied to the other selected cells. If the list is on another worksheet, Excel may not accept a direct reference to that sheet in the Source box. A practical approach is to create a defined name for the source range using Formulas > Define Name, then enter that name in Source with an equals sign, for example =StatusOptions. This also gives the list a readable name when you revisit the validation settings.

Choose and maintain the source list

There are two common ways to provide choices. You can type them directly into the Source box, or refer to cells that contain the options. A typed list is convenient for a tiny, fixed set of values, but the items must be separated using the list separator expected by your computer’s regional settings. Commas are common, but not universal. A source range avoids that separator issue and is usually easier to maintain.

Use a source range when choices may change, when an item contains punctuation, or when more than one sheet needs the same list. Keep the entries together in one column and avoid including a heading or blank rows unless you intend them to be part of the dropdown. To add or rename an option, edit the source cell. If the validation rule refers to a fixed range, however, adding a choice below that range will not automatically include it; update the source range or use a suitable named range that expands with the list.

For a workbook that other people will edit, consider putting source values on a clearly labeled Lists worksheet. You can hide that sheet if it would clutter the workbook, but hiding it is not a security measure: users with access to the file may still be able to reveal it. Avoid relying on a hidden list to protect sensitive information.

Make the list easier to update

A dropdown is only as current as its source. If a list changes often, plan how the range will grow before distributing the workbook. One straightforward option is to reserve extra cells in the source range, although unused cells may appear as blank choices. Another is to create a defined name for the list and update its reference when needed. A defined name is particularly useful when the source is on a different worksheet because the validation rule can refer to the name rather than a cross-sheet address.

For larger workbooks, keep list values in a dedicated Excel table and use a defined name or another supported reference strategy to connect the table column to validation. This takes more setup than a fixed range, but it gives the list a clear home and makes maintenance less error-prone. Check the dropdown after changing the list, especially if the workbook will be opened in another Excel version or in a spreadsheet app with different validation support.

You can also copy a cell that already has the rule and paste it to another target cell. Be mindful of the paste options: a normal paste can carry more than validation, including formatting and the existing cell value. If you only want the rule, use Paste Special and choose the validation option where available, or create the rule directly for the destination range.

Excel dropdowns compared with Google Sheets

The core idea is similar in both programs: define allowable choices, then let the user select one in a cell. In Google Sheets, a user can create a dropdown through Insert > Dropdown or Data > Data validation. Sheets offers display styles such as chips, which can show colored labels in the cells. Excel’s usual Data Validation list presents a dropdown arrow when the cell is selected; it does not turn the entry into the same chip-style control.

Excel can still make the selected values easier to scan. For example, use Home > Conditional Formatting to apply a fill color based on a status value. That colors the cell according to its content, rather than giving the dropdown item a Sheets-style chip presentation. This distinction matters when someone asks for a dropdown that looks exactly like Google Sheets: Excel can match the selection behavior, but not every visual detail through ordinary list validation.

The two products also differ in how their menus and collaboration features work. A workbook opened in Excel for the web may present validation controls differently from desktop Excel, and Google Sheets rules do not transfer perfectly to Excel in every case. If a file moves between services, check the dropdowns, source ranges, and any conditional formatting after conversion rather than assuming the appearance and behavior are identical.

Dependent dropdowns and related options

A basic dropdown uses the same set of choices in every cell. A dependent dropdown changes its choices based on an earlier selection. For example, a first cell could offer a department, and a second could offer roles associated with that department. Excel can support this design using named ranges and a validation source that refers to the first selection, but it requires careful naming and setup. It is more fragile than a basic list if category names contain spaces or the source ranges are renamed.

For a small form, separate dropdowns with clear labels are often easier to maintain than a dependent system. Use dependent lists when the shorter, context-specific second list meaningfully reduces mistakes. Test each parent choice and confirm that the child list updates as intended; changing the parent does not necessarily erase an old child value, so the sheet may need a separate check for mismatched combinations.

Data Validation also supports other kinds of restrictions, such as whole numbers, decimals, dates, times, text length, and custom formulas. Choose List when the user should select from specified labels. If the real requirement is a numeric limit, a date window, or a rule involving multiple cells, the corresponding validation type may be more appropriate than a dropdown.

Common dropdown problems

The arrow is not visible: Select the cell. In-cell arrows usually appear only while a validated cell is active. If there is still no arrow, open Data > Data Validation and confirm that Allow is set to List and In-cell dropdown is checked.
The list is empty or incomplete: Check the Source range for the right worksheet, rows, and cells. If you added options beyond a fixed source range, extend the reference. Also confirm that the source cells contain the expected values and are not blank.
Excel accepts an unlisted value: Review the Error Alert tab. The alert must be enabled, and Stop is the strictest style for rejecting a newly typed invalid entry. Warning and Information alerts allow the user to proceed.
Invalid values appear after pasting: Pasting data can place content into validated cells without the same restriction as typing a value and responding to the alert. Validation is useful guidance, but it is not a complete data-security or access-control system. Check imported or pasted data separately.
A choice was renamed but old cells still show the old text: Editing a source option does not necessarily rewrite values already selected in the destination cells. Update existing entries if consistency matters, and review filters or formulas that depend on the former wording.

When troubleshooting, select one affected cell and inspect its Data Validation settings before changing the whole range. That helps identify whether the issue is the source list, the selected cells, or a copied value. If different rows have different rules, selecting the entire column and applying one new rule may overwrite intentional differences, so confirm the intended scope first.

Excel for the web and Mac

In Excel for Microsoft 365 on Windows, the standard path is Data > Data Validation. Excel for Mac also provides data validation from the Data tab, although dialog layout and some controls can differ by release. Excel for the web supports dropdown lists and validation features, but its editing interface may not expose every desktop option in the same way. If a setting is unavailable in the browser, open the workbook in the desktop app to manage the rule.

When sharing a workbook, distinguish between entering a value and changing the rule itself. People may be able to use an existing dropdown even if they do not know how it was configured. For important templates, include a brief instruction near the input area and test the file in the version your collaborators are likely to use.

Frequently Asked Questions

Can I make an Excel dropdown from another sheet?

Yes. Create a defined name for the range on the other worksheet, then use that name as the Source in Data Validation, such as =StatusOptions. This is generally more reliable than putting a direct reference to another sheet in the Source box.

Can users type their own option into the dropdown cell?

They can try, but the result depends on the Error Alert settings. A Stop alert blocks a newly typed value that is not in the list; Warning or Information alerts let the user continue. Pasting may bypass the alert, so validation alone cannot guarantee that every cell contains an approved value.

How do I add another choice later?

Add the new text to the source list and make sure the validation source includes that cell. If the rule uses a fixed range, extend it in Data > Data Validation. A defined name can make updates easier, but it still needs to refer to the expanded list.

Why does my Excel dropdown not look like a Google Sheets chip?

Excel’s standard list validation shows a selection arrow rather than a persistent colored chip. You can use conditional formatting to color cells based on their selected text, but that is a separate formatting rule and does not reproduce every Sheets display style.

Can I remove a dropdown without deleting the cell value?

Yes. Select the cell or range, open Data > Data Validation, and use Clear All in the validation dialog to remove the rule. The existing cell contents are separate from the validation rule, so check the selected range carefully before clearing anything.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.