How to Use WPS Sort on macOS

Last updated:July 24, 2026

Use WPS Sort with 3 how-to topics: add sort rules, build multi-field sorting, and remove sort conditions; choose a topic from the index and follow the steps.

How-to Index

No.TopicMembership Requirement
11. Add a Sort RuleFree
22. Set Up Multi-Field SortingFree
33. Remove Sort ConditionsFree

How-to Guide

1. Add a Sort Rule

Entry path: Toolbar → Sort → Sort Condition

  1. Open the target data table.
  2. Click Sort in the toolbar.
  3. Click Sort Condition.
  4. Select the field you want to sort by.
  5. Choose Ascending or Descending.
  6. Check whether the records are rearranged based on the selected rule.
  7. If needed, click Lock Now to prevent other collaborators from changing the current view settings.

Success Criteria

  • Interface result: The record order in the current view changes.
  • Next action available: You can continue adding sort conditions or return to the table to review the result.

Tips While Using

  • Common mistake: If the field type is not appropriate, the sorting result may not match expectations.
  • Environment note: In collaborative scenarios, whether view settings can be changed depends on current permissions.

2. Set Up Multi-Field Sorting

Entry path: Toolbar → Sort → Add sort conditions multiple times

  1. Click Sort and open Sort Condition.
  2. Set the first sort field and order.
  3. Click Sort Condition again to add a second sort field and order.
  4. Continue adding more fields as needed.
  5. Review the sorting priority from top to bottom.
  6. Return to the table and check the combined sorting result.

Success Criteria

  • Interface result: Records are sorted by the first field, then refined by the following fields.
  • Next action available: You can continue adjusting field order or change the sorting direction.

Tips While Using

  • Common mistake: In multi-field sorting, the order of fields affects the final result.
  • Environment note: It is helpful to confirm that key fields use consistent data types before sorting.

3. Remove Sort Conditions

Entry path: Toolbar → Sort → Delete sort conditions

  1. Click Sort in the toolbar.
  2. Open the list of current sort conditions.
  3. Delete the sort conditions you no longer need.
  4. Return to the table and review the updated display order.

Success Criteria

  • Interface result: The deleted sort conditions no longer take effect.
  • Next action available: You can add new sort rules again.

Tips While Using

  • Common mistake: If only some conditions are removed, the remaining sort conditions still apply.
  • Environment note: Sorting changes only the display order and does not modify record content.