Forum Discussion
Getting this message: "This won't work because it would move cells in a table on your worksheet."
When I try to insert a row in a formatted table, I get the following message: "This won't work because it would move cells in a table on your worksheet."
Do you have another table below the one you are trying to insert the row in?
If so you could just insert a sheet row rather than a table row (providing that doesn't mess anything up to the right or left of your table)
What is interesting, if another table is in exactly the same columns
Excel doesn't care about that and inserts rows into the first table shifting everything down
- Yes, it’s essentially inserting cells for the row of the table so if that moves the whole lower table it’s fine but if it’s just part of the table that’s not possible