How To Move A Column In Google Sheets

In this tutorial, you will learn how to move a column in google sheets.

It can be frustrating to realize data columns in Google Sheets are out of order. At first it may seem like a lot of work to arrange your data correctly, but there’s no need to manually copy and past your data to reorder columns: You can move columns in Google Sheets easily with just a few clicks by following these steps:

Step 1

Click on the column header for the column you want to move. The entire column will highlight to show it’s selected

Step 2

Click and drag the column header to move the column right or left in the spreadsheet. A vertical grey line will highlight the location the column will move to when you release the mouse

Step 3

When the grey line is where you want it, release the mouse and the column will move to that location

Step 4

Repeat as needed till all columns are in the desired location

Step 5

Note you can move multiple adjacent columns in this way. Simply hold down shift while selecting them in Step 1

Quick Navigation


Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to move a column in google sheets. Want more? Check out all the Google Sheets Tutorials.