Allow Unlisted Values in a Sheets Dropdown Without Removing the List
By ON Lab · Sources checked November 6, 2026
In Google Sheets on a computer, edit the intended dropdown's data validation rule. Open Advanced options and, under If the data is invalid, choose Show a warning, then click Done. Google's current guidance says this permits entries that are not in the dropdown list.
Decide whether exceptions are actually allowed
A Sheets reader wants a dropdown for quick entry while still permitting other text. Their original report says the warning setting seemed ineffective, but their later reply says it was working. That supports explaining the documented rule and how to check it, without inventing a cause for the earlier behavior.
First decide the intended policy. If the column must contain only approved statuses, permitting arbitrary exceptions may be the wrong solution. If free-text exceptions are allowed, a warning can preserve a visible distinction between those exceptions and listed options.
1. Open the existing rule for the right cells
- Select the cell or cells whose dropdown behavior should change.
- Choose Data → Data validation, or use the dropdown's edit control.
- Read the rule's applied range.
- Check whether its criteria use entered dropdown items or a source range.
- Confirm that you are editing the rule for the intended column and rows.
A visually similar dropdown in another column can have a different rule. Read the actual range rather than changing every rule in the sheet. Keep a copy of an important sheet before changing validation that other people rely on.
2. Change invalid-entry behavior
- Open Advanced options for the intended rule.
- Find If the data is invalid.
- Select Show a warning.
- Click Done.
- Reopen that rule and verify its range, criteria and retained warning setting.
Google states that entries not matching an item are rejected unless the warning behavior is chosen. A changed display style such as Chip, Arrow or Plain text is a separate setting; it does not by itself establish permission for unlisted values.
3. Verify both a listed and an unlisted value
In an authorized test cell covered by the rule, choose an ordinary listed option and inspect it. Then use an agreed nonsensitive exception value that is not on the list. Confirm that the exception remains in the cell and that the warning behavior is the one you intended.
Restore a test cell's original content after the check when it belongs to a working dataset. Do not scatter test values through a live report. A test in a cell outside the rule's range does not verify the rule.
Seeing a warning on an accepted exception is not necessarily a failure. The selected policy is to allow a value while flagging that it does not match the list. If your requirement is to avoid the warning entirely, decide whether that value should become an approved list item instead.
4. Keep acceptance separate from the option list
Allowing an unlisted entry does not mean the same text has been deliberately added to the dropdown criteria. If it should become a reusable option, edit the criteria or its source range as a separate controlled change and verify the dropdown afterward.
Google documents editing the items under Criteria and clicking Done. For a dropdown populated from a range, changes to that source range update the list. Read which mechanism the rule uses before editing an unrelated collection of labels.
This task is also different from allowing multiple selected dropdown options in one cell. Google's current instructions make multiple selection a separate option, available for chip-format dropdowns, with a mobile limitation. Do not enable it merely to permit one unlisted value.
If an exception is still rejected
Read the exact error and reopen the rule on that exact cell. Confirm the applied range and saved invalid-entry setting. Do not assume the visible rule was changed for every similar-looking cell, or remove all validation as a first response.
If the documented setting is present but the behavior still differs, preserve a nonsensitive example and record the platform and exact steps. This guide does not diagnose every formula-driven validation problem or reproduce a particular private spreadsheet.
Completion means the intended rule remains in place, listed options still work, and an authorized exception is accepted with the intended warning behavior. A successful Done click alone is not the result check.