See all How-To Articles

How to Rearrange / Reorder Columns in Excel & Google Sheets

In this tutorial, you will learn how to rearrange columns in Excel and Google Sheets.

reorder columns initial data

You can easily rearrange columns by dragging or copy-pasting them into a new position. These options work for both normal ranges and tables.

Reorder Columns by Dragging Them

Say you have the following structure of data in the Excel worksheet and want to move Columns B and C to the end (after Column G).

reorder columns initial data

To do this, select Columns B and C, then move the cursor to the right of the selection until the cursor turns into a four-sided arrow. Next, press and hold SHIFT on the keyboard then drag selected columns between Columns G and H until the vertical line appears and drop them.

drag columns excel

As a result, Columns B and C are moved after Column G, making them F and G now. All other columns are shifted left by two.

drag columns excel 2

Reordering rows works in the same way.

Reorder columns by Dragging in Google Sheets

To rearrange columns in Google Sheets, the process is very similar to that in Excel above. Select Columns B and C, click on selected column letters, and drag and drop between Columns G and H.

google sheets reorder columns

Doing this produces the same result as in Excel.

google sheets reorder columns 2