How to Insert a Drop-Down Menu in Excel and Edit It

To insert a drop-down menu in Excel for Microsoft 365 on Windows, select the cell, choose Data > Data Validation, set Allow to List, enter your choices or a range containing them in Source, and select OK. A drop-down arrow then lets people choose an approved entry instead of typing one, which helps keep information consistent in forms, trackers, and shared workbooks. Before you start, decide which choices to offer and whether you want to type them directly or keep them in worksheet cells.

What You’ll Need

An Excel workbook and the cells where you want the drop-down menu to appear.
A short list of choices, either ready to type into the validation settings or entered in worksheet cells.
For a reusable or longer list, a place to store the choices in the workbook. You can put them on the same sheet or a separate sheet.

You do not need a special add-in or a formula to create a basic list. The feature is called Data Validation. It can limit a cell to entries from a list and, if you choose, show a message or warning when someone enters something else.

Step-by-Step

Choose the destination cell or cells. Click the cell where you want the menu. To use the same menu in several places, select the full range first, such as the cells in a Status column. You can also apply the rule to one cell, copy it, and paste it into other cells later. If the sheet is protected, unprotect it before changing validation settings.
Prepare the choices. For a short list that will not change often, write down the entries you want, such as Not started, In progress, and Complete. For a list that may change, put each choice in its own cell in a spare area of the workbook. A vertical list is usually easiest to maintain. Avoid blank cells within the list because they can appear as empty choices.
Open Data Validation. On the Windows ribbon, select Data > Data Validation. If the Data Validation button is not immediately visible, look in the Data Tools group on the Data tab. Choose Data Validation from the button’s menu if the button offers a menu. In Excel for Mac, use the Data tab and choose Data Validation; the dialog may be arranged differently, but the list settings have the same purpose.
Set the rule to a list. In the Settings tab of the Data Validation dialog, open the Allow menu and select List. Keep In-cell dropdown selected so the arrow appears in the cell. Ignore blank is commonly left selected when an empty cell is allowed, but clear it if users must fill the cell. The precise labels or layout can vary slightly by Excel update.
Enter the choices or point to their cells. For a small, fixed list, click Source and type the choices separated by commas, for example: Not started,In progress,Complete. Do not add spaces after commas unless you want those spaces to become part of an entry. If your choices are in H2:H4 on the same worksheet, enter =$H$2:$H$4 in Source. The dollar signs keep the source range fixed if the validation rule is copied. Click OK to apply the rule.
Test the menu. Select the validated cell and click its arrow. Choose one entry and confirm it appears in the cell. The arrow normally appears when the cell is selected, not all the time. Try typing a value that is not on the list as well; whether Excel blocks it depends on the error-alert settings described below.
Make a list that can be reused across sheets (optional). A direct reference to a range on another worksheet may be rejected in the Data Validation Source box. To use a list stored elsewhere, select the source cells and create a named range through Formulas > Define Name. Give it a clear name such as StatusOptions, then set the validation Source to =StatusOptions. Names cannot contain spaces. In the Name dialog, check that the name refers to the intended cells before confirming.
Apply the same menu to more cells if needed. If you did not select all destination cells at the start, copy a cell that has the rule, select the other destination cells, and use Home > Paste > Paste Special > Validation where that option is available. Alternatively, open Data Validation with the destination range selected and set the rule there. Check a few cells afterward to make sure the intended range received it.

For an expanding list, avoid assuming that a validation reference to a fixed range will automatically include new entries below it. You can update the Source range when the list grows, or use a named range that refers to an Excel Table column. To make a table, select the choice cells and choose Insert > Table, making sure the header setting matches your selection. Then create a name in Formulas > Define Name that refers to the table’s choice column, and use that name with a leading equals sign in the validation Source. This setup takes a little more care, so test it after adding a new choice.

Excel for the web also supports creating and editing many list-validation rules through Data > Data Validation. Some advanced options and dialog controls can differ from desktop Excel, and organization or workbook settings may restrict what is available. If you cannot find a setting or need a named range for a source on another worksheet, open the workbook in the desktop app and finish the setup there. Mac users can follow the same general ribbon route, though button positions and some dialog details may differ from Windows.

Common Mistakes

