Feature Summary
The dropdown list feature is used to create a selectable dropdown menu in a cell. It supports manually adding options and importing options from cells, helping users quickly enter fixed-option data, avoid manual input errors, and improve data entry efficiency.
Feature Description
| Feature Dimension | Description |
|---|---|
| Membership Restriction | No membership restriction |
| Version Restriction | No version restriction |
Steps
Insert a Dropdown List (Graphical Operation)
Feature Entry
"Data" tab → "Dropdown List" button
- Select the cell or cell range where you want to add a dropdown list
- Click the Dropdown List button in the Data tab
- Choose a configuration method:
- Manually add options: Select Manually add dropdown options → Click the + icon to add a new option, and enter the content one by one
- Import options from cells: Select Choose dropdown options from cells, and select the cell range where all options have been pre-entered
- Use the up and down arrows to adjust the order of options. Select an option and click delete to remove it
- Click OK to apply

Create a Dropdown List via Data Validation
Feature Entry
"Data" tab → "Validation" button → "List" option
- Select the target cell
- Click the Validation button in the Data tab
- In the pop-up window, switch to the Settings tab
- In the Allow dropdown box, select the List option
- In the Source input box, enter the dropdown options. Multiple options must be separated by commas (,)
- Check the In-cell dropdown option
- Click OK to complete the setup. Click the dropdown arrow on the right side of the cell to select content

FAQ
Q1: What should I do if the dropdown list options display abnormally?
- Solution: Check if the dropdown list options contain duplicate entries, and delete the duplicate content.
Q2: Can the dropdown list support multiple selections?
- Solution: The default WPS dropdown list only supports single selection. Multiple selections can be achieved through macros or third-party plugins.
Q3: How to combine conditional formatting to achieve intelligent color-coding of options?
- Solution: You can combine conditional formatting to achieve intelligent color-coding of options.
Notes
- The insert dropdown list feature supports two modes: manually adding options and importing from cells
- The advantage of importing options from cells is that subsequent modifications to options only require modifying the original cell range, and the dropdown list will update automatically
- When creating a dropdown list via data validation, multiple options must be separated by commas (,), and the "In-cell dropdown" option must be checked
- Named range dropdown lists can achieve global updates with a single modification, suitable for scenarios where options are reused in multiple places and modified frequently