January 24, 2022

How to Swap Columns in Excel

In this lesson we will learn how to move and swap columns in Excel.

Move column means the particular column will be moved to the specific destination column and the adjacent columns at the direction of movement will be shifted to fill the old position of the moved column.

The column movement will be considered as swap if the source column will be moved just to it’s adjacent column’s place. In that case as per the above mentioned rule the column next to it will be shifted to the vacant position of the source column which means those two adjacent columns have been swapped. 

Let’s understand this with a simple example. We have the below table containing different products and their category along with the rate, unit to be delivered and the total price for each product.

Now we will move the column C that is the Total Price to column E.

To do that first select the source column and then place your mouse cursor to the side border of the selected column to the direction of movement. Here we will move column C to the right direction hence we selected the column C and placed the mouse pointer to the right border of column C until the mouse pointer converts to the 4-sided arrow cursor as follows.

Now press the Shift key in your keyboard and drag the source column to the desired place, in our case we have dragged the column C to column E.

Now as you can see the updated column alignment is now as follows. The adjacent columns from the right of column C have been shifted left.

  • Total Price – Has been moved from column C to E.
  • Rate Per Pound – Previously was column D – Now shifted in column C.
  • Unit(in pound) – Previously was column E – Now shifted in column D.

Now let’s swap between column C and D. Here we have selected the column D and placed the mouse pointer to the left border as we will move the column D to left direction. Once the mouse pointer became 4-sided arrow cursor, we have pressed the Shift key and dragged the column D to column C.

Now the column C has been shifted to it’s right that is at the place of column D which means the column C & D have been swapped since they were adjacent.

In this way we can move multiple columns as well. Below we have selected columns C,D & E and moved those to the place of column B.

As you can see below the entire set of columns C,D and E have been shifted left and the column B that is Category has been moved to the place of column E. It can be considered as a swap between column B and the block of columns C,D and E.

You can also check here to know how to swap rows in Excel.

You can also check here to know how to swap rows in Google Sheet.

You can also check here to know how to swap columns in Google Sheet.

Leave a Reply

Your email address will not be published. Required fields are marked *