Feature Summary

The sort function is used to arrange data in ascending or descending order based on the values in a specified column, supporting both single-condition sorting and multi-condition custom sorting.

Feature Description

Feature Dimension Description
Membership Restriction No membership restriction
Version Restriction No version restriction

Operation Steps

Ribbon Ascending

Function 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

截图

Ribbon Descending

Function 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

截图

Ribbon Custom Sort

Function 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 sort conditions in the pop-up dialog box:
  • Primary Key: Select the first column to sort by
  • Sort By: Values, cell color, font color, etc.
  • Order: Ascending or descending
  1. Click Add Level to set a secondary key
  2. Click OK

截图

Right-Click Menu Ascending

Function 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

截图

Right-Click Menu Descending

Function 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

截图

Right-Click Menu Custom Sort

Function 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 sort conditions in the pop-up dialog box:
  • Primary Key: Select the first column to sort by
  • Sort By: Values, cell color, font color, and so on.
  • Order: Ascending or descending
  1. Click Add Level to set a secondary key
  2. Click OK

截图

Frequently Asked Questions

Q1: What should I do if the data becomes disordered after sorting?

  • Solution: Use Ctrl + Z to undo the sorting. When sorting, make sure to select "Expand the selection" to avoid sorting only a single column.

Notes

  • It is recommended to back up data before sorting
  • Custom sort allows you to set multiple sort conditions