The simplest way to move a row in Excel

To move a row in Excel, select the entire row by clicking its number on the left side, then cut it using Ctrl+X (or Cmd+X on Mac). Click the row number where you want it to go, right-click, and choose "Insert Cut Cells". The row moves to that location and everything else shifts to make room.

This method works because Excel treats a cut row as something that needs to be inserted, not just pasted. If you use regular paste instead, you'll overwrite the row you're pasting into rather than moving it. The "Insert Cut Cells" option is what prevents that problem.

The whole process takes about ten seconds once you know the steps. Most people get stuck because they try to paste instead of insert, or because they don't realize you need to select the entire row first — clicking a single cell in that row won't work.

Key Takeaways

  • Click the row number on the left to select the entire row, not just a cell within it.
  • Cut the row with Ctrl+X, then right-click the destination row and choose "Insert Cut Cells" to move it without overwriting.
  • If you need to move multiple rows at once, click the first row number, hold Shift, and click the last row number to select them all before cutting.
  • Moving a row shifts all the other rows down or up automatically — you don't need to manually adjust anything else.

Selecting a single row correctly

The first mistake people make is clicking inside a cell instead of on the row number itself. If you click on a cell, you've only selected that one cell, and cutting it will only cut that cell's contents. You need to click the number on the far left edge of the spreadsheet — the row header.

When you click the row number, the entire row highlights in blue or gray depending on your version of Excel. You'll see the row number itself is also highlighted. That's how you know you've selected the whole row, not just one cell.

If you're on a Mac using Excel, the process is identical except you use Cmd+X instead of Ctrl+X. Everything else stays the same.

Cutting and inserting the row in its new location

Once the row is selected, press Ctrl+X to cut it. You'll notice the row gets a dotted border around it — that's Excel showing you the row is cut and ready to move. Don't click anywhere else or the cut will cancel.

Now click the row number where you want the cut row to go. This is the row that will shift down to make room. Right-click on that row number and look for "Insert Cut Cells" in the menu that appears. Click it, and your row moves into that position. Everything below it shifts down automatically.

If you accidentally click "Paste" instead of "Insert Cut Cells", the cut row will overwrite the row you clicked on instead of moving into position. If that happens, press Ctrl+Z when ready to undo and try again with the right option.

Moving multiple rows at the same time

If you need to move several rows together, select them all before cutting. Click the first row number, then hold Shift and click the last row number in the group. All the rows between them will highlight, showing they're all selected.

From there, the process is the same: Ctrl+X to cut, then right-click the destination row and choose "Insert Cut Cells". All the selected rows move together as a block, keeping their order intact.

This is much faster than moving rows one at a time, especially if you're reorganizing a large spreadsheet. The rows stay in the same order relative to each other — the first row you selected will still be above the second row after the move.

What happens to formulas and references when you move a row

If your spreadsheet has formulas that reference cells in the row you're moving, those formulas will automatically update to point to the row's new location. Excel tracks the cells, not their position, so a formula that said "add up row 5" will now add up whatever row number that data moved to.

This is different from copying and pasting, where the formula references stay the same. Moving is safer for this reason — you don't have to worry about formulas breaking or pointing to the wrong place.

If you're moving a row that other rows depend on, those dependencies move with it. The formulas in other rows that reference the moved row will still work correctly because Excel updated them automatically.

Moving rows without losing data below them

The key to not losing data is using "Insert Cut Cells" instead of regular paste. When you use "Insert Cut Cells", Excel creates space for the row you're moving. When you use regular paste, it overwrites whatever was already there.

If you're worried you might accidentally overwrite something, you can always undo with Ctrl+Z. Excel keeps a history of your recent actions, so even if you make a mistake, you can step back and try again. Most people undo at least once while learning this process.

A safer approach if you're nervous: before you move anything, scroll down and check what's in the rows below where you're moving to. That way you know what's there and can decide if it's safe to insert the row at that location.

Using drag-and-drop to move rows (when it works)

Excel also lets you drag rows by clicking and holding on the row number, then dragging it to a new location. However, this method is unreliable — it sometimes pastes instead of inserts, which overwrites your data. The cut-and-insert method is more predictable and works the same way every time.

Drag-and-drop can be faster if you're moving a row just a few positions, but the risk of accidentally overwriting data makes it not worth the speed gain. Stick with cut and insert if you want to be certain nothing gets lost.

If you do try drag-and-drop and something goes wrong, Ctrl+Z will undo it when ready. But the cut-and-insert method is what most people rely on because it's clearer what's happening at each step.

Frequently Asked Questions

What's the difference between moving a row and copying it?

Moving removes the row from its original location and puts it somewhere else. Copying leaves the original row where it is and creates a duplicate in the new location. If you want to keep the original row, use copy. If you want to reorganize and remove it from where it was, use move.

Can I move a row to a different sheet in the same workbook?

Not directly with cut and insert. You have to cut the row, switch to the other sheet, right-click a row number, and paste it there. It will paste as a regular paste, not an insert, so you may need to manually insert a blank row first if you don't want to overwrite existing data.

What happens if I move a row that has a header or label in it?

The header moves with the row. If you're moving data rows but want to keep the header at the top, don't select the header row — only select the data rows below it. Headers usually stay in row 1 for a reason, so moving them can make your spreadsheet confusing.

Can I undo a row move if I change my mind?

Yes. Press Ctrl+Z when ready after moving the row, and it goes back to where it was. Excel keeps a history of recent actions, so you can undo multiple moves if you need to. If you wait too long or close the file, the undo history is lost.

Why does my row move create a blank row in the original location?

It shouldn't if you used "Insert Cut Cells" correctly. If you see a blank row where the moved row used to be, you probably used regular paste instead of insert. Undo with Ctrl+Z and try again, making sure to right-click and choose "Insert Cut Cells" this time.