Is there a way to move columns in tables in Excel?

Anonymous
2015-09-14T12:46:40+00:00

I cannot find a way to move a column in an Excel table. I would like to do it by drag and drop, of course, not using macros. I also often need to swap two columns in the same table. For example, from 

| Column A | Column B | Column C | Column D | Column E |

to 

| Column A | Column D | Column C | Column B | Column E |

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Anonymous
    2015-09-14T13:12:07+00:00

    Just select the column and drag it to where you want

    Select the column and on the edge of the column when you see fourway arrow drag and drop it to where you want

    OR

    Select the column > Cut the column (ctrl+x) and paste it like below image where you want

    images are shown for example purposes

    46 people found this answer helpful.
    0 comments No comments