How to move a row in Excel (without overwriting data)

Applies to: Excel for Microsoft 365, Excel 2024, 2021, 2019 and 2016 on Windows. The same ideas work on a Mac, using Cmd instead of Ctrl.

Method 1: Shift and drag (fastest)

1. Click the row number on the left to select the whole row. To select several rows next to each other, drag down the row numbers.
2. Point at the top or bottom edge of the selection. The pointer changes to a four-headed move arrow.
3. Hold Shift and drag the row up or down. A thick horizontal line shows where the row will be inserted.
4. Release the mouse button, then release Shift.

The Shift key is what makes this safe. Microsoft calls it Cut and insert: the other rows shift to make room. If you drag without Shift, Excel does a Cut and replace and the moved row overwrites the row you drop it on. If that happens, press Ctrl + Z straight away.

Keys held while dragging	What happens
None	Moves the row and replaces what’s at the destination
Shift	Moves the row and inserts it, pushing other rows down
Ctrl	Copies the row and replaces what’s at the destination
Ctrl + Shift	Copies the row and inserts the copy

Method 2: Cut and Insert Cut Cells

If dragging is fiddly, for example in a long sheet where you’d have to scroll, use cut and insert instead:

1. Click the row number to select the row.
2. Press Ctrl + X (or Home > Cut). A moving dotted border appears around the row.
3. Right-click the row number of the row that should end up below the moved row.
4. Choose Insert Cut Cells.

Don’t use plain Paste here. Paste overwrites the destination row and leaves an empty row where the original was. Insert Cut Cells closes the gap and makes room at the destination in one step.

Method 3: Keyboard only

1. Click any cell in the row and press Shift + Space to select the whole row.
2. Press Ctrl + X to cut it.
3. Move to a cell in the destination row and press Shift + Space again to select that row.
4. Press Ctrl + Shift + + (plus). With a cut row on the clipboard, this inserts it above the selected row, just like Insert Cut Cells.

If Shift + Space selects only part of the row, the cell is inside an Excel table; press it once more, or click the row number instead.

Move several rows, or reorder a whole list

• Rows next to each other: select them all by dragging down the row numbers, then use either method above. They move as one block.
• Rows that aren’t next to each other: Excel can’t move a non-adjacent selection in one go, and cutting one shows This action won’t work on multiple selections. Move them one block at a time, or use the sort trick below.
• Reorder many rows at once: add a helper column, type the order you want (1, 2, 3…) next to each row, then select the data and use Data > Sort on that column. Delete the helper column afterwards.

Move a row to another sheet or workbook

1. Select the row and press Ctrl + X.
2. Click the other sheet’s tab, or switch to the other workbook.
3. Right-click the row number where it should go and choose Insert Cut Cells, or select the first cell of an empty row and press Ctrl + V.

You can also drag a selection to another sheet: hold Alt while dragging over the sheet tab to switch to it. For whole rows, cut and insert is easier to control.

When Excel won’t move the row

• The sheet is protected: moving rows needs editing rights. Unprotect it with Review > Unprotect Sheet if you’re allowed to.
• Merged cells: messages such as To do this, all the merged cells need to be the same size mean the move would split a merged area. Unmerge with Home > Merge & Center, move the row, then merge again.
• A filter is on: clear it with Data > Clear before moving rows, so you can see where the row actually lands.
• Formulas: formulas that point to the moved cells follow them automatically, and formulas inside the moved row keep pointing to the same cells as before. Trouble comes from overwriting: if a plain drag or Paste replaces cells that other formulas use, those formulas show #REF!. Undo and move again with Shift or Insert Cut Cells.
• Drag and drop doesn’t start: make sure File > Options > Advanced has Enable fill handle and cell drag-and-drop ticked.

If Excel itself misbehaves, repair Office: in Windows 11 go to Settings > Apps > Installed apps, select the three dots next to Microsoft 365 (or Office), choose Modify and run Quick Repair. If Office then says it isn’t activated, see Word product activation failed.

Related guides

• How to convert a picture to an Excel table
• Outlook tips that save time every day
• Word product activation failed: how to fix it

Official sources: for more detail, see Microsoft’s own documentation:

• Microsoft Support: Move or copy cells, rows, and columns
• Microsoft Support: Keyboard shortcuts in Excel

Frequently asked questions

How do I move a row up in Excel without overwriting?

Hold Shift while you drag the row’s border, or cut it and use Insert Cut Cells. Both insert the row instead of replacing another one.

Why did moving a row delete my data?

You dragged without Shift or used Paste instead of Insert Cut Cells, so the destination row was replaced. Press Ctrl + Z to undo.

Can I move a row in Excel for the web?

Yes. Cut the row with Ctrl + X, then insert or paste it where you want it. Drag-and-drop behaviour can differ from the desktop app, so cut and insert is the more predictable method there.

Does moving a row break formulas?

No. References to the moved cells update automatically, and formulas in the moved row keep their targets. Only overwriting cells that formulas use, with a plain drag or Paste, causes #REF! errors.