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 column floating menu; open the How-to Index and follow the steps for the task you need.

How-to Index

How-to Guide

1. Sort from the Tools panel

Entry: Bottom toolbar → 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. Tap Ascending or Descending in the panel.
5. Check whether the data has been reordered as expected.
6. If you want to cancel the result, use Undo to return to the previous state.

Success Criteria

• Visual result: The selected data range is reordered in ascending or descending order.
• Next action available: You can continue editing, filtering, or saving the spreadsheet.
• No unwanted effect: You can use Undo to reverse the sorting result.

Tips While Using

• Common mistake: If the target data range is not selected completely, the sorting result may not match your expectation.
• Environment note: In collaboration editing, keep the network connection stable when possible.
• Suggestion: Confirm the header row and data range before sorting to reduce mistakes.

2. Sort from the column floating menu

Entry: Select a column → Column floating menu bar → Ascending / Descending

1. Tap the column you want to sort to open the column floating menu bar.
2. Select Ascending or Descending from the floating menu.
3. Check whether the related data has been reordered.
4. If needed, use Undo to restore the previous state.

Success Criteria

• Visual result: The data related to the current column is reordered.
• Next action available: You can continue sorting other columns or keep editing.
• No unwanted effect: Undo restores the order before sorting.

Tips While Using

• Common mistake: If the target column is not selected first, the floating menu entry may not appear.
• Suggestion: This method is useful when you want a quick single-column sort on a phone.