Forum Discussion
laura_protzman
Jan 07, 2019Copper Contributor
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."
RyanPD
May 02, 2019Brass Contributor
I was getting the same error message because I had accidentally chosen the entire columns to be part of the table. I was able to fix by going into Design > Resize Table and selecting the proper range of data.
johnnyBionic
Mar 28, 2023Copper Contributor
Thanks - that worked for me too, although in my case I had selected all rows, e.g. "$A:$D", and thus Excel is not able to insert a new row by moving the others down. The error message is a little unintuitive here. Anyway resizing to "$A$1:$D$150" fixed it 🙂