The fastest way to move a row in Excel

To move a row in Excel, select the entire row by clicking its number on the left edge, then cut it with 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 pushes other rows down. If you want to swap positions instead of inserting, you can also drag the row directly — select it, position your cursor on the row number until you see a four-way arrow, then drag it up or down to its new spot.

The cut-and-insert method is more reliable because dragging sometimes fails if rows are frozen or if you have filters applied. For moving multiple rows at once, select them all by clicking the first row number, holding Shift, and clicking the last row number you want to move. Then cut and insert as normal — all selected rows move together.

Key Takeaways

  • Click a row number to select the entire row, then use Ctrl+X to cut it and move it to a new location.
  • Right-click the destination row and select "Insert Cut Cells" to move the row and shift other rows down automatically.
  • You can select multiple rows at once by holding Shift and clicking row numbers, then move them all together.
  • Dragging rows works in straightforward spreadsheets but fails when filters or frozen panes are active, so cut-and-insert is the safer method.
  • Moving a row is different from copying it — moving removes the row from its original location, while copying leaves it in place.

Moving a single row step by step

Start by clicking the row number on the left side of the spreadsheet. If you want to move row 5, click the "5" itself — not a cell within that row. The entire row highlights in blue, showing it is selected. This selects every cell in that row, from column A all the way to the last column with data.

With the row selected, press Ctrl+X on Windows or Cmd+X on Mac. You will see the row get a dotted border around it, which means it is cut and ready to move. Now click the row number where you want the row to go. If you want it to become the new row 10, click "10". Right-click that row number and select "Insert Cut Cells" from the menu. Excel moves your row to that position and shifts all the rows below it down by one.

If you change your mind before inserting, press Escape to cancel the cut. The dotted border disappears and the row stays where it was. You can also paste the cut row in a different location by clicking a row number and pressing Ctrl+V, but "Insert Cut Cells" is cleaner because it handles the shifting automatically.

Moving multiple rows at once

To move several rows together, select them all first. Click the number of the first row you want to move, then hold Shift and click the number of the last row. All rows between them highlight in blue. For example, to select rows 3 through 7, click "3", hold Shift, and click "7".

Once all the rows are selected, cut them with Ctrl+X. You will see the dotted border around all of them. Click the row number where you want them to go — if you want them to start at row 15, click "15" — then right-click and select "Insert Cut Cells". All the selected rows move together to the new location, and the rows below shift down to make room.

This method works the same way whether you are moving 2 rows or 20 rows. The rows stay in the same order relative to each other — if row 5 was above row 6 before the move, it will still be above row 6 after the move.

When dragging a row works and when it does not

Excel lets you drag rows directly without cutting and pasting. Position your cursor on the row number until you see a four-way arrow cursor, then click and drag the row up or down. The row moves to the new location and other rows shift to make room. This is faster for moving a single row a short distance in a straightforward spreadsheet.

Dragging fails in several common situations. If your spreadsheet has frozen panes — rows or columns locked in place so they stay visible when you scroll — dragging does not work across the freeze line. If you have filters applied to your data, dragging may move only the visible rows and leave hidden rows behind, which breaks your data. If your spreadsheet is shared or protected, dragging is often disabled. In all these cases, use cut-and-insert instead, which handles these situations correctly.

Moving rows without losing your data

When you move a row, Excel moves the entire row including all its data, formulas, and formatting. If a cell in that row contains a formula that refers to other cells, the formula adjusts automatically. For example, if row 5 has a formula that adds up row 4, and you move row 5 to become row 10, the formula updates to still add up row 4 — it does not change to add up row 9.

However, if other cells in your spreadsheet contain formulas that refer to the row you are moving, those formulas do not update. If cell C2 contains the formula =A5+B5, and you move row 5 to row 10, the formula in C2 still refers to row 5 — it does not automatically change to row 10. Before moving a row that other formulas depend on, search your spreadsheet for any formulas that reference it. Use Ctrl+H to open Find and Replace, search for the row number you are moving, and check what comes up.

Moving rows in filtered or sorted data

If your spreadsheet has filters applied — the small dropdown arrows in the header row — moving rows can be confusing because you see only some of the rows. Cut-and-insert works correctly even with filters active, because it moves the actual row, not just the visible one. Dragging, however, may move only the visible rows and leave hidden rows behind, which scrambles your data.

Before moving rows in a filtered spreadsheet, consider removing the filter first. Click the Data menu, then click "Clear Filter" or click the filter dropdown and select "Clear Filter From [Column Name]". Once the filter is off, all rows are visible and you can move them safely. After you move the rows, you can reapply the filter if you need it.

Sorted data has the same issue. If your rows are sorted by name or date, moving a row manually breaks the sort order. If you need to rearrange sorted data, it is usually better to add a helper column with numbers indicating the order you want, then sort by that column instead of moving rows by hand.

Undoing a row move if something goes wrong

If you move a row and realize it was a mistake, press Ctrl+Z when ready to undo. Excel restores the row to its original location. You can undo multiple times to go back several steps if needed. The undo history stays available until you close the file, so you have time to catch mistakes.

If you close the file without undoing, the move is permanent and cannot be recovered from the undo history. If the file is shared with other people, your move is visible to them as soon as you save, so communicate with your team before moving rows in a shared spreadsheet. Some organizations use version history or backup copies to recover from accidental changes — check with your IT department or file owner if you need to restore an earlier version.

Frequently Asked Questions

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

No, cut-and-insert only moves rows within the same sheet. To move a row to a different sheet, copy the row instead of cutting it, go to the other sheet, right-click where you want it, and select "Insert Copied Cells". Then go back to the original sheet and delete the row manually. This is slower but necessary because Excel does not have a built-in move function across sheets.

What happens to the row number when I move a row?

The row gets a new number based on where you insert it. If you move row 5 to become row 10, it is now row 10 and all the rows that were below it shift up. The original row 5 no longer exists — it is now row 10. Any formulas in other cells that referred to row 5 still refer to row 5, but row 5 now contains different data.

Can I move rows in Excel on my phone or tablet?

Excel on phones and tablets does not support moving rows directly. You can cut and paste rows, but the "Insert Cut Cells" option is not available. On mobile, copy the row to a new location, then delete the original row manually. This is slower than the desktop version, so consider using a computer if you need to move many rows.

Why does dragging a row sometimes not work?

Dragging fails when frozen panes, filters, or sheet protection are active. It also fails if your spreadsheet is very large or if you are using an older version of Excel. If dragging does not work, use cut-and-insert instead — it works in all situations where dragging fails.

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

Moving a data row does not affect the header row — the header stays in place. If you accidentally move the header row itself, undo when ready with Ctrl+Z. Headers should always be in row 1 so that filters and sorting work correctly. If your header row gets mixed in with data rows, your spreadsheet will not function properly.