How to Use WPS Sort on Windows

Last updated:July 21, 2026

Use Sort with 3 how-to topics: add a sort rule, set multi-field sorting, and turn on automatic sorting; 3 items are available without membership and 0 items are membership-related.

How-to Index

No.TopicMembership Requirement
11. Add a Sort RuleFree
22. Set Multi-Field SortingFree
33. Turn On Automatic SortingFree

How-to Guide

1. Add a Sort Rule

Entry path: Toolbar → Sort → Sort Condition

  1. Open the target data table.
  2. Click Sort on the toolbar.
  3. Click Sort Condition and choose the field you want to sort.
  4. Select Ascending or Descending.
  5. Check whether the records have been reordered based on the selected rule.

Success Criteria

  • Interface result: The order of records in the data table changes.
  • Next action available: You can continue adding sort conditions or adjust the current rule.

Tips While Using

  • Common mistake: If the field type does not match the actual content, the sorting result may not match your expectation.
  • Environment note: Open a data table that already contains sortable fields.

2. Set Multi-Field Sorting

Entry path: Toolbar → Sort → Sort Condition

  1. Click Sort Condition and set the first field and sort order.
  2. Click Sort Condition again to add the second field and sort order.
  3. Continue adding more fields if needed.
  4. Review the field order to confirm that the sorting priority matches your intended result.

Success Criteria

  • Interface result: Records are sorted by the first field and then refined by the following fields.
  • Next action available: You can return to sort conditions to add, remove, or adjust field rules.

Tips While Using

  • Common mistake: The order of fields affects the final result, so set the primary sort field first.
  • Environment note: The sorting logic of different field types should match your business needs.

3. Turn On Automatic Sorting

Entry path: Toolbar → Sort → Automatic Sorting

  1. Set at least one sort condition first.
  2. Click Automatic Sorting.
  3. Continue entering or editing data in the table.
  4. Check whether new or updated records stay in order based on the existing rules.

Success Criteria

  • Interface result: After data changes, records still appear in the order defined by the current sort rules.
  • Next action available: You can turn automatic sorting off or modify the sort conditions.

Tips While Using

  • Common mistake: If no sort condition is set first, the automatic sorting effect may not be obvious.
  • Environment note: If you later change field types or values in the sort field, the displayed order will also change.