Home > Topics > excel > body text

Why is the order wrong when filtering in ascending order?

藏色散人
Release: 2021-03-25 17:07:40
Original
38104 people have browsed it

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".

Why is the order wrong when filtering in ascending order?

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.

Why is the order wrong when filtering in ascending order?

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

Why is the order wrong when filtering in ascending order?

[Recommended: Excel Tutorial]

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

Why is the order wrong when filtering in ascending order?

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.

Why is the order wrong when filtering in ascending order?

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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template