How to Filter Excel Rows That Contain Yes in Multiple Columns in WPS Office
Question details
User wants to display only Excel rows that contain an entry such as Yes in both the Shallow Overlay and Bridge Replacement columns and hide all other rows.
- Product
- WPS Office Excel
- Device & OS
- not provided
- Scenario
- Filtering a job-record worksheet to isolate rows where two specific columns both contain Yes or another non-blank entry.
- Observed behavior
- The worksheet currently shows all records, including rows where one or both of the specified columns are blank.
Make sure your data has a header row and no merged cells in the filter range, because AutoFilter uses the header row to create the filter arrows.
Filter the Shallow Overlay and Bridge Replacement Columns to Show Only Rows with Yes Entries
Use this method when you need to hide all rows where either the Shallow Overlay column or the Bridge Replacement column is blank, keeping only job records that have an entry in both.
Excel AutoFilter applies a separate filter to each column. When you clear blank values in both target columns, only rows with a value in both remain visible; rows with blanks in either column are hidden.
Click any cell inside the job-record range that contains the Shallow Overlay and Bridge Replacement columns, then go to the Data tab and confirm that Filter is enabled.
Click the filter arrow in the Shallow Overlay column header, clear the (Blanks) checkbox, and click OK.
Click the filter arrow in the Bridge Replacement column header, clear the (Blanks) checkbox, and click OK.
Excel now displays only rows that contain an entry in both the Shallow Overlay and Bridge Replacement columns.
Filter Yes Rows Across Multiple Columns with WPS Office Excel
WPS Office Excel includes the same AutoFilter tools you need to isolate rows where multiple columns contain Yes. You can apply column filters, hide blanks, or use Text Filters to keep only the records you want.
- 1. Download WPS Office: Go to the WPS Office download page, download the installer, and install WPS Office on your computer.
- 2. Open the Excel workbook: Launch WPS Office Excel and open the workbook that contains the Shallow Overlay and Bridge Replacement columns.
- 3. Enable AutoFilter: Click any cell in the data, go to the Data tab, and confirm the Filter button is active so filter arrows appear in the header row.
- 4. Apply column filters: Clear the (Blanks) checkbox in both target columns or use Text Filters > Equals to keep only rows that contain Yes.
Frequently Asked Questions
Can I filter for the exact word Yes instead of just clearing blanks?
Yes. Click the filter arrow in the column, choose Text Filters > Equals, type Yes, and click OK. Repeat the same step for the second column.
How do I clear the filter when I want to see all rows again?
Go to the Data tab and choose Clear, or click the filter arrow in the column and select Clear Filter from the column.
Why don't filter arrows appear in my Excel columns?
Click inside the data range, open the Data tab, and enable Filter. Make sure the first row contains headers and that no merged cells block the header range.
Does this work in WPS Office Excel the same as Microsoft Excel?
Yes. WPS Office Excel supports the same AutoFilter behavior, so you can hide blanks or filter by Yes in multiple columns and save as .xls or .xlsx.
What if I need to filter more than two columns?
Repeat the same process on each additional column. Excel combines the active column filters so only rows matching all filters remain visible.
