When using WPS Sort, common questions usually involve finding the sort entry, restoring the previous order, and confirming the correct data range; this FAQ includes 3 common questions and a glossary.
FAQ
Why can’t I find the sort option?
- Make sure the file you opened is a spreadsheet and that it is editable.
- Select a data range and check whether Tools appears at the bottom.
- Open Tools and go to the Data tab to look for Ascending or Descending.
- You can also select a column first and check whether the sort option appears in the column floating menu.
How do I restore the original order after sorting?
- Use Undo right after the sorting action.
- Confirm that the spreadsheet content returns to the previous order.
- If you still need to sort again, select the correct range and repeat the action.
Why should I select the data range or column before sorting?
- Sorting is applied to the currently selected range.
- If only part of the content is selected, only that part may be affected.
- Checking the header row, data range, and target column before sorting helps reduce ordering mistakes.
Glossary
| Term | Definition |
|---|---|
| Ascending | A sorting order from smaller to larger or earlier to later, such as numbers from low to high or letters from A to Z. |
| Descending | A sorting order from larger to smaller or later to earlier, such as numbers from high to low or letters from Z to A. |
| Undo | A command that reverses the most recent action. After sorting, it can restore the previous data order. |