How do I edit the options in an existing dropdown list?

Select the cell that already contains the dropdown list. Click Insert → Dropdown List → Custom Dropdown List . Edit the existing option text, order, or related settings. If you want matching lists to update together, turn on Apply to Other Same Dropdown Lists . Click OK to save the changes.

Insert Dropdown List in WPS on macOS FAQ

Q: What if the preset template I need is not available?

Select the target cell. Click Insert → Dropdown List → Custom Dropdown List . Enter the options you need in the dialog box and use + Add Option to add more items. Click OK to apply the custom list to the current cell.

Q: How do I show a prompt when someone enters invalid content?

Open the Custom Dropdown List dialog box and go to More Settings . In the Error Alert area, choose how invalid input should be handled. Enter the prompt title and message. Click OK , then test by entering a value that is not in the list.

When using Insert Dropdown List, the most common questions focus on preset templates, option editing, and invalid-input prompts; this FAQ includes 3 common answers and a glossary.

FAQ

What if the preset template I need is not available?

Select the target cell.
Click Insert → Dropdown List → Custom Dropdown List.
Enter the options you need in the dialog box and use + Add Option to add more items.
Click OK to apply the custom list to the current cell.

Select the cell that already contains the dropdown list.
Click Insert → Dropdown List → Custom Dropdown List.
Edit the existing option text, order, or related settings.
If you want matching lists to update together, turn on Apply to Other Same Dropdown Lists.
Click OK to save the changes.

How do I show a prompt when someone enters invalid content?

Open the Custom Dropdown List dialog box and go to More Settings.
In the Error Alert area, choose how invalid input should be handled.
Enter the prompt title and message.
Click OK, then test by entering a value that is not in the list.

Glossary

Term	Definition
Dropdown list	A menu of predefined options in a cell that helps restrict or standardize input.
Referenced range	A group of cells used as the source for dropdown options. When the source changes, the list can change with it.
Error alert	A prompt shown when entered content does not match the dropdown rule.
Multiple selection	A setting that allows more than one option to be selected in the same dropdown list.