excel2013 How do I do custom sorting?

Source: Internet
Author: User
Tags sort

First, open a copy of Excel, and then according to your actual needs to see the custom number to add, small series below to "Research and Development Department, Ministry of Personnel, finance Department" as an example, now excel in the order of these text, then click on the menu bar "file" option, in the pop-up menu select "option";

Second, in the pop-up window select "Advanced", then the right side of the interface down, find "Edit the Custom list", click it;

Third, then in the Pop-up custom window, select the Import button, our custom text serial number import;

If you click No response, the custom sequence a column down, to the bottom can see our custom text sequence, click to select the right side of the "add", then select the bottom right corner of the "OK";

Return to the previous Advanced window, click OK again to return to the Excel table interface;

Select the area you want to sort, and then click "Data--sort" on the menu bar.

In the pop-up window, select the "key keyword" item you want to sort, and then select the order as "custom series";

In the pop-up window, select the custom sequence we identified before, click OK.

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: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.