Use WPS Sort through 2 how-to topics, both available without membership; choose a topic from the index and follow the entry path and steps below.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Sort a selected data range from the Tools panel | Free |
| 2 | 2. Sort the current column from the floating menu | Free |
How-to Guide
1. Sort a selected data range from the Tools panel
Entry: Bottom Tools tab → Data → Ascending or Descending
- Select the data range that you want to sort.
- Tap the bottom Tools tab.
- Tap Data.
- In the panel, select Ascending or Descending.
- Check whether the selected data has been reordered as expected.
- If needed, use Undo to cancel the sort.
Success Criteria
- Interface result: The selected data range appears in a new order.
- Next action available: You can continue editing, reviewing, or saving the spreadsheet.
- No unwanted effect: The sorted result remains in the current file until you undo it.
Tips While Using
- Common mistake: If the target range is not selected completely, the result may not match your expectation.
- Environment note: For collaborative files, confirm that the latest content has synced before sorting.
2. Sort the current column from the floating menu
Entry: Select a column to open the floating menu → Ascending or Descending
- Tap the column that you want to sort to open the floating menu.
- Select Ascending or Descending from the menu.
- Check whether the related data has been reordered.
- If the result is not correct, use Undo to restore the previous order.
Success Criteria
- Interface result: The data related to the current column is reordered.
- Next action available: You can continue reviewing the column or editing the spreadsheet.
- No unwanted effect: The current sort result remains until you undo it.
Tips While Using
- Common mistake: Sorting the wrong column range can affect data you did not intend to reorder.
- Environment note: Before sorting, confirm whether related data in other columns should move together.