The fastest way: cut and insert

To move a row in Excel, select the entire row by clicking its number on the left side, then cut it (Ctrl+X on Windows, Command+X on Mac). Right-click on the row where you want it to go, choose "Insert Cut Cells", and Excel shifts everything else down to make room. Your data stays intact and formulas that reference the moved row update automatically.

This method works because you are telling Excel to physically relocate the row, not copy it. If you use copy-and-paste instead, you end up with the row in two places until you delete the original — which is slower and riskier if you make a mistake.

Key Takeaways

  • Click the row number on the left to select an entire row, then press Ctrl+X (or Command+X) to cut it.
  • Right-click the row where you want the data to go and select "Insert Cut Cells" so Excel shifts other rows down automatically.
  • If you cut and paste without using "Insert Cut Cells", you will create a duplicate row that you have to delete manually.
  • Formulas that point to the moved row update on their own, so you do not have to rewrite them after moving.

When to use drag-and-drop instead

If you only need to move a row a few positions up or down within the same spreadsheet, you can drag it. Select the row number, hold your mouse button down, and drag the row to its new position. A thick line appears between rows to show you where it will land. Release the mouse and the row moves.

Drag-and-drop is faster for small moves but only works within one sheet. If you need to move a row to a different sheet or move it far down a long spreadsheet, cut and insert is more reliable because you can see exactly where the row will go before you confirm.

Moving multiple rows at once

Select multiple rows by clicking the first row number, then holding Shift and clicking the last row number you want to move. All rows in between highlight. Now cut (Ctrl+X) and insert the same way you would for a single row — right-click where you want them and choose "Insert Cut Cells".

Excel keeps the rows in the same order relative to each other. If you select rows 5, 6, and 7, they will stay in that order when you move them, even if you insert them between rows 20 and 21.

What happens to formulas when you move a row

If another cell contains a formula that points to a cell in the row you are moving — for example, =A5+B5 — that formula updates automatically after the move. Excel tracks the cell reference, not its position, so the formula still works correctly in its new location.

The one exception is if a formula uses a range that includes the row you are moving. For example, if a formula says =SUM(A1:A10) and you move row 5, the sum still includes row 5 because the range itself did not change. This is usually what you want, but if you are moving a row that should no longer be part of a calculation, you will need to adjust the formula manually.

Undoing a move if you make a mistake

Press Ctrl+Z (or Command+Z on Mac) when ready after moving a row to undo the move and put everything back where it was. Excel keeps a history of your recent actions, so you can undo multiple steps in a row if needed.

If you have already saved the file after moving the row, undo will not work — the file is locked to its saved state. This is why it is a good idea to move rows one at a time and save only after you are certain the new layout is correct.

Moving rows between different sheets

Cut the row from the first sheet (Ctrl+X), then click the sheet tab at the bottom to switch to the second sheet. Right-click the row where you want it and select "Insert Cut Cells". The row moves from one sheet to the other, and the original sheet loses that row.

If you want to copy the row to a second sheet instead of moving it, use copy (Ctrl+C) instead of cut. Then paste it in the new sheet. The row stays in both places.

Avoiding common mistakes when moving rows

The most common error is using copy-and-paste instead of cut-and-insert. This leaves you with two copies of the row, and you have to remember to delete the original. Using cut from the start saves a step and reduces the chance of accidentally keeping a duplicate.

Another mistake is moving a row that contains a header or label that other rows depend on. If your spreadsheet has a header row at the top that explains what each column contains, moving it will confuse anyone reading the sheet later. Keep header rows at the top unless you have a specific reason to reorganize the entire structure.

If you are moving rows in a spreadsheet that other people use or that feeds data into another program, let them know before you move anything. A row that is in a different position might break a process that expects it in the original location.

Frequently Asked Questions

Can I move a row to a completely different position without it shifting other rows?

No. When you insert a cut row, Excel shifts the rows below it down to make space. If you want to move data without shifting, copy the row instead of cutting it, paste it in the new location, and then delete the original row manually. This takes longer but gives you more control.

What if I move a row and a formula breaks?

Press Ctrl+Z to undo the move and put the row back. Then check which formula broke and whether it should include the moved row. If it should not, edit the formula to exclude that row before moving it again.

Does moving a row change the order of my data if I have it sorted?

Yes. If you have sorted your data by a column, moving a row manually breaks the sort order. Re-sort the data after moving rows if the sort order matters for your work.

Can I move a row to a different Excel file?

Not directly. Cut the row from the first file, open the second file, and paste it there. The row will be in the second file, but you will need to delete it from the first file manually if you do not want it in both places.

What if I move a row and lose track of where it went?

Press Ctrl+Z to undo. If you have already saved, you cannot undo. Open the file again without saving the changes, and the row will be back in its original position. This is why saving only after you are sure of your changes is safer than saving constantly.