When using WPS Sort, common questions usually involve where to find the entry, how to correct the result, and how to undo the action; this page includes 3 common questions and 3 glossary terms.
FAQ
Why can't I find the sort option?
- Make sure you opened a spreadsheet file instead of a document or presentation file.
- Select the data range you want to work with, then check the Data option under Tools.
- If you want the quick entry, select a target column first and then check whether Ascending or Descending appears in the floating menu.
What should I do if the sorting result is not what I expected?
- Check whether you selected the correct data range or target column.
- Run the ascending or descending action again and confirm that the direction is correct.
- If the result still does not fit your needs, use Undo, reselect the range, and sort again.
How do I cancel a sort that I already applied?
- Use Undo right after the sorting action is completed.
- Confirm that the spreadsheet content returns to the previous order.
- If you still need a different result, select the data again and apply a new sort.
Glossary
| Term | Definition |
|---|---|
| Ascending | A sorting order that arranges data from smaller to larger values or from earlier to later positions. |
| Descending | A sorting order that arranges data from larger to smaller values or from later to earlier positions. |
| Undo | A command that reverses the most recent action and can restore the order before sorting. |