Others

How to Keep Excel Summary Tables Visible While Filtering

Maira Mehtab Sep 20, 2026 868 views

Question details

The user wants to prevent accounting and summary tables located next to a purchase tracker from disappearing when applying filters to the tracker.

Product: Excel
Device & OS: not provided
Scenario: Filtering data in a purchase tracker table that has side-by-side summary tables.
Observed behavior: When rows in the main purchase table are filtered out, the adjacent rows containing the summary tables are hidden as well.

Before you start

Before rearranging your spreadsheet layout, understand that Excel row filters apply to the entire worksheet row across all columns, not just the selected table.

Solution 1Recommended

Move Summary Tables Above the Filtered Data

Relocate your totals and summary tables above or below the main tracker to prevent them from being hidden by row filters.

Excel filters work on a row-by-row basis across the entire worksheet. When you filter a table, Excel hides the entire row, which inadvertently hides any data placed beside it in adjacent columns. The most effective way to solve this is by restructuring your layout.

Insert New Rows

Select the rows above your purchase tracker, right-click the row numbers, and choose 'Insert' to create enough empty space for your summary tables.

Relocate Summary Data

Highlight your existing accounting and summary tables located at the side of the tracker, cut them (Ctrl+X), and paste them (Ctrl+V) into the newly created rows above.

Apply Filters

Apply your filters to the purchase tracker using the Data tab. Your summary tables will now remain fully visible at the top of the sheet regardless of how the tracker is filtered.

Layout Best Practice: Placing summary data above your main datasets is a widely recommended Excel best practice. It prevents filtering conflicts and keeps your most important metrics instantly visible.

Efficient Data Management

Organize and Filter Tables Effortlessly in WPS Spreadsheet

WPS Spreadsheet provides a highly compatible and intuitive interface for managing complex data layouts, ensuring your summary tables and trackers work seamlessly together without filtering conflicts.

1. Open your spreadsheet: Launch WPS Spreadsheet and open your tracker document.
2. Rearrange your layout: Highlight your summary tables, hover over the border until the cursor changes, and drag them to the rows above the main tracker.
3. Filter without issues: Select your tracker headers, navigate to the 'Data' tab, and click 'Filter' to manage your transactions while keeping summaries completely visible.

Fully compatible with Microsoft Excel (.xlsx and .xls) formatsIntuitive drag-and-drop cell management for quick layout changesAdvanced filtering and data analysis tools built-inFree and lightweight alternative for everyday office tasks

microsoft office alternative - wps office

Frequently Asked Questions

Why does my summary table disappear when I filter another table?

Excel applies filters to entire rows across the spreadsheet. If your summary table is situated on the same rows as the filtered data, those rows will be hidden entirely when the filter is active.

Can I filter just one specific column without affecting adjacent columns?

No, standard Excel filters hide entire rows, not individual cells. To analyze data without hiding adjacent cells, you should use features like PivotTables or keep independent tables on separate worksheets.

Is there a way to keep side-by-side tables without them affecting each other?

The most effective approach is to avoid placing independent tables side-by-side. Instead, arrange them vertically (one above the other) or utilize separate worksheet tabs to prevent filtering conflicts.

Does WPS Office handle table filtering the same way as Microsoft Excel?

Yes, WPS Spreadsheet offers high compatibility with Excel and applies row-based filtering in the exact same manner, ensuring your layouts and files behave consistently across both platforms.

Office Quick Solutions