Formatting Issues

Can Excel Tables Float Independently on One Worksheet?

John WilsonJohn Wilson Nov 14, 2026 868 views

Question details

The user wants multiple tables on one worksheet with independent sizing and filtering.

Can Excel Tables Float Independently on One Worksheet?
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.
Before you start

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.

Solution 1Recommended

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.

1
Create source worksheets

Use the plus button beside the sheet tabs to add a separate worksheet for each table, then place each table on its own sheet.

2
Format and filter each table

On each source sheet, adjust row heights and column widths and use the table's filter arrows as needed.

3
Copy a table range

Select the cells you want to show on the dashboard and choose Home > Copy.

4
Paste a linked picture

On the dashboard sheet, open the Home > Paste menu and choose Linked Picture if available. Repeat for each source table.

5
Arrange the dashboard

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.

Build independent source tables and display linked pictures
Check the displayed results: Linked-picture availability and rendering can vary by Excel version. Test how the pictures display filtered rows and formatting in your workbook.
Free Microsoft Office alternative

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.

Organize dashboard source tables on separate worksheetsOpen and edit Microsoft Excel XLSX filesWork in a familiar spreadsheet interfaceUse a free, lightweight Office alternative
microsoft office alternative - wps office

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.