Tables

Question

Level 1

18 points

Tables

I’m a causal Excel (Windows) user moving to Numbers. I enjoy a lot of things about Numbers. But, there is a learning curve.

I have two tables stacked vertically; table 2 is directly below table 1.

By the end of the year, table 1 will have several hundred entires. Currently, I have a filter on table 1 to show 2 empty rows, with the remaining empty rows hidden. Neither of the tables are locked.

As I add data to table 1, the added rows move (push down) on to table 2. Is the possible to have table 2 move down on the page as rows are added to table 1?

MacBook Pro 15″, macOS 11.6

Posted on Jan 13, 2022 4:41 PM

Reply

Answer 1

Top-ranking reply

Bear34_1 Author

Level 1

18 points

Jan 15, 2022 4:20 PM in response to SGIII

SG & Barry,

Thank you for your thoughts and comments.

I reviewed my tables to see if it was possible they overlapped. While they did not appear to overlap; they were. I had created about 20 extra rows in table 1, but my filter hid the rows because they were empty. I had moved table 2 up the page (canvas) after the filter was applied so it just below table 1, causing the overall.

After removing the filter and deleting the empty rows in table 1, adding additional entires now causes table 2 moves down the page. Perfect!

I don’t recall why I elected to add the additional empty rows and hid them with a filter, but I now realize that was not necessary and created unintended results.

Again, thank you for your help.

Reply

Answer 2

SGIII

Level 8

37,622 points

Jan 13, 2022 6:53 PM in response to Bear34_1

Bear34_1 wrote:

Is the possible to have table 2 move down on the page as rows are added to table 1?

That's the default behavior on my machine. Table 2 moves down automatically on the canvas when I add rows to Table 1.

Unless the tables are already overlapped.

You could try separating them manually to remove the overlap and then add rows to Table 1.

SG

Reply

Answer 3

Barry

Level 9

60,047 points

Jan 13, 2022 10:05 PM in response to Bear34_1

HI Bear'

Got caught up in other things after checking behaviour in Numbers 3.6 (on OS X 10.11 and the current version. Both test documents exhibited the default behaviour:

Adding a row to a Numbers table pushes the table below it down to maintain the space between them. Adding a column has the same effect of a table to the right of the table to which the column was added.

Exceptions occur only when the two tables are verlapped before the rows/columns are added. In this case, the added rows or columns flow over of under the second table, depending on their relative location (front to back) wrt the second table.

Regards,

Barry

Reply

Answer 4

Barry

Level 9

60,047 points

Jan 15, 2022 6:57 PM in response to Bear34_1

Hi Bear,

You are welcome. Thank you for including what you discovered in your reply. Something to make a note of (overlapping could include hidden rows) in future responses.

Regards,

Barry

PS: Happy to see the point awards from you, others and Apple hit one of those odometer milestones. Been keeping an eye on it since it got to 55538 and wondering if it would hit the five fives score. Your Helpful was the one that brought that about:

Reply

Tables

Similar questions