Forum Discussion
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 do not select entire column from clicking on top
1) select the column of that table only (not entire column)
2) drag the column to the desired place without using 'shift'
it works for me
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.
- 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
