China Naming Network - Auspicious day query - How to cancel the filtering mode in excel tables?
How to cancel the filtering mode in excel tables?
Materials/tools: Excel20 10
1. Open the excel20 10 file. The following are the data to be demonstrated.
2. Click the button in the upper right corner and select "Digital Filter".
3. Select "greater than"
4. For example, we filter data greater than "30".
5. The figure below shows the filtered result.
6. If you want to cancel filtering, you need to click Sort Filtering.
7. Just delete the "Filter" function from the drop-down menu.
8. As shown in the figure below, the filtering status is cancelled.