Why is the order wrong when filtering in ascending order?

The filter is in ascending order but the order is wrong. This is because the operation method is wrong and it does not extend to a specific area. The solution is: first open the Excel table and select the cells to be sorted in column A; then click " Select "Sort and Filter" in "Edit"; then click "Custom Sort"; finally select "Ascending" in "Order" and click "OK".

The operating environment of this article: Windows7 system, Microsoft Office Excel2010, DELL G3 computer

The operation method is wrong and it is not extended to a specific area. Specific The operation steps are:

1. Open the Excel table and select the cells to be sorted in column A.

#2. Click "Start" and click "Sort and Filter" in "Edit".

[Recommended: Excel Tutorial]

3. Click "Custom Sort" in the pop-up window Select "Extend selected area" and click "Sort".

4. Select "Serial Number" in "Main Keyword", select "Cell Value" in "Sort By", and select "Ascending Order" in "Order" ” and click “OK”. Descending order can be done in the same way.

For more related knowledge, please visit the FAQ column!

The above is the detailed content of Why is the order wrong when filtering in ascending order?. For more information, please follow other related articles on the PHP Chinese website!