Data Import & Export

Apply Independent Filters to Two Excel Tables on One Worksheet

John WilsonJohn Wilson Nov 14, 2026 868 views

Question details

Create separate filter controls for two data ranges on the same Excel worksheet.

Apply Independent Filters to Two Excel Tables on One 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.
Before you start

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.

Solution 1Recommended

Convert Each Data Range Into an Excel Table

Use separate Excel tables to give each range its own filter controls and criteria.

1
Select the first range

Select all cells in the first data range, including its header row.

2
Create the first table

Choose Insert > Table, confirm the selected range, select My table has headers, and click OK.

3
Create the second table

Select the second range and repeat Insert > Table. Confirm its range and header setting, then click OK.

4
Filter each table

Use the drop-down arrows in each table's header row to choose its filter criteria.

Convert Each Data Range Into an Excel Table
Tables that share worksheet rows: Each table has its own filter criteria, but filtering hides entire worksheet rows. If the tables are side by side, filtering one can also hide visible rows in the other.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLSX and XLS filesUse familiar spreadsheet menus and filter controlsWork with a free, lightweight Office suite
microsoft office alternative - wps office

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.