How do double headings Excel tables sort by percent?

Source: Internet
Author: User
Tags sort

How do you sort a double title Excel table by percent? Double-heading Excel table, how do I sort by percent? The method is simple, please look at the following explanation:


First open the Excel table, select the table, and then click Sort--Ascending: (numerical random, no authenticity)

After clicking, we can see that the prompt "This operation requires the merged cells to have the same size", so this operation is not possible!

We need to select the B3 to E9 form, as shown below:

Click on the menu bar--Sort and filter--custom sort:

In the Sort menu that pops up, include the data in the header don't tick!

List, select list E, order to select Ascending, click OK, and the results are as follows:

The above is the double title Excel table how according to the percentage sorting method introduction, the operation is very simple, everybody has learned? Hope this article can 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.