How to filter in Excel

Open the Excel document, select the first row, and click "Data"-> "Filter" in the menu above. Then there will be more drop-down buttons on the front page of Excel.

Ascending/descending order: Click on the Score column, click on the Drop-down button, and then click the "Ascending" button can be ranked in ascending order, if you click the "Descending" button in descending order of results.

Filter by color: Click the Drop-down button in the first row, select "Filter by Color" In the pop-up box, assuming that the yellow part can be clicked yellow. You can only filter out a single color. You cannot filter by selecting multiple colors at the same time.

How to restore the status before a filter: Click on the Drop-down button in the first row and select Select All in the pop-up box to restore the status before the filter.

Filter by number: Click on the Drop-down button in the first row, select "Filter by Number" In the pop-up box, and select the Sub option "Filter by number" according to our actual needs. Let's say we choose "greater than" this subkey.

When you select "Greater than", a setting button pops up, entering a condition that is greater than the one we filtered, assuming the setting is 50. Click on the confirmation, you can filter out "score greater than 50" to meet this condition all the data.

Classification:

• Excel Tutorials