Forgetting In-cell dropdown. A list rule can exist without the visible arrow if this option is cleared. Reopen Data Validation for the cell and select the checkbox.
Using the wrong separator in a typed list. Excel uses commas between choices in the Source box for a directly typed list. A semicolon may not separate entries as expected. If a choice itself contains a comma, use a worksheet range for the source instead of typing the list directly.
Selecting the header as a choice. If the source range includes a heading such as Status, that heading may appear in the menu. Select only the actual entries, or adjust the source range.
Pointing to a range on another sheet directly. A plain cross-sheet reference in Source can cause an error. Create a named range for those cells and use the name in the validation rule.
Expecting an error alert to prevent every invalid entry. The error alert can be turned off, and a warning-style alert allows users to continue. Choose the Stop style if Excel should reject entries that are not in the list.
Assuming copied cells always keep the right rule. Copying and pasting can bring formatting or validation from the source cell, potentially replacing the destination rule. Check validation on the affected cells after copying data.

Tips

Use a source range for lists you expect to revise. You can edit the worksheet entries without reopening the validation dialog. Keep the choices together and label the list area so it is easy to find later.
Choose clear, distinct labels. Entries such as Open, Waiting for review, and Closed are easier to understand than several nearly identical abbreviations. Consistent choices also make sorting and filtering more useful.
Add an input message. In the Data Validation dialog, open the Input Message tab and enter a short title and instruction. Excel displays the message when a user selects the cell, which can explain what the choices mean or when to use them.
Set an error alert deliberately. On the Error Alert tab, keep Show error alert after invalid data is entered selected if you want Excel to respond to entries outside the list. Stop blocks an invalid entry; Warning and Information let the user proceed after a prompt. Use a concise message that says what to do instead.
Keep the source list out of the way, not out of reach. You can store choices on a separate worksheet and hide that sheet if appropriate. Hiding is not security: someone with access to the workbook may still be able to reveal the sheet.
Use a consistent rule for a whole column where practical. Apply the validation to the working rows in a table or range, then test new rows. A rule applied to a fixed range does not necessarily cover cells added beyond that range.
Remember that a drop-down is not a complete data-security control. It improves data entry, but it does not protect the workbook from deliberate changes or guarantee that pasted data will always follow the intended choices. Review important data before relying on it.

Troubleshooting

The arrow does not appear: Select the cell and check Data > Data Validation. Confirm Allow is List and In-cell dropdown is checked. If you are looking for the arrow while the cell is not selected, click the cell first. Also check whether the worksheet is protected or the cell is part of a merged range, since these can interfere with editing or using validation.

Excel says the source evaluates to an error: Check that the source cells exist, that the range is written correctly, and that it does not include an unintended heading. If the choices are on another worksheet, use a defined name rather than entering a direct cross-sheet reference. For a named range, open Formulas > Name Manager and verify the name spelling and the cells it refers to.

The menu shows one combined choice instead of several: If you typed the choices directly, check that commas separate them and that you did not paste line breaks into the Source field. Regional settings or a list containing punctuation can make a typed list awkward. Put each choice in a separate worksheet cell and point Source to that range instead.

People can type values that are not listed: Reopen the Error Alert tab and make sure the alert is enabled. Select Stop to reject the entry rather than merely warn about it. A pasted value may behave differently from a normal typed entry in some workflows, so verify the finished cells if users paste data into them.

Changes to the source list do not show up: Check that you edited cells inside the range used by the rule. If you added choices beneath a fixed source range, expand the range in Data Validation or adjust the named range. A named range that points to a fixed set of cells does not grow automatically unless it is built to do so.

The rule disappeared or changed: Undo immediately if the change was just made, then inspect Data Validation on a working cell. A pasted cell may have overwritten the rule, or a workbook import may have removed it. Reapply the validation to the intended range and test the drop-down again.

Frequently Asked Questions

Can I put a drop-down in more than one cell?
Select all the destination cells before opening Data Validation, then create the list rule once. If cells already contain different rules, check the result after applying the new one because the selected cells may be given the same validation settings.

Can I allow more than one selection in a cell?
Not with standard Data Validation alone. A normal Excel drop-down puts one choice in the cell. Allowing multiple selections in one cell generally requires a macro or a different design, such as using several cells. Do not use a macro unless the workbook’s security and sharing requirements allow it.

Can the list update when I add a new choice?
Yes, if the Source is set up to include the new cell. A fixed range will not necessarily expand by itself. Use an appropriate named range based on an Excel Table column, or edit the Source range when the list changes, and test the new entry.

Can I make a drop-down on a different worksheet from its choices?
Yes. Create a named range that refers to the source cells, then enter that name, preceded by an equals sign, in the Data Validation Source box. This avoids the direct cross-sheet reference problem.

How do I remove a drop-down?
Select the cell or range, open Data > Data Validation, and choose Clear All in the dialog, then confirm. This removes the validation rule; it does not automatically erase values already entered in the cells.

Will the drop-down arrow always be visible?
No. In-cell drop-down arrows generally appear when a validated cell is selected. If there is no arrow after selecting it, check the List setting and In-cell dropdown option.

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.