C. How to set up automatic filtering in Excel when operating Excel

Click on the swipe selection and the options will appear.

Create a workbook object.

workbook workbook = new workbook();

Load an existing excel document.

c:\users\administrator\desktop\");

Get the first worksheet.

worksheet sheet = ;

Get the filter object.

autofilterscollection filters = ;

Set where to add the filter: second column.

Add a filter item.

Testing");Perform filtering. Save the document.

Program Execution Result:

Please refer to the original article.

Sometimes we need to set up Excel protection to prevent the content from being modified, but the customer needs to automatically filter the content.

This can be achieved by the following settings (the following settings were tested in the 2007 version)1Set up automatic filtering (shortcut key Alt + D + F + F)2Protect the worksheet. In this case, you need to select Use Autofiltering as shown in the following figure

Note: The order of operations 1 and 2 must not be reversed. Before you can protect a worksheet, you must have set up automatic filtering.

excel** has a column of field titles, there are records entered for the field title, a row is a record, the field is unique, the record is also unique, first do a good job, and then select the field title, click Autofilter, a small arrow will appear next to it, a small arrow will appear, a small arrow will appear, in the drop-down list, select the conditions you want to filter, you can set the conditions of several fields at the same time, and the records that meet the requirements will be displayed.

"Auto-filtering" is to index all data by columns, and you do not need to set filter conditions when you select "auto-filtering" initially. In the actual use process, you need to set "filter conditions" for a single column or multiple columns to achieve the purpose of filtering.

I don't understand what you mean, so let's go into more detail about the conditions, or the picture above.

1. First of all, open Excel**, click on the functional area "Data", and select "Filter" in the "Sort and Filter" group.

2. In **, we can see that a downward arrow appears after the header column heading, like an inverted small triangle.

4. You can also click the arrow behind "Digital Filter" to customize the automatic filter settings.

5. Then the "Custom Filter" window pops up, for example, if we want to find the data with more than 120 points in Science and Mathematics, we can set it to be greater than or equal to 120 under the display line "Science Mathematics", and then confirm.

6. You can also filter and search by conditions.

7. If you want to cancel the filter and display the results, you can click the arrow after the column header, and then click "Clear filter from xx". Or click Clear in the Sort & Filter group.

Steps: Open Electron - Select the rows you want to filter - Execute the command to filter under "Sort and Filter" - Filter the data.

There is a "Filter" button in the upper right corner of the toolbar, and clicking it will automatically filter.

How to use excel automatic filtering:

1.Select the ** you want to filter on first.

2.Click to start the filter inside - filter or press the Ctrl+Shift+L shortcut on the keyboard.

3.Click the small triangle that is inverted, don't look at which, just filter which one, and use the left button to drop the check.

Open Excel and select the first row of data.

Select the data on the menu bar to filter, and if you want to cancel, you can also press the filter.

The appearance is as shown in the figure below, and each cell has a lower three solution icon, please refer to it.

Hope it helps.

Excel2007 automatic filter settings first enter the relevant data**, and then select the field title, and then select the filter button under the data tab, you can set up automatic filtering, the specific operation steps are as follows:

Select the cell in the first row to which you want to add filtering, then select "Sort & Filter" under the Start menu (on the right side of the toolbar), click on it, and select "Filter" from the drop-down list.

Then a "triangle" icon appears in the header row of the first row, click it, then we can see the filter, and then enter the information to be filtered in the "search" bar (for example, 1601) and then click OK.

If the filter result is as follows, all other data will be hidden, and only the information of the filter conditions will be displayed.

Like-for-like screening. When we are not very comprehensive about a certain type of data, or a certain type of data has common characteristics, let's replace the previous data with an "*" sign. The following filter results are displayed, and data with a digit of "0" is displayed.

Custom filtering.

For example, we can filter the "job salary", and do the same thing, click on the filter symbol, and then click on the "text filter" to select the existing conditions, or click on customization.

The results shown are as follows, and the data showing the salary of the position is greater than or equal to 2000.

Simple, check out the basic application of links.

Do you have a blank line in the middle of each month**. If so, you need to select all the ** data, and then click to turn on the automatic filter function, and then filter it.

There may not be any content that is eligible. Or there's something wrong with the region you've chosen.

If the data structure is clear, you only need to use the offset function with the int, mod, row, and column functions.

Do you need the effect you want to look in?

First of all, open it as shown in the figure below ** for example. Use the left mouse button to click on the content area and let the computer confirm that you need to operate on this **.

Click the drop-down arrow in the "Name" column here, remove the arrow in front of "Select All", and select "Tai'an City", and then you can see that only the data of Tai'an City is left in **, and the drop-down arrow has also become funnel-shaped, prompting the user to have a selection operation here.

In the filter, if there are too many data groups and you can't find the data you want to select, you need to customize the search, as shown in the figure, enter "sunshine" in the blank space under customization, and all the data containing sunshine will be automatically listed below.