The Excel filtering function is enabled by selecting the data area and clicking the "Filter" button in the "Data" tab. Use the drop-down arrow to set conditional filtering. You can filter data by content, number size, etc. 1. Clear filtering can be achieved by clicking the "Filter" button again or selecting "Clear Filter", 2. You can also use the "Clear" button to restore the original state with one click. Note that the data should be kept continuous to ensure the accuracy of the screening range, and proficiency in using it can greatly improve efficiency.

Excel's filtering function can quickly organize data and find the information you need. After mastering the basic operations, you will find that it is more practical than sorting.

Where is the filter button?

To use the filtering function, you must first select your data area, such as A1 to D100. Then click the "Data" tab on the menu bar and find the "Filter" button in the "Sort and Filter" group. At this time, a small drop-down arrow will appear next to the title of each column, indicating that filtering has been enabled.

Tip: If there are empty rows or empty columns in the middle of the data, it may cause inaccurate filtering range. It is recommended to confirm that the data is continuous before use.

How to filter according to conditions?

Click the drop-down arrow next to any column title and a window will pop up, listing all the values of this column. You can uncheck "Select All" and then individually check what you want to keep. For example, in the "department" column, if you only want to see the data of "sales department" and "marketing department", then just check these two.

If you want to filter by number size, such as salary is greater than 5,000, you can choose "Text Filter" or "Number Filter" (depending on the column content), then select "Greater than", "Lower than" and other conditions, and enter specific values.

• Check specific items
• Use condition judgment (such as including, equal to, greater than, etc.)
• Search box to quickly find keywords

How to clear filters?

When you don't need to filter, you can click the "Filter" button again to close it, or click the drop-down arrow in a certain column and select "Clear Filter". This way all hidden data will be displayed again.

Sometimes you may forget which columns have been set to filter, and you can click one by one to see if there are any filter conditions applied. You can also directly click the "Clear" button in the "Data" tab to restore the original state with one click.

Note: Clear Filter ≠ Close Filter. The former only removes the currently set conditions, while the latter completely exits the filter mode.

Basically that's it. It may be a little slow when you first use it, and the efficiency will improve a lot after getting familiar with it.

The above is the detailed content of how to use the filter function in excel. For more information, please follow other related articles on the PHP Chinese website!