WPS Insert Dropdown List on macOS FAQ

Common questions about Insert Dropdown List usually involve preset templates, option editing, batch application, and input prompts; this FAQ includes 4 frequent questions and a glossary.

FAQ

What if the preset template I need is not available?

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

How do I edit existing options after creating a dropdown list?

1. Select the cell that already contains the dropdown list.
2. Click Insert → Dropdown List → Custom Dropdown List.
3. Edit the option text, order, or colors in the dialog box.
4. If needed, select Apply to other identical dropdown lists to update matching rules.
5. Click OK to save the changes.

How do I apply the same dropdown list to multiple cells at once?

1. Select all cells that need the same dropdown list. You can select a continuous range or separate cells as needed.
2. Click Insert → Dropdown List.
3. Choose a preset template or open Custom Dropdown List to configure one rule.
4. Finish the setup to apply the same dropdown rule to all selected cells.

How do I show a prompt when someone enters a value that is not in the list?

1. Open the Custom Dropdown List dialog box.
2. Click More Settings in the upper-right corner.
3. Set how input that does not meet the conditions should be handled.
4. Enter the prompt title and message.
5. Click OK to save the settings. A prompt can then appear for input that does not meet the rule.

Glossary