Can Excel Tables Float Independently on One Worksheet?
Question details
The user wants multiple tables on one worksheet with independent sizing and filtering.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Building a dashboard with tables that behave like separate floating objects.
- Observed behavior
- Excel tables share the worksheet grid, so changing a row height or column width affects other cells in that row or column, and filtering can hide rows used by an adjacent table.
Identify which tables need independent row heights, column widths, or filters. If you want to use linked pictures, check that your Excel version offers the Linked Picture paste option.
Build independent source tables and display linked pictures
Use separate worksheets for table formatting and filters, then arrange linked pictures on a dashboard.
Excel tables cannot float independently of the worksheet grid. Linked pictures can be moved and resized as objects, but they are displays of the source ranges rather than editable or directly filterable tables.
Use the plus button beside the sheet tabs to add a separate worksheet for each table, then place each table on its own sheet.
On each source sheet, adjust row heights and column widths and use the table's filter arrows as needed.
Select the cells you want to show on the dashboard and choose Home > Copy.
On the dashboard sheet, open the Home > Paste menu and choose Linked Picture if available. Repeat for each source table.
Drag each linked picture to position it, and use its sizing handles to adjust its displayed size. Return to the source sheets to edit or filter the tables.

Place tables on separate worksheets
Keep the tables editable and independently formatted when a single-sheet dashboard is not essential.
Build Spreadsheet Dashboards with WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheet dashboards. Open compatible Excel files and continue your work in WPS Spreadsheets; worksheet tables still share the grid.

Frequently Asked Questions
Can two Excel tables on the same rows have different row heights?
No. Row height applies across the entire worksheet row. Put the tables on separate worksheets if they need different row heights.
Why does filtering one table hide rows in the table beside it?
A table filter hides worksheet rows, not just cells inside that table. If another table uses those rows, its corresponding cells are hidden too. Place independently filtered tables on separate sheets.
Can I edit a table through its linked picture?
No. A linked picture is a display of the source range. Go to the source worksheet to edit the cells or use the table's filter arrows.
Does moving an Excel table make it independent of the grid?
No. Moving a table changes its cell location, but it still uses the row heights and column widths of its new location.




