Office Settings & Configuration

How to Allow Custom Text in an Excel Drop-Down List

John Wilson Oct 12, 2026 869 views

Question details

The user wants to input custom text alongside a predefined drop-down selection without triggering a validation error.

How to Allow Custom Text in an Excel Drop-Down List

Product: Microsoft Excel
Device & OS: not provided
Scenario: Appending specific details or numbers (e.g., 'Glucose Level: 78') to a category selected from a drop-down list.
Observed behavior: Excel rejects the custom text because the default data validation rules strictly allow only the predefined values.

Before you start

Identify the cells containing the drop-down lists where you want to enable free-form text input.

Solution 1Recommended

Disable the Data Validation Error Alert

Turn off the error alert to allow users to select from the drop-down or type their own custom text.

By default, Excel's Data Validation feature blocks any input that doesn't exactly match the drop-down list. Disabling the error alert keeps the drop-down arrow for quick selections while permitting manual text entry.

Select the target cells

Highlight the cell or range of cells containing your drop-down list.

Open Data Validation

Navigate to the Data tab on the ribbon and click on Data Validation.

Modify the Error Alert settings

In the Data Validation dialog box, go to the Error Alert tab.

Disable the alert

Uncheck the box next to 'Show error alert after invalid data is entered', then click OK.

Flexible Entry Enabled: You can now select an item from the drop-down menu and type additional text into the same cell without receiving an error.

Solution 2

Use an Adjacent Helper Column

Maintain strict validation on the drop-down list and use a neighboring cell for custom additions.

Flexible Data Entry with WPS Spreadsheet

Manage Drop-Down Lists Seamlessly in WPS Office

WPS Spreadsheet provides a highly compatible and intuitive interface for managing data validation, drop-down lists, and custom input rules, making it a perfect tool for handling flexible data entry tasks.

1. Open your file: Launch WPS Spreadsheet and open your workbook containing the drop-down lists.
2. Select the cell: Highlight the cell or range of cells you want to modify.
3. Edit Data Validation: Go to the Data tab, click Data Validation, navigate to the Error Alert tab, and uncheck 'Show error alert'.

100% format compatibility with Microsoft Excel drop-down lists and validation rules.Intuitive Data Validation dialog for quick adjustments.Easily disable error alerts to allow free-form text alongside drop-down items.Free and lightweight alternative for processing complex spreadsheets.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel show an error when I add text to a drop-down item?

By default, Excel's Data Validation strictly restricts cell input to the predefined items in the drop-down list source. Typing anything else triggers an 'invalid data' error unless the error alert is specifically disabled.

Can I make the drop-down list auto-complete as I type custom text?

Yes, modern spreadsheet tools support searchable drop-down lists. As you type, the list filters to match your text. However, you still need to disable the error alert if you plan to leave custom text in the cell that doesn't exactly match an item in the predefined list.

Will allowing custom text break my existing formulas?

Disabling the error alert only changes data entry permissions. However, if you have formulas like VLOOKUP, SUMIF, or COUNTIF that rely on exact matches from the original drop-down list, entering custom text might cause those formulas to fail or exclude the newly modified data.

Office App Problems