Cells outside the table couldn't automatically move down

Copper Contributor

Hi All,

I've used ctrl+t to convert the range to "table".

When I paste new data, why the irrelevant data below the table can not automatically move down ? ( just like automatically insert new rows to keep the irrelevant cells 2 rows below the table)

Few days ago, it could work successfully. But today why it suddenly couldn't ?

Thanks a lot !!!



1 Reply



In general, if you have a table to which you're going to be adding rows, it's good design practice not to have other things below that table, especially not that close. So my only advice--ONLY advice--would be to move those allegedly "irrelevant data" elements someplace else where they're not in the way. And if they're really irrelevant, maybe consider erasing them altogether.