See all How-To Articles

How to Swap / Move Columns – Excel & Google Sheets

This tutorial demonstrates how to swap columns in Excel and Google Sheets.

 

swap move columns initial data

 

Drag Columns

The first option for swapping two columns is to drag one column after another. Say you have the following data set and want to swap the columns Price and Product Name.

 

swap move columns initial data

 

  1. Select the first column (A) and position the cursor to the right border of the column until it turns into the four-sided arrow.

 

swap move columns 1

 

  1. Hold down the SHIFT key on the keyboard and drag and drop the first column to the desired position (after the second column).
    When you press and hold the SHIFT key, you see the green line between columns which indicates where the selected column will be moved.

 

swap move columns 2

 

As a result, columns are now swapped.

 

swap move columns 3

 

Note: Similarly, you can swap multiple columns. Just select as many columns as you need.

Cut and Paste Columns

Another option for swapping columns is to cut and paste a column.

  1. Right-click the heading of a column you want to move (A), and choose Cut (or use the keyboard shortcut CTRL + X).

 

swap move columns 4b

 

  1. Right-click the column heading before which you want to paste the cut column (C), and choose Insert Cut Cells.

 

swap move columns 5a

 

The result is the same: The columns Price and Product Name are swapped.

 

swap move columns 3

 

Move Columns in Google Sheets

Drag to Swap Columns

The easiest way to swap columns in Google Sheets is by dragging a column.

  1. Select the column to move (A) and drag the column heading (the cursor changes to a hand).

 

google sheets swap move columns 1

 

  1. Move the column after the second column (B) and drop. As you move, the vertical line indicates where will the column be placed when you drop the cursor.

 

google sheets swap move columns 2

 

This moves Column A after Column B.

 

google sheets swap move columns 3

 

Move Option in Menu

Unlike Excel, Google Sheets has the option in the menu to move rows or columns. Select the column to move (A), and in the menu, go to Edit > Move > Column right.

 

google sheets swap move columns 4

 

Again, the columns are swapped.

Note: There is also the option to cut and paste a column, but this is the slowest method, as you must delete the empty column after pasting.