Feature Summary
The sorting feature is used to arrange data in ascending or descending order based on the values in a specified column. It supports single-condition sorting and multi-condition custom sorting.
Feature Description
| Feature Dimension | Description |
|---|---|
| Membership Restriction | No membership restriction |
| Version Restriction | No version restriction |
Steps
Ascending Order from the Ribbon
Feature Entry
"Data" tab → "Sort" drop-down menu → "Ascending" button
- Select any cell in the column you want to sort in ascending order
- Click the Sort drop-down menu in the Data tab
- Click the "Ascending" button

Descending Order from the Ribbon
Feature Entry
"Data" tab → "Sort" drop-down menu → "Descending" button
- Select any cell in the column you want to sort in descending order
- Click the Descending drop-down menu in the Data tab
- Click the "Descending" button

Custom Sort from the Ribbon
Feature Entry
"Data" tab → "Sort" drop-down menu → "Custom Sort" button
- Select any cell in the range you want to sort
- Click the Sort drop-down menu in the Data tab
- Click the "Custom Sort" button
- Set the sorting conditions in the pop-up dialog box:
- Sort by: Select the primary column to sort
- Sort On: Cell values, cell color, font color, and so on.
- Order: Ascending or descending
- Click Add Level to set a secondary sort key
- Click OK

Ascending Order from the Right-Click Menu
Feature Entry
Right-click any cell → "Sort" drop-down menu → "Ascending" button
- Select any cell in the column you want to sort in ascending order
- Right-click the selected cell and choose the Sort drop-down menu
- Click the "Ascending" button

Descending Order from the Right-Click Menu
Feature Entry
Right-click any cell → "Sort" drop-down menu → "Descending" button
- Select any cell in the column you want to sort in descending order
- Right-click the selected cell and choose the Sort drop-down menu
- Click the "Descending" button

Custom Sort from the Right-Click Menu
Feature Entry
Right-click any cell → "Sort" drop-down menu → "Custom Sort" button
- Select any cell in the range you want to sort
- Right-click the selected cell and choose the Sort drop-down menu
- Click the "Custom Sort" button
- Set the sorting conditions in the pop-up dialog box:
- Sort by: Select the primary column to sort
- Sort On: Cell values, cell color, font color, and so on.
- Order: Ascending or descending
- Click Add Level to set a secondary sort key
- Click OK

Ascending Order from the Home Tab
Feature Entry
"Home" tab → "Data Processing" drop-down menu → "Sort" drop-down menu → "Ascending" button
- Select any cell in the column you want to sort in ascending order
- Click the Data Processing drop-down menu in the Home tab
- Click the Sort drop-down menu
- Click the "Ascending" button

Descending Order from the Home Tab
Feature Entry
"Home" tab → "Data Processing" drop-down menu → "Sort" drop-down menu → "Descending" button
- Select any cell in the column you want to sort in descending order
- Click the Data Processing drop-down menu in the Home tab
- Click the Descending drop-down menu
- Click the "Descending" button

Custom Sort from the Home Tab
Feature Entry"Home" tab → "Data Processing" drop-down menu → "Sort" drop-down menu → "Custom Sort" button
- Select any cell in the range you want to sort
- Click the Data Processing drop-down menu on the Home tab
- Click the Sort drop-down menu
- Click the "Custom Sort" button
- Set the sort criteria in the pop-up dialog box:
- Sort by: Select the first column to sort
- Sort On: Values, cell color, font color, and so on.
- Order: Ascending or descending
- Click Add Level to set a secondary sort key
- Click OK

Frequently Asked Questions
Q1: What should I do if the data gets messed up after sorting?
- Solution: Use Ctrl + Z to undo the sort. When sorting, make sure "Expand the selection" is selected to avoid sorting only a single column.
Notes
- It is recommended to back up your data before sorting
- Custom Sort allows you to set multiple sort criteria