Forum Discussion

Grosner's avatar
Grosner
Copper Contributor
May 10, 2020

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

3 Replies

  • bhushan_z's avatar
    bhushan_z
    Iron Contributor
    May 11, 2020

    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

    • Grosner's avatar
      Grosner
      Copper Contributor
      May 11, 2020

      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's avatar
        bhushan_z
        Iron Contributor
        May 11, 2020
        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

Resources