How to Use WPS Sort on macOS

Use WPS Sort on macOS with 3 how-to topics, including Quick Sort, Custom Sort, and More Settings; choose a topic from the index and follow the steps to complete the task.

How-to Index

How-to Guide

1. Quick Sort (Ascending/Descending)

Feature path: Data → Sort → Ascending / Descending

1. Select any cell in the column you want to sort.
2. Click Data and then click Sort.
3. Choose Ascending or Descending from the menu.
4. Check whether the full table has been reordered based on the selected column, with related row data moving together.

Success Criteria

• Interface result: The selected column appears in a new order.
• Next action available: You can continue editing, filtering, or saving the sheet after sorting.

Tips While Using

• Common mistake: Looking only at one column and overlooking the full-row movement can make the result seem incorrect.
• Environment note: In a collaborative sheet, the sorted result is synced to other collaborators.

2. Custom Sort (Multi-Level Sorting)

Feature path: Data → Sort → Custom Sort

1. Select any cell in the data range.
2. Click Data, click Sort, and then select Custom Sort.
3. In the Custom Sort dialog box, set the primary key, sort basis, and order.
4. If the first row contains headers, turn on Data has header row so the header is not sorted as data.
5. If you need more levels, click Add Condition to add another sort rule.
6. If you need to remove a rule, select that rule and click Delete Condition.
7. Click OK to run the sort.

Success Criteria

• Interface result: Data is sorted by the primary key first and then by the secondary key.
• Next action available: You can reopen Custom Sort and adjust the rules again.

Tips While Using

• Common mistake: If the header option is not enabled, the first row may be sorted as regular data.
• Environment note: Multi-level sorting is applied from top to bottom in the rule list.

3. More Settings

Feature path: Custom Sort → More Settings

1. Open the Custom Sort dialog box.
2. Click More Settings.
3. Adjust the sort direction as needed, such as sorting by row or by column.
4. Turn on case-sensitive sorting or other regional sort options if needed.
5. Confirm the settings, return to the main dialog box, and click OK to finish sorting.

Success Criteria

• Interface result: The sorting result matches the selected direction or case-sensitive rule.
• Next action available: You can return to the main dialog box and continue adjusting sort rules.

Tips While Using

• Common mistake: If you do not confirm the sort direction, the result may not match the expected row or column orientation.
• Environment note: If the range contains merged cells, check whether the data structure is suitable for sorting before you continue.