How to Use WPS Sort on Windows

Use Sort through 6 how-to topics, all available without membership; choose a topic from the index and follow the steps.

How-to Index

How-to Guide

1. Ribbon Ascending

Entry: Data tab → Sort drop-down menu → Ascending

1. Select any cell in the data you want to sort in ascending order.
2. Click the Data tab.
3. Open the Sort drop-down menu.
4. Click Ascending.

Success Criteria

• The current data range is sorted from low to high or A to Z based on the selected column.
• You can continue editing, filtering, or saving the worksheet.

Tips While Using

• If only one column is selected by mistake, related row data may no longer align as expected.
• Check that the header row and data range are complete before sorting.

2. Ribbon Descending

Entry: Data tab → Sort drop-down menu → Descending

1. Select any cell in the data you want to sort in descending order.
2. Click the Data tab.
3. Open the Sort drop-down menu.
4. Click Descending.

Success Criteria

• The current data range is sorted from high to low or Z to A based on the selected column.
• You can continue reviewing the result or save the file.

Tips While Using

• If the wrong column is active, the result may not match your expectation.

3. Ribbon Custom Sort

Entry: Data tab → Sort drop-down menu → Custom Sort

1. Select any cell in the range you want to sort.
2. Click the Data tab.
3. Open the Sort drop-down menu.
4. Click Custom Sort.
5. In the dialog box, set the primary key, sort basis, and order.
6. Click Add Condition to add another level.
7. Click OK.

Success Criteria

• The data is sorted according to one or more conditions.
• You can reopen the dialog box and adjust the rules again if needed.

Tips While Using

• The order of the primary key and secondary key affects the final result.
• Before multi-level sorting, make sure each column uses a consistent data type.

4. Right-Click Ascending

Entry: Right-click a cell → Sort → Ascending

1. Select any cell in the data you want to sort in ascending order.
2. Right-click the selected cell.
3. Open Sort.
4. Click Ascending.

Success Criteria

• The data is sorted in ascending order based on the current column.
• You can continue reviewing or editing the worksheet.

Tips While Using

• If you open the menu from the wrong cell, the sort may be applied to the wrong column.

5. Right-Click Descending

Entry: Right-click a cell → Sort → Descending

1. Select any cell in the data you want to sort in descending order.
2. Right-click the selected cell.
3. Open Sort.
4. Click Descending.

Success Criteria

• The data is sorted in descending order based on the current column.
• You can continue checking high-value or low-value records.

Tips While Using

• If the target cell is not selected first, the sort may run from the wrong position.

6. Right-Click Custom Sort

Entry: Right-click a cell → Sort → Custom Sort

1. Select any cell in the range you want to sort.
2. Right-click the selected cell.
3. Open Sort.
4. Click Custom Sort.
5. In the dialog box, set the primary key, sort basis, and order.
6. Click Add Condition to add another level.
7. Click OK.

Success Criteria

• The data is rearranged according to multiple conditions.
• You can modify the rules and run the sort again.

Tips While Using

• If the order setting is skipped, the multi-level result may not match your intended arrangement.