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

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

image

Descending Order from the Ribbon

Feature Entry
"Data" tab → "Sort" drop-down menu → "Descending" button

  1. Select any cell in the column you want to sort in descending order
  2. Click the Descending drop-down menu in the Data tab
  3. Click the "Descending" button

image

Custom Sort from the Ribbon

Feature Entry
"Data" tab → "Sort" drop-down menu → "Custom Sort" button

  1. Select any cell in the range you want to sort
  2. Click the Sort drop-down menu in the Data tab
  3. Click the "Custom Sort" button
  4. 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
  1. Click Add Level to set a secondary sort key
  2. Click OK

image

Ascending Order from the Right-Click Menu

Feature Entry
Right-click any cell → "Sort" drop-down menu → "Ascending" button

  1. Select any cell in the column you want to sort in ascending order
  2. Right-click the selected cell and choose the Sort drop-down menu
  3. Click the "Ascending" button

image

Descending Order from the Right-Click Menu

Feature Entry
Right-click any cell → "Sort" drop-down menu → "Descending" button

  1. Select any cell in the column you want to sort in descending order
  2. Right-click the selected cell and choose the Sort drop-down menu
  3. Click the "Descending" button

image

Custom Sort from the Right-Click Menu

Feature Entry
Right-click any cell → "Sort" drop-down menu → "Custom Sort" button

  1. Select any cell in the range you want to sort
  2. Right-click the selected cell and choose the Sort drop-down menu
  3. Click the "Custom Sort" button
  4. 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
  1. Click Add Level to set a secondary sort key
  2. Click OK

image

Ascending Order from the Home Tab

Feature Entry
"Home" tab → "Data Processing" drop-down menu → "Sort" drop-down menu → "Ascending" button

  1. Select any cell in the column you want to sort in ascending order
  2. Click the Data Processing drop-down menu in the Home tab
  3. Click the Sort drop-down menu
  4. Click the "Ascending" button

image

Descending Order from the Home Tab

Feature Entry
"Home" tab → "Data Processing" drop-down menu → "Sort" drop-down menu → "Descending" button

  1. Select any cell in the column you want to sort in descending order
  2. Click the Data Processing drop-down menu in the Home tab
  3. Click the Descending drop-down menu
  4. Click the "Descending" button

image

Custom Sort from the Home Tab

Feature Entry"Home" tab → "Data Processing" drop-down menu → "Sort" drop-down menu → "Custom Sort" button

  1. Select any cell in the range you want to sort
  2. Click the Data Processing drop-down menu on the Home tab
  3. Click the Sort drop-down menu
  4. Click the "Custom Sort" button
  5. 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
  1. Click Add Level to set a secondary sort key
  2. Click OK

image

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