How to Move Rows in Excel: Drag, Cut, Sort

Moving rows in Microsoft Excel is a routine task when reorganizing data, whether you’re reordering a list, grouping related entries, or fixing a mis-sorted table. This guide covers the three most reliable methodsâ€”drag-and-drop, cut and insert, and sort-based reorderingâ€”so you can move single or multiple rows without breaking your spreadsheet’s structure or formulas.

What You’ll Need

Microsoft Excel (2016 or later, including Microsoft 365)
A spreadsheet with data in rows you want to reorder
Basic familiarity with selecting cells and using the mouse or keyboard

Step-by-Step

Method 1: Drag and Drop (Quickest for Small Moves)

Select the row(s): Click the row number on the far left of the sheet (e.g., “3”) to highlight the entire row. To select multiple adjacent rows, click the first row number, hold Shift, and click the last row number. For non-adjacent rows, hold Ctrl while clicking each row number.
Hover over the border: Move your cursor to the top or bottom edge of the selected row(s) until it changes from a white cross to a four-sided arrow (or a hand icon on Mac).
Press and hold Shift: This is the critical stepâ€”holding Shift tells Excel to insert the row(s) at the new location rather than overwriting existing data.
Drag to the new position: While still holding Shift, drag the row(s) up or down. A thick green or gray line will appear showing exactly where the row will be inserted.
Release the mouse button first, then release Shift: The row(s) will move to the new spot, and the rows below will shift down automatically.

Method 2: Cut and Insert (Best for Large Jumps or When Drag is Tricky)

Select the row(s) as described above.
Cut the row: Press Ctrl+X (Windows) or Cmd+X (Mac). You’ll see a moving dashed border around the selected cells.
Select the row below where you want the cut row to land: For example, if you want the cut row to become row 5, click the row number for row 5.
Insert the cut cells: Right-click the selected row number and choose Insert Cut Cells from the context menu. Alternatively, use the keyboard shortcut Ctrl++ (Windows) or Cmd++ (Mac) after selecting the row.
Verify the move: The cut row now appears in the new position, and all other rows have shifted down. No data is overwritten.

Method 3: Sort (Best for Reordering by a Column Value)

Select any cell within the data range you want to reorder (not the entire sheet, unless you want everything sorted).
Go to the Data tab on the ribbon.
Click either the ascending (Aâ†’Z) or descending (Zâ†’A) sort button in the Sort & Filter group. Excel automatically detects the column and expands the selection to include all contiguous rows.
For custom sorting: Click Sort in the same group. In the dialog, choose the column to sort by, the sort order (e.g., cell values), and whether it’s A to Z or Z to A. Add multiple levels if needed.
Confirm the sort: Click OK. The rows will be reordered based on the chosen column’s values.

Common Mistakes

Forgetting to hold Shift during drag: Without it, Excel will overwrite the target cells with the dragged data, destroying existing content.
Selecting only cells instead of entire rows: If you select just a few cells, dragging will only move those cells, not the whole row, leading to misaligned data.
Using Cut + Paste instead of Cut + Insert: Pasting cut cells overwrites whatever is in the destination, whereas Insert Cut Cells shifts existing rows down.
Sorting only one column: If you select a single column and sort, the rest of the row data stays in place, scrambling your records.

Tips

Use keyboard shortcuts for speed: Ctrl+X then Ctrl++ (after selecting the target row) is faster than right-clicking.
Freeze panes if you’re moving rows far apart: Go to View > Freeze Panes to keep header rows visible while scrolling to the destination.
Undo immediately if you make a mistake: Press Ctrl+Z (or Cmd+Z) right after a bad move to revert it.
Check formulas after moving: Excel updates cell references automatically, but if your formulas reference specific ranges, verify they still point to the correct cells.
Use a temporary helper column for complex custom orders: Add a column with numbers 1, 2, 3… in the desired order, then sort by that column and delete it.

Troubleshooting

Drag and drop isn’t working: Make sure you’re holding Shift and that the cursor has changed to the move icon. If it still doesn’t work, try the Cut and Insert method instead. Also check that the sheet isn’t protected (Review tab > Unprotect Sheet).
Rows are being overwritten instead of inserted: This usually means you didn’t hold Shift during drag, or you used Paste instead of Insert Cut Cells. Undo and retry with the correct method.
Sorting messes up the data: This happens when you select only part of the data. Undo the sort, then select any single cell inside the full data range before sorting again. If you have blank columns or rows within your data, fill them or exclude them from the selection.
Formulas break after moving rows: Excel usually adjusts references, but if a formula references a specific cell that moved, it may now point to the wrong place. Check and update formulas manually after the move.
Cannot move rows because of merged cells: Merged cells can block drag-and-drop. Unmerge the cells in the affected rows (select them, go to Home > Merge & Center, and click it to unmerge) before moving.

Frequently Asked Questions

How do I move a row without overwriting existing data?

Use either the drag-and-drop method while holding Shift, or the Cut + Insert Cut Cells method. Both insert the row at the new location and shift existing rows down, preserving all data.

Can I move multiple non-adjacent rows at once?

Yes. Hold Ctrl while clicking row numbers to select non-adjacent rows, then use the Cut + Insert Cut Cells method. Drag-and-drop with non-adjacent rows can be unreliable, so the cut method is recommended.

Why does dragging a row overwrite the cells below it?

Because you’re not holding the Shift key. Without it, Excel treats the drag as a cut-and-paste that replaces the destination cells. Always press and hold Shift before dragging.

How do I move a row to another sheet?

Cut the row (Ctrl+X), then go to the destination sheet, select the row where you want it to appear, right-click and choose Insert Cut Cells. The row will be moved to the new sheet.

Does moving rows affect formulas that reference those cells?

Excel automatically updates cell references in formulas when you move rows, so most formulas will continue to work correctly. However, if a formula references a specific range that the move changes, you may need to adjust it manually.

What is the fastest way to reorder rows alphabetically?

Select any cell in the column you want to sort by, then click the Aâ†’Z or Zâ†’A button on the Data tab. Excel will sort the entire data range based on that column’s values.

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →