Excel sorting feature settings

When we use Excel2003 to edit the statistics table, a large number of data collation stand more trouble, however, in this case we can use the Excel sorting function to explore, query the relevant data. Here's a look at Excel's sorting capabilities.

Operation Steps

1, open "Statistics" Select any one cell, click "Descending sort".

2, Next click data → sort to set the sort method.

3, at this time the "sorting" Settings bar, the "main keywords", "secondary keywords", "third keyword" in the form of the "school name", "Postal Code", "Address" and other sorting.

4, then click the "Sort" settings bar under the "sorting options" can be set "alphabetically" and "stroke sorting" both according to the actual situation and choose.

5, after the setup is complete, we click "Descending sort" to see the arrangement effect.