How to Move Columns in Excel

Using the familiar cut-and-paste functions of Excel 2013 indeed moves columns, but this method also overwrites existing data in the new location. Instead, use Excel's Insert Cut Columns function to move columns and shift existing data relative to the relocated columns.

Step

Click and drag your mouse over two or more column headers to select the columns. Alternatively, click a single column header to select it.

Select column headers.
credit: C. Taylor
Cut columns.
credit: C. Taylor

Step

Right-click the selected columns and choose Cut from the pop-up menu. A dashed line appears over the selected columns, indicating they are marked for moving.

Move the columns.
credit: C. Taylor

Step

Right-click the column header located to the right of where the cut columns should appear and select Insert Cut Cells. As an example, if you need to move columns between columns E and F, right-click the F column header and select Insert Cut Cells.

The moved columns
credit: C. Taylor

Step

The cut columns appear to the left of the right-clicked column and shifts existing columns to the left.