How to move columns in excel

Answer

To move columns in Excel, select the entire column by clicking its header, then either drag it to the new location while holding Shift, or use Cut and Insert Cut Cells commands.

Method 1: Drag and Drop with Shift Key

1. Click the column header letter to select the entire column
2. Hover your cursor over the column border until it becomes a four-sided arrow
3. Hold down the Shift key
4. Drag the column to its new position (a green vertical line indicates where it will be placed)
5. Release the mouse button, then release the Shift key

The Shift key prevents Excel from overwriting existing data. Without Shift, Excel replaces the destination column's data.

Method 2: Cut and Insert Cut Cells

1. Right-click the column header you want to move
2. Select "Cut" from the context menu (or press Ctrl+X on Windows, Cmd+X on Mac)
3. Right-click the column header where you want to insert the column
4. Select "Insert Cut Cells" from the context menu

Excel inserts the cut column before the selected column and shifts other columns to the right.

Method 3: Using Keyboard Shortcuts

1. Select the column by clicking its header
2. Press Ctrl+X (Windows) or Cmd+X (Mac) to cut
3. Click the column header where you want to insert
4. Press Ctrl+Shift++ (Windows) or Cmd+Shift++ (Mac) to insert cut cells

Moving Multiple Columns Simultaneously

1. Click the first column header
2. Hold Shift and click the last column header to select consecutive columns
3. Use any of the three methods above to move the selected columns as a group

Non-consecutive columns cannot be moved together in a single operation. Move each column group separately.

Common Issues When Moving Columns

Protected worksheets prevent column movement. Unprotect the sheet through the Review tab > Unprotect Sheet before moving columns.

Merged cells spanning multiple columns block column movement. Unmerge cells first through Home tab > Merge & Center dropdown > Unmerge Cells.

Excel tables require different steps. Click any cell in the table column, then use the drag method with Shift key along the table's edge.

Preserving Formulas When Moving Columns

Excel automatically updates cell references in formulas when you move columns. Absolute references ($A$1) remain fixed to their original positions. Relative references (A1) adjust based on the new column position.

Formulas referencing moved columns update their references automatically. A formula =B2+C2 becomes =C2+D2 when column B moves to position C.

Undo Options for Column Movement

Press Ctrl+Z (Windows) or Cmd+Z (Mac) immediately after moving to undo the action. Excel maintains up to 100 undo levels by default, allowing multiple reversions.

The Quick Access Toolbar's undo button provides a dropdown list of recent actions for selective undoing.

Yes · 0 No · 0 Add Comment · 0

Add ·

Report