Numbers : Tables within tables

Something like this might work, but setting it up is tedious, to say the least.

The 'smaller table' inserted in the 'main table' is the only unaltered part here.

All of the cells that are part of the 'main table' are composed of four cells that haver bee merged into one cell.

All cells are editable, and may contain formulas.

The table cannot be sorted, nor can it be filtered, due to the merged cells.

The 'inserted table' can be filled by mirroring a second table (shown above) which would allow locking the main table (including the inserted table) and still being able to edit the contents of the inseted table by editing the table being mirrored, (Shown in the image below)

Regards,

Barry

HI Aceloth,

It's possible to insert an image of a table into a single cell, where it would become 'image fill' for the cell, and would be automatically scaled to fit the cell.

That would lead to a 'tiny' (and unreadable) table unless you either expanded the row and the column containing that cell to make the cell large enough to display the table image.

It is easy to set more than one table on a Sheet, and to move each table into a fixed position relative to the other tables on that sheet. Each table is independent of the others wrt content, formatting, location and resizing.

You could place that table in front of or behind to main table on the sheet, then use colour fill of the cells of the front table to prevent seeing the borders and contents of cells behind it on the main table, or set the borders AND fill of the front table to none and no fill respectively to permit seeing the second table behind the main table.

Regards,

Barry

You can insert a comment and paste contents from a table into that comment. It will format it into a tab delimited version of the table. Your columns are likely to not line up but it's the only "table within a table" I can think of. It is really meant for short snippets of text so don't expect much. If you keep it to two columns and if all entries in your first column have the same number of characters (or all are shorter in length than a tab), it may line up. I do not know what the limitations are in number of characters or number of lines. It is a fixed width so long rows will wrap to the next.