How many ways are there when excel filtering?

1. Automatic filtering: Open the **excel file that needs to be filtered, click on the cell with the mouse to locate any cell area containing data, and click the menu bar - data - filter - automatic filter.

2. Drop-down arrow: After selecting automatic filtering, the drop-down arrow appears in the data column, and click the drop-down arrow to display the filter menu. Each drop-down menu corresponds to a filter category.

3. Filtering method: Click on the number filter to filter the data for a specific data or a certain numerical interval for the ** file containing a large amount of data. For example, if you need to filter out items with a historical score of less than 85 points, click on the number to filter, select less than, and enter 85 to filter.

4. Establish a region: If you want to filter out the scores of multiple categories, such as students with scores greater than 80 points in four subjects, you need to establish a conditional area in advance, and empty three or more rows above the overall data, corresponding to the input data classification and the required condition restrictions.

5. Advanced filtering: Click the menu bar - Data - Filter - Advanced Filter to open the menu of advanced filtering.

6. List area and condition area: After opening the advanced filter, you can enter the cell range or use the mouse to check the required area, and check the list area and the condition area respectively.

7. Result acquisition: If you need to let the filtered data be displayed elsewhere alone, check the box to copy the filtered results to other locations, and manually click the cells that need to be stored.

Click OK to get the filter results.

1. Filtering is especially suitable for large worksheets with the same structure in each row. "Each row has the same structure" (the content of each column is of the same type) ensures that the filter results are meaningful; The "large worksheet" ensures the practicality of the screening.

2. It is best to have a header for each column of the data to indicate the significance of the data in this column. This header can be used in advanced filtering to indicate which column the criteria for Nian Bi to take.

3. Screening is a process of matching conditions and patterns. The input conditions support logical operations, and only support and or operations; Pattern matching supports the wildcard character "?"." and "*" match any single character, and "* matches any number of characters."

If you want to match "*" or "?"."Please use escape characters" "It is important to understand how to use wildcards.

What are the excel screening techniques? Included or.

There are advanced filtering and automatic filtering of filtered data.

Advanced filtering can filter out the function of automatic filtering that is not available in early search, and automatic filtering is ordinary filtering.

1. First, we select the columns that need to be filtered.

2. Execute the "Data-Filter" command, and the columns selected in the second step will appear with inverted triangle arrows.

3. Click on the inverted triangle arrow, and the drop-down menu will pop up, and there will be multiple criteria to filter the items. For example, if you select "Digital Filter", a drop-down menu will appear, and you can do it as needed.

4. There is a "Custom Filter" at the bottom of the drop-down menu, which can be clicked to filter a variety of banquet modifications.

5. The accompanying pictures take column A, B, and C as "greater than 30" as an example to show the renderings.

When filtering, you need to select the header of the table and click Filter.

Operation method: 1. First, select the header position of the data cell to be filtered in Excel**.

2. Then open the "Start" tab and select the drop-down triangle location below the "Sort & Filter" option.

3. Click the "Filter" button in the options menu that opens.

4. After selection, you can add the function of filtering open combustion to the selected header cell, and click the icon of the drop-down triangle box to filter it.

The method of setting the excel filter condition is as follows: Jane laughs

Tools Raw materials: Mechanical Revolution S3 Pro, Windows 10, Excel 2021

1. Open Excel and select the data you want to operate.

2. Click on the Conditional Formatting option in the Start menu.

3. Then click on the new rule to block Kai.

<>5. Set the cell value to be greater than or equal to 530, and click Format.

6. Then select a color in the pattern options, here green is an example, click OK.

7. Then go back to the previous interface and click OK.

8. In this way, the condition screening is completed.