About the filter function in Excel

Sub-aggregation is actually inserted below the last column of the same data arrangement.

One row of data shows the result of the summary of the data in the previous column, however.

I also feel confused, and what makes me confused is why Microsoft's technical staff use the subtotal function but not the sum function.

The problem arises here, because the subtotal function is used to add up the sum of the visible cells in a set of ranges, but does not include the hidden cells, it can be seen that after you filter the summary items, those original data are hidden, so the summary result is 0.

There are two ways to solve this problem, 1. Convert the summary result into a value.

Once all the data is displayed, select all->copy->-paste-> values.

2. Use the replacement function to be"subtotal"Replace with"sum"

Once all the data is displayed, select All->-Replace-> enter them separately"subtotal"with"sum"

Replace them all.

First, click Start, find Sort and Filter at the back, click Filter, so that we can filter directly at the header, and second, press Ctrl plus T to create a super table, and then click on the slicer on it, and check what we need to filter. Click OK to filter as well.

1. Open Excel, select all the titles of the first row, click the "Data" menu in the main menu, and select the filter tool.

2. You can also sort the filtered data, for example, click the drop-down button of the number of dialogues in column d, select the sorting function, and let the numbers in the dialogue series be arranged in descending order, and you can see that the data is arranged and displayed in a way from large to small.

3. You can also select one of the conditions separately, such as entering "promotion" in column A, remove the previous checkmark, and click OK.

4. Then in **, all the numbers in column A will be displayed, and the rest of the data will be hidden.

5. You can also filter the text, such as clicking the keyword drop-down box in column C, selecting the text filter, and then selecting the "containing" condition, entering the included keywords, and then clicking OK.

7. Finally, you can also filter the numbers, such as opening the drop-down box of the D column dialog number series, selecting the number filter, and then selecting the "greater than or equal to" condition.

8. In the input box to the right of "greater than or equal to" under the pop-up custom filter window, fill in the number 5, and then click OK.

9. However, after checking and knowing, in the excel** data, according to the conditions of the D column dialogue series, only the data greater than or equal to 5 is displayed, and the other data are also hidden.

**Filtered below:Operating Equipment: Dell Computer.

Operating system: win10

Operating software: excel2017

<>3. After we click a drop-down button on the page, we can see that there are three sorting functions at the top, "ascending", "descending" and "sorting by color", we can use this function to sort the data first, as shown in the figure.

The shortcut key for filtering is Ctrl+Shift+L. Detailed steps:

1. Check**.

2. Click the menu Sort & Filter to filter.

3. Complete the screening.

4. Shortcut key alt+d+f+f.

5. Complete the screening.

6. Press [Ctrl] [Shift] [L] on the keyboard to achieve quick filtering.

The filter function in the excel software is a very easy to use screening tool, which is often used in our daily work, so what are the excel filter functions? Let's take a look.

What are the functions of excel filtering?

1. First, select the data area you want to filter, this area should also include the title bar, and then click "Sort and Filter" - "Filter" item.

2. At this time, you will find that the "drop-down arrow" is displayed in the title bar. Click the corresponding drop-down arrow, select the items you want to filter from, and click the "OK" button.

4. In addition, for numbers, it also provides a conditional filtering function. For example, when we need to select the employee information of "performance greater than 80", we only need to click the drop-down arrow at the "performance" heading, and select "Number Filter" from the pop-up extended menu.

5. At the same time, it also supports "filter by color", you only need to click the drop-down arrow to select "filter by color", and select the corresponding color at the same time to achieve the filter function. Of course, this is only possible if the cell has been set to a background color.

ohm symbol how to play word document ohm symbol how to play.

Page Setup is in **word where the page is set up.

The shortcut key for excel filtering is Ctrl+Shift+L.

1. Select the columns you want to filter.

2. After selecting the data to be filtered, press the shortcut key Ctrl+Shift+L.

3. Press Ctrl+Shift+L to filter.

4. After entering the filter page, click OK after selection.

5. After clicking OK, the screening is completed.

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" guarantees the practicality of the filter.

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 to indicate which column the next condition is for advanced filtering.

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.

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 the inverted triangle arrow to pop up a drop-down menu to filter items with multiple conditions. For example, if you select "Digital Filtering", 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 by a variety of conditions.

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