How to Use WPS Sort on Android

Use WPS Sort with 2 how-to topics, including sorting from the Tools panel and sorting from the floating column menu; follow the steps below to organize data.

How-to Index

How-to Guide

1. Sort from the Tools panel

Entry: Tools → Data → Ascending / Descending

1. Select the data range you want to sort.
2. Tap Tools at the bottom.
3. Select the Data tab.
4. In the panel, tap Ascending or Descending.
5. Check whether the data has been rearranged in the selected order.
6. If needed, use Undo to return to the previous order.

Success Criteria

• Interface result: The order of data in the selected range changes.
• What you can do next: You can continue editing, saving, or adjusting the sheet.
• No unwanted effect: You can restore the previous state with Undo.

Tips While Using

• Common mistake: If you do not select the target range first, the sorting scope may not match what you expect.
• Environment note: Make sure the current spreadsheet is editable.
• Suggestion: Back up important data before sorting.

2. Sort from the floating column menu

Entry: Floating menu after selecting a column → Ascending / Descending

1. Tap and select the column you want to sort.
2. In the floating menu, choose Ascending or Descending.
3. Check whether the related data has been sorted.
4. If needed, use Undo to return to the previous order.

Success Criteria

• Interface result: The related data updates in the selected order.
• What you can do next: You can continue filtering, editing, or saving the spreadsheet.
• No unwanted effect: Undo restores the original order.

Tips While Using

• Common mistake: If the target column is not selected correctly, the action may apply to a different column than expected.
• Environment note: The floating menu appears after you select a column.
• Suggestion: Confirm the target column before sorting important data.