Forum Discussion
Grosner
May 10, 2020Copper Contributor
Excel Sheet Column Move Not Working with Tables and Non-table Cells As Expected.
How can I correctly move a worksheet column that includes a table? When selecting the entire column, then shift+Left Click and dragging, the columns not contained in the table become incorrectly shi...
Grosner
May 11, 2020Copper Contributor
bhushan_z Thank you for your answer. However, since it is possible to Delete or Insert an entire column that also contains a table, it should be possible to move a column . In my case I use additional table total rows that are below the table's inbuilt total row.
The need is to move the entire column in one shot.
bhushan_z
May 11, 2020Iron Contributor
got it,
to keep ur formula intact (which r below table), use Cut Paste.
for example, in ur screenshot, once u drag columns, u can:
1) select F24 to I24
2) Cut
3) Paste it at E24
it won't cause any problem to ur formulas
to keep ur formula intact (which r below table), use Cut Paste.
for example, in ur screenshot, once u drag columns, u can:
1) select F24 to I24
2) Cut
3) Paste it at E24
it won't cause any problem to ur formulas