Excel Sheet Column Move Not Working with Tables and Non-table Cells As Expected.

%3CLINGO-SUB%20id%3D%22lingo-sub-1378446%22%20slang%3D%22en-US%22%3EExcel%20Sheet%20Column%20Move%20Not%20Working%20with%20Tables%20and%20Non-table%20Cells%20As%20Expected.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1378446%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20can%20I%20correctly%20move%20a%20worksheet%20column%20that%20includes%20a%20table%3F%3C%2FP%3E%3CP%3EWhen%20selecting%20the%20entire%20column%2C%20then%20shift%2BLeft%20Click%20and%20dragging%2C%20the%20columns%20not%20contained%20in%20the%20table%20become%20incorrectly%20shifted%20or%20misaligned.%20See%20the%20image%20for%20an%20example%20of%20what%20happens%20after%20dragging%20column%202%20to%20be%20located%20after%20column%203.%20(All%20columns%20were%20initially%20aligned).%26nbsp%3B%3C%2FP%3E%3CP%3EUsing%20Excel%20Insider%20Version%202006%2012829.20000.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Excel%20Worksheet%20Sheet%20Column%20Move%20With%20Table%20Not%20Working.gif%22%20style%3D%22width%3A%20930px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F190474iFF0F66DE4FA14262%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Excel%20Worksheet%20Sheet%20Column%20Move%20With%20Table%20Not%20Working.gif%22%20alt%3D%22Excel%20Worksheet%20Sheet%20Column%20Move%20With%20Table%20Not%20Working.gif%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1378446%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1379130%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Sheet%20Column%20Move%20Not%20Working%20with%20Tables%20and%20Non-table%20Cells%20As%20Expected.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1379130%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F366980%22%20target%3D%22_blank%22%3E%40Grosner%3C%2FA%3E%26nbsp%3Bdo%20not%20select%20entire%20column%20from%20clicking%20on%20top%3C%2FP%3E%3CP%3E1)%20select%20the%20column%20of%20that%20table%20only%20(not%20entire%20column)%3C%2FP%3E%3CP%3E2)%20drag%20the%20column%20to%20the%20desired%20place%20without%20using%20'shift'%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eit%20works%20for%20me%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1380661%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Sheet%20Column%20Move%20Not%20Working%20with%20Tables%20and%20Non-table%20Cells%20As%20Expected.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1380661%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F662966%22%20target%3D%22_blank%22%3E%40bhushan_z%3C%2FA%3E%26nbsp%3B%20Thank%20you%20for%20your%20answer.%20However%2C%20since%20it%20is%20possible%20to%20Delete%20or%20Insert%20an%20entire%20column%20that%20also%20contains%20a%20table%2C%20it%20should%20be%20possible%20to%20move%20a%20column%20.%20In%20my%20case%20I%20use%20additional%20table%20total%20rows%20that%20are%20below%20the%20table's%20inbuilt%20total%20row.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EThe%20need%20is%20to%20move%20the%20entire%20column%20in%20one%20shot.%3C%2FSTRONG%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1380711%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Sheet%20Column%20Move%20Not%20Working%20with%20Tables%20and%20Non-table%20Cells%20As%20Expected.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1380711%22%20slang%3D%22en-US%22%3Egot%20it%2C%3CBR%20%2F%3Eto%20keep%20ur%20formula%20intact%20(which%20r%20below%20table)%2C%20use%20Cut%20Paste.%3CBR%20%2F%3Efor%20example%2C%20in%20ur%20screenshot%2C%20once%20u%20drag%20columns%2C%20u%20can%3A%3CBR%20%2F%3E1)%20select%20F24%20to%20I24%3CBR%20%2F%3E2)%20Cut%3CBR%20%2F%3E3)%20Paste%20it%20at%20E24%3CBR%20%2F%3Eit%20won't%20cause%20any%20problem%20to%20ur%20formulas%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

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 shifted or misaligned. See the image for an example of what happens after dragging column 2 to be located after column 3. (All columns were initially aligned). 

Using Excel Insider Version 2006 12829.20000.

Excel Worksheet Sheet Column Move With Table Not Working.gif

3 Replies
Highlighted

@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

Highlighted

@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.  

 

Highlighted
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