A drop-down box in Excel keeps a sheet tidy when people need to choose from set options instead of typing whatever they want. The cleanest fix is a Data Validation list, and Excel gives you slightly different paths on Windows, Mac, and the web. Start with the basic in-cell list, then use the other methods when your workbook needs something more specific.
Create the basic Windows drop-down
Type the choices you want to allow in one column or one row of your workbook.
Select any cell in that source range and press Ctrl+T if you want the list to update when entries are added or removed.
Select the cell where the drop-down box should appear.
Open the Data tab and choose Data Validation.
On the Settings tab, open Allow and choose List.
Select Source, then select the cells that contain the list choices.
Keep In-cell dropdown selected, and use Ignore blank only when an empty selection is allowed.
Select OK.
Use the Input Message and Error Alert tabs if you want Excel to show instructions or warn users after invalid data is entered.
Fix a missing drop-down arrow
The most common setup miss is leaving In-cell dropdown turned off in the Data Validation rule.
Select the cell that should have the arrow, then open Data and choose Data Validation.
On the Settings tab, confirm that Allow is set to List.
Turn on In-cell dropdown and select OK.
Keep Ignore blank selected when blank entries are allowed, or clear it so Excel validates blank entries typed into the cell. Data Validation only checks values that are typed directly, so when the choice has to be enforced, pair a Stop error alert with a protected worksheet.
Type choices directly for a short list
For a small set of choices, you can skip the worksheet source range and type the allowed values directly into Data Validation.
Select the cell or cells that need the drop-down, then open Data and choose Data Validation.
On the Settings tab, set Allow to List.
In Source, type the choices separated by commas, such as Low,Average,High.
Leave In-cell dropdown selected, choose whether blanks are allowed with Ignore blank, and select OK.
If this method fails, put the values in worksheet cells and select that cell range as the Source instead.
Build a source list that is easier to manage
A named range keeps the source list cleaner when the choices live away from the active sheet.
Put the allowed entries in worksheet cells; if users should not edit the source, put the list on another worksheet that you can hide or protect.
Select the source cells, open the Formulas tab, and choose Define Name in the Defined Names group.
Select the cell that will hold the drop-down, then open Data and choose Data Validation.
On the Settings tab, set Allow to List.
In Source, type an equals sign followed by the defined name, such as =ListChoices, then select OK.
Make the same list on a Mac
Use this path in Excel for Microsoft 365 for Mac, Excel 2024 for Mac, and Excel 2021 for Mac. Start by creating the valid entries in a single row or column with no blank cells.
Select the cells where you want to restrict entries.
On the Data tab, under Tools, select Data Validation or Validate.
On the Settings tab, open the Allow pop-up menu and choose List.
Select Source, then select the range that contains the valid entries.
Press RETURN, or select Expand to restore the dialog box, and then select OK.
For a small Mac list, you can also type comma-separated values directly in Source.
Use Excel for the web
This fixes the browser version when your workbook is open in Excel for the web.
In a new worksheet, type the entries you want in the drop-down list.
Select the cell where the drop-down list should appear.
Open the Data tab.
In Data Tools, choose Data Validation.
On the Settings tab, set Allow to List.
In Source, select the cells that contain the entries, or type choices separated by commas such as Fruit,Vegetables,Grains,Dairy,Snacks.
Choose whether blanks are allowed with Ignore blank.
Keep In-cell dropdown selected.
Select OK.
Add a worksheet combo box
Use a Form Control combo box when you want a visible worksheet control instead of a drop-down arrow inside a cell.
Create a source list with one value per cell.
If Developer is hidden in Excel for Windows, select File, Options, Customize Ribbon, check Developer under Main Tabs, and select OK. In Excel for Mac, select Excel, Preferences, Ribbon & Toolbar, check Developer under Main Tabs, and select Save. Some Mac builds still use the older pane instead: select Excel, Preferences, View under Authoring, then select Developer tab under In Ribbon, Show.
Open Developer, select Insert, and choose Combo box (Form Control) under Form Controls.
Click and drag on the worksheet to draw the combo box.
Right-click the combo box, select Format Control, open Control, set Input range, Cell link, and Drop down lines, then select OK.
Remove a drop-down you no longer need
Select the cell that contains the drop-down list.
To remove validation from multiple nonadjacent cells at the same time, use Ctrl+Left click to select them.
Open Data and choose Data Validation.
On the Settings tab, select Clear All.
Select OK.
For a worksheet Form Control combo box, select the control itself and press DELETE.
If this method fails because you cannot find every drop-down cell, press Ctrl+G, choose Special, select Data Validation, choose All or Same, and then clear the validation rule.
Avoid older ActiveX drop-downs
The most common cause of an old workbook drop-down failing is an ActiveX combo box, because Microsoft 365 and Office 2024 disable ActiveX by default.
Use Data Validation for new in-cell lists.
Use Combo box (Form Control) when you need a visible worksheet control.
On managed Microsoft 365 devices, an administrator can enforce ActiveX blocking; that policy affects ActiveX-based controls, not normal Data Validation drop-down lists.
Frequently Asked Questions
Can I type the drop-down choices instead of putting them in cells?
Yes. Select the cells, go to Data > Data Validation, set Allow to List, type values separated by commas in Source, keep In-cell dropdown selected, and select OK.
How do I open an Excel drop-down without using the mouse?
Select a cell that already has a Data Validation drop-down, press Alt+Down Arrow, use the arrow keys, and press Enter.
Why does my drop-down not grow when I add new choices?
Use an Excel table for the source list. Select a cell in the source range and press Ctrl+T before using that range as the list source; the drop-down updates as items are added or removed.
Can Copilot create the drop-down for me?
Copilot in Excel can apply data validation when Copilot is included by your Microsoft 365 subscription and organization settings. Prompt it with the target cells and allowed values or source range, then review the workbook changes.