How to create a dropdown list in WPS Spreadsheets
A free Office suite fully compatible with Microsoft Office
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 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
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.
Was this helpful?
Yes
No
Trending Tutorials
- 1. How to get month name from a date in Excel (3 easy ways)
- 2. How to compare two excel sheets and highlight differences
- 3. Check if value is in list in Excel (3 easy methods)
- 4. How to copy file names in Excel from a folder?
- 5. How to color cell based on value in Excel?
- 6. How to add month name from date in Excel formula