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!