When using WPS Sort, 3 common issue types include row alignment, collaboration impact, and order recovery; this FAQ collects practical fixes and key terms.
FAQ
What should I do if row relationships look incorrect after sorting?
- Confirm that you selected the full data range before sorting instead of only part of one column.
- If the table includes a header row, turn on Data has header row in Custom Sort.
- Run the sort again and check whether full rows move together with the key column.
Does sorting in collaborative mode affect other collaborators?
- Yes. Sorting changes the actual order of data in the sheet.
- In a collaborative scenario, the sorted result is synced to the current collaborative table.
- It is recommended to confirm with other collaborators before sorting so you do not interrupt their current review or editing order.
How can I restore the order from before sorting?
- If you just finished sorting, press Ctrl+Z to undo it.
- If more edits were made afterward, check the collaboration record or version history.
- Restore a suitable earlier version to return to the order from before sorting.
Glossary
| Term | Definition |
|---|---|
| Ascending | A sorting order from small to large, early to late, or A to Z. |
| Descending | A sorting order from large to small, late to early, or Z to A. |
| Primary key | In multi-level sorting, the column with the highest priority that is applied first. |
| Data has header row | An option that treats the first row as a header so it is not sorted as regular data. |
| Version history | Earlier saved states of a collaborative sheet that can be used for recovery. |