China Naming Network - Auspicious day query - How to set the filter in wps table?

How to set the filter in wps table?

1. Specified content of data filtering: 1. Select the contents of the area to filter. 2. Click the Data menu and find the filter. The downward filtering symbol will appear in the header position we just selected. 3. Select the contents of the column to filter in the header. Please refer to the location of the red box column in the above picture. For example, in my example, I want to filter out Monday's language. First, click the small triangle below the Monday cell to expand it, and then the options will pop up. You can directly enter the content to be filtered, or you can select nothing else and only keep the language to be filtered. 4. Click OK, and the following figure will appear, and only the filtered data will be kept. After filtering, the icon has a thumbtack. 2. Data filtering duplicate tag: This function requires paid members in wps. If you don't want to get one, you can skip to method 3 and use the search function. 1. Click the data menu: 2. Look for duplicates in the ribbon under the Data menu. You can refer to the position of No.2 in the picture below. Find "Set to highlight duplicate items" in the "Duplicate items" drop-down menu. 3. The "Highlight Duplicate Value" pop-up window will pop up. 4. After confirmation, the duplicate content will be filtered out and marked. 3. Find the specified content: Whether fishing or working, flexibility is very important, for example, the screening method is tens of millions. Through the search function, you can find the whole article or the designated area, which is very flexible. 1. First search through the menu: 2. You can also search by using the shortcut key Ctrl+F.3. Enter "Language" in the search dialog box, and then click "Find All". 4. Search the whole content for the language shown above. After all or part of the results in the current search window are selected, the contents in the workspace will be selected at the same time. 5. Close the search window at this time.