What to do if the excel sort is all 1

What should I do if the excel sorting is all 1?

First of all, click to enter excel. If we set it ourselves, it will form a sample where the drop-down is all 1. Then you set 1 and then the drop-down

Recommendation: "excel tutorial》

After pulling down, you will find that they are all 1. At this time, take a look at what signs are on this icon. It has been simplified for everyone to see clearly

Yes, there is a screening standard. In the screening state, no matter how you play, it will always be 1, which cannot be solved.

To solve the problem, click Start-Sort and Filter-Filter and cancel the filter. At this time, you can see that the filter button just now has no filter option

At this time, you have to pull down. First, list the initial data in 1, 2, and 3, then select them all, click on the lower right corner, and start downloading when it turns black

At this time you can find that you can already drop down to sort. Isn’t it amazing? I’m so awesome

The above is the detailed content of What to do if the excel sort is all 1. For more information, please follow other related articles on the PHP Chinese website!