How to Move Columns and Rows in Excel Without Overwriting

The safest way to move columns in Excel is to hold Shift while you drag, or to cut the column and use Insert Cut Cells. Both slide the column into its new place and push the others aside, so nothing gets overwritten. This guide shows both methods for columns and rows, how to reorder many columns at once, and what happens to your formulas when data moves.

How to move a column by dragging (Shift+drag)#

Shift+drag inserts the column between two others. It is the quickest method once you have done it a few times.

1. Select the column. Click its letter at the top, or click a cell and press Ctrl+Space.
2. Point at the edge of the selection. Move the mouse to the left or right border of the highlighted column until the cursor changes to a four-way arrow (on a Mac, a small hand).
3. Hold Shift and drag. Keep Shift pressed and drag sideways. A thick green line shows where the column will land.
4. Release the mouse, then Shift. The column drops in at the green line and the other columns shift over.

The key is Shift. If you drag without it, Excel tries to put the column on top of the cells that are already there and asks, "There's already data here. Do you want to replace it?" Click Cancel and try again with Shift held down.

Two related drags are worth knowing:

How to move a column with Cut and Insert Cut Cells#

If dragging feels fiddly, use the keyboard and a right-click instead. This is also better for long moves, for example from column B to column Z.

1. Select the column and press Ctrl+X (Mac: ⌘X). A moving dotted border appears around it.
2. Right-click the column letter where the moved column should go. It will be placed to the left of this column.
3. Choose Insert Cut Cells.

On Windows you can press Ctrl+Shift+= instead of right-clicking: when cells are cut, that shortcut inserts them rather than inserting blank cells.

Don't use plain Paste (Ctrl+V) here. Paste writes over whatever is in the target column. Insert Cut Cells makes room first. The copy, cut and paste lesson practises the difference, and the guide to inserting and deleting rows and columns covers the insert shortcuts in more detail.

How to move rows in Excel#

Rows move exactly like columns. Select the row (click its number, or press Shift+Space), then either:

• Shift+drag its top or bottom edge up or down, or
• Cut it, right-click the row number below where it should go, and choose Insert Cut Cells.

You can also move just a block of cells instead of whole rows. Shift+drag a selected range and Excel shifts the neighbouring cells to make space. Moving whole rows or whole columns is safer, though, because it keeps every record lined up.

How to move several columns at once#

You can move several columns in one go if they are next to each other. Select them all (click the first letter, then Shift+click the last), and Shift+drag or cut and insert them together.

Columns that are not next to each other can't be moved in one step. If you select B and E with Ctrl and try to cut them, Excel shows a message that the action won't work on multiple selections. Move them one block at a time.

Reorder many columns with a sort#

To put ten columns into a completely new order, sorting is faster than dragging each one.

1. Insert a blank row above your headers.
2. In that row, type the new position for each column: 1 for the column that should be first, 2 for the next, and so on.
3. Select the data including the number row, then go to Data > Sort > Options and choose Sort left to right.
4. Sort by the helper row, smallest to largest, and click OK.
5. Delete the helper row.

The columns now sit in the order of your numbers. If you have Microsoft 365 or Excel 2024, CHOOSECOLS gives a reordered copy with a formula instead, for example =CHOOSECOLS(A1:E20,3,1,2), but the original data stays as it was.

What happens to formulas when you move a column?#

Most formulas keep working, because Excel updates references to point at the cells' new address. If F2 holds =C2*D2 and you move column C to the front so it becomes column A, the formula changes to =A2*D2 by itself and gives the same result.

There are three cases to watch:

• VLOOKUP and HLOOKUP column numbers don't change. =VLOOKUP(E2,A2:D9,3,FALSE) returns the 3rd column of the range. If you move a different column into that position, VLOOKUP quietly returns the wrong data. XLOOKUP and INDEX MATCH point at the column itself, so they follow the move.
• Copying is not moving. If you copy and paste instead of cutting, the original formulas still point at the old cells, and the pasted ones shift relative to their new place.
• Overwritten cells become #REF!. If you drag a column on top of cells that other formulas use and click OK at the warning, those formulas lose their cells and show #REF!.

If you only move columns because a lookup needs the ID on the left, you may not need to move anything. XLOOKUP can look in any column and return any other, so =XLOOKUP(E2,C2:C6,A2:A6) finds an ID in column C and brings back the name from column A. That is the exercise on this page. XLOOKUP needs Excel 2021 or Microsoft 365; in older versions, =INDEX(A2:A6,MATCH(E2,C2:C6,0)) does the same.

Why can't I move a column in Excel?#

When a move fails, the cause is usually one of these:

• Merged cells. Excel can't move part of a merged cell. Unmerge the cells first, or select whole columns that contain the full merged area.
• A protected sheet. Moving columns is blocked until you unprotect the sheet (Review > Unprotect Sheet).
• A filter is on. Moving rows inside a filtered list can give surprising results. Clear the filter first (Data > Clear).
• Hidden columns in the selection. They move too. If something seems to vanish, check for hidden columns; see how to hide and unhide rows and columns.
• You are still editing a cell. Press Esc first, then try again.

Tips for moving data quickly#

A few habits make moving columns faster and safer:

• Jump instead of scrolling. Press Ctrl+Arrow (Mac: ⌘+Arrow) to reach the edge of your data before you insert. The guide to jumping with Ctrl+Arrow shows how.
• Need a gap? Insert empty columns first; the article on inserting multiple rows and columns covers that.
• Undo works. If a move goes wrong, press Ctrl+Z (Mac: ⌘Z) straight away.
• Freeze values before big rearrangements. If a column holds formulas you no longer need live, paste them as values first so nothing can break.

Practise it#

Moving data is a skill you learn with your hands, not by reading. Practise working with rows and columns in a live spreadsheet, then try the copy, cut and paste lesson to get Cut and Insert Cut Cells into muscle memory. The exercise on this page shows how XLOOKUP can save you the move altogether.