How to add a category to an existing filter item in an excel sheet

As follows:

Operating Equipment: Dell Computer.

Operating system: win10

Operating software: excel2017

1. First open **, select the content, and turn on the filter function.

2. Then click the drop-down arrow of the filter row to enter the filter condition setting page.

3. Then, under Text Filter, select Criteria.

4. Then enter the filter conditions and click Refer to OK.

5. After the grinding and bending is determined, you can add options to the ** filter.

You can follow the steps below to set the filtering options and add the filtered content in the cell:

First, select the cell for which you want to set the filter options.

In the menu bar in Excel, find the Data tab, click the Filter button, and select Filter or Advanced Filter.

In the filter window that pops up, you can select the criteria you want to filter and the column in which the condition is located. For example, if you want to filter for a specific name, select the Name column and enter the name.

Click "OK" and press the button to show the data that meets the criteria based on your filter criteria.

If you want to add more filters, you can select a column again in the filter window and enter another filter. Excel filters the data based on multiple criteria.

If you want to unfilter, you can click the "Filter" button in the "Data" tab again and select "Clear Filter".

With the above steps, you can set filtering options in cells and add filtered content to filter and manage data in Excel more easily.

1. Open Excel** and click Validity under the data option.

2. Fill in the validity conditions, click OK, and then click the ** icon to select.

This article takes Huawei MateBook X Pro as an example for Windows 10 with WPS version.

The following steps are performed to set up filtering:

1.First, use the mouse to select the top row of the front cavity bending table of the silver stuffy unit to be screened.

2.Click the circle and click the filter function in the menu bar to filter.

Select the area you want to filter (the area cannot be empty), data-filter--the drop-down menu appears on the first row of the filtered area - click on the data matching data area you want to filter.