How to Rearrange / Reorder Columns in Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on May 22, 2023

This tutorial demonstrates 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

Select Columns B and C, and 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. Release the mouse to 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

The process for rearranging columns in Google Sheets, is very similar to the Excel process above.

  1. Select Columns B and C.
  2. Click on selected column letters.
  3. 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

AI Formula Generator

Try for Free

See all How-To Articles