Free All-in-One Office Suite with PDF Editor
Edit Word, Excel, and PPT for FREE.
Read, edit, and convert PDFs with the powerful PDF toolkit.
Microsoft-like interface, easy to use.
Windows • MacOS • Linux • iOS • Android
How to create a dropdown list in WPS Spreadsheets
When using WPS Spreadsheets to process a spreadsheet with a large number of data to fill in, creating a dropdown list in the target cells is able to boost our working efficiency, since we can choose one of the options from the dropdown list to fill the target cells rather than typing the contents word by word.
An example of cells with a dropdown list is shown below. How can we realize it?
An example of cells with a dropdown list inserted
Option 1:
1. Select the cell range to insert dropdown lists.
2. Click the Data tab → the Insert drop-down button
3. Enter the options to be provided. (Tips: We can add or delete options by clicking on the corresponding icons in the upper area of the popup dialog.)
Option 2:
1. Select the cell range to insert dropdown lists.
2. Click the Data tab → the Insert Validation button
3. Enter the options that we want to provide in the dropdown lists, with a comma (,) inserted between each two option. Note that no space is required to be added after the comma(s).
WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc. To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.
Also Read:
- 1. How to use Reading Layout in spreadsheets.
- 2. Ten Unique Action Tracker Template Excel Spreadsheets
- 3. How to add a dropdown list with color in excel
- 4. How to clear the format of cell in WPS spreadsheets?
- 5. Top 10 free Excel spreadsheets templates download 2022
- 6. How To Repair The Error Occur When Wps Spreadsheets Opening This File