insert column not possible

Occasional Contributor

When trying to insert column in Excel 2016, I get the message: 
This will not function because it move cells in a table in a sheet (in Danish)

dette vil ikke fungere, fordi det flytter celler i en tabel i et regneark
7 Replies


Such message usually if you try to insert not entire column, but cells and you have some tables on the right. Are you sure that's for entire column?

@Sergei Baklan 






If tables one under another you need to insert column into each of them separately.

No, doesn't work - it just attach a column to the far right column, and can only be done in one table
Just found out it's because I have 3 tables with space between. If it is only one table it's OK
everything OK

@olehansen glad to know you sorted this out, thanks for the feedback