How can I keep tables aligned when they're resized?

Hi FleursDuMois or JRiether (I am not sure),

You need a tiny gap between the two tables to tell Numbers that they are separate tables, and you have not "merged" two tables into one table. Sometimes, Numbers is too clever and makes a guess as to our aim.

I have hidden the Title of Table 2.

Now add another row to table 1 with new data

Regards,

Ian.

Hi FleursDuMois,

This may work for you.

You can have up to 5 Footer rows in a Numbers table.

Here is a table with 1 header row and 5 Footer rows. I added colour fill to those rows to make them stand out.

The Footer rows can contain formulas to calculate results from the body of the table. When you add or delete (or hide) rows, the table will resize and the Footer rows will move with the table.

Regards,

Ian.

Thank you, Ian, but without going into boring detail...suffice it to say I need about 12-15 rows in the 2nd table. I also am in the camp that each table should serve its purpose...not fall into the monolithic Excel spreadsheet model.

I've had Numbers spreadsheet pages where the tables would behave, but there's no documentation to explain why tables shift around under what circumstances. I lock everything on the page that must stay in place, but these other table elements must float together, "pinned" to one another.

If grouping could be adapted to this purpose, that would make logical sense. Alas, it doesn't appear you can group tables. ...And even then would that guarantee they'd stay pinned together the same way as their rows and/or columns add or contract?

Hi SG,

I have not been away. I have been following Numbers for Mac, but recently I have not been able to contribute a meaningful reply to a post. Please feel free to jump into this post.

Regards,

Ian.

Hi Ian. Good to see you back posting here!

SG