How to use custom sort in Excel

Source: Internet
Author: User
Tags sort

How do I use custom sorting in Excel? At work, sometimes we need to quickly sort the data in Excel by selecting the area to sort by, clicking sort (Ascending or descending) in the menu bar, and if sometimes this does not meet your needs, you need to customize the sort, as follows:


Open an Excel worksheet, such as the illustration:

Select the area you want to sort.

Opens the Custom Sort dialog box.

The operation process is as shown.

Description: 1, if there are multiple conditions, click the top left foot "add conditions." 2, through the option to set the direction and method of sorting.

Click OK to draw the following results.

The above is in Excel custom sort the Use Technique method Introduction, the operation is very simple, everybody has learned? Hope to be helpful to everybody!

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.