What if the preset dropdown templates do not include the option I need?

Select the target cell. Click Insert → Dropdown List → Custom Dropdown List . Enter the options you need manually, and use + Add Option to keep adding items. Click OK to finish.

How do I edit options after a dropdown list has already been created?

Select the cell that already contains the dropdown list. Open Insert → Dropdown List → Custom Dropdown List again. Edit the option text, order, or colors. If needed, turn on Apply to other same dropdown lists to update matching rules. Click OK to save the changes.

How do I show a prompt when someone enters a value outside the dropdown list?

Open Custom Dropdown List and go to More Settings . In the Invalid Input Alert area, set how the sheet should respond when the input does not meet the rule. Enter the prompt title and message. Click OK , then test an entry that is not in the list.

Does clearing a dropdown list also delete the existing cell content?

No. Clear Dropdown List removes the dropdown rule. Existing text or selected values in the cell remain. If you also want to clear the content, delete the cell value after removing the rule.

WPS Insert Dropdown List on Windows FAQ

Common questions about Insert Dropdown List in WPS on Windows mainly fall into 4 areas: preset templates, option editing, invalid-input prompts, and rule removal.

FAQ

Select the target cell.
Click Insert → Dropdown List → Custom Dropdown List.
Enter the options you need manually, and use + Add Option to keep adding items.
Click OK to finish.

Select the cell that already contains the dropdown list.
Open Insert → Dropdown List → Custom Dropdown List again.
Edit the option text, order, or colors.
If needed, turn on Apply to other same dropdown lists to update matching rules.
Click OK to save the changes.

Open Custom Dropdown List and go to More Settings.
In the Invalid Input Alert area, set how the sheet should respond when the input does not meet the rule.
Enter the prompt title and message.
Click OK, then test an entry that is not in the list.

No.
Clear Dropdown List removes the dropdown rule.
Existing text or selected values in the cell remain.
If you also want to clear the content, delete the cell value after removing the rule.

Glossary

Term	Definition
Dropdown list	A selectable menu in a cell that provides preset options to limit or standardize input.
Referenced range	A group of cells used as the source for dropdown options. When the source range changes, the dropdown options can change with it.
Invalid input alert	A prompt shown when entered content does not match the dropdown rule. It helps remind users about allowed input.
Multi-select	A setting that allows more than one option to be selected in the same dropdown list.