Apply Independent Filters to Two Excel Tables on One Worksheet
Question details
Create separate filter controls for two data ranges on the same Excel worksheet.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A worksheet contains two data ranges with different header rows, and each range needs its own filter settings.
- Observed behavior
- A standard range filter applies to only one header row at a time.
Check that each range has its own header row and that the ranges do not overlap. If possible, place the ranges in different worksheet rows so filtering one does not hide rows in the other.
Convert Each Data Range Into an Excel Table
Use separate Excel tables to give each range its own filter controls and criteria.
Select all cells in the first data range, including its header row.
Choose Insert > Table, confirm the selected range, select My table has headers, and click OK.
Select the second range and repeat Insert > Table. Confirm its range and header setting, then click OK.
Use the drop-down arrows in each table's header row to choose its filter criteria.

Work With Excel Files in WPS Spreadsheets
WPS Office is a free, lightweight Office alternative with a familiar spreadsheet interface and Excel format compatibility for an easier transition. For workflows that rely on multiple Excel table filters, check that the workbook behaves as needed in WPS before switching.

Frequently Asked Questions
Can I use Format as Table instead of Insert > Table?
Yes. Select the range, choose Home > Format as Table, pick a style, and confirm the range and header setting. Repeat for the second range.
Why does filtering one table hide rows in the other?
Excel hides entire worksheet rows when a filter excludes records. If the tables share those rows, parts of both tables will be hidden. Move the tables to different rows to avoid this.
How do I clear a filter from one table?
Open the filter drop-down in the filtered column and select Clear Filter From that column. Repeat for any other filtered columns in the table.
What if I don't see filter arrows in a table?
Click inside the table and check the Filter Button option on the Table Design tab. Also confirm that the range was converted into a table rather than only formatted to look like one.




