How to Move a Row in Excel

To move a row in Excel for Windows, select its row number and cut it. Right-click the destination row heading and use Insert Cut Cells. This inserts the record between existing rows instead of pasting over another record.

Use the row numbers at the sheet's left edge so every cell in the record travels together. Save the workbook before rearranging important data.

Cut the full record and choose its destination

Suppose an orders sheet has Cedar in row 3, Maple in row 4 and Birch in row 5. To place Birch before Cedar, select the 5 row heading and press Ctrl + X.

Right-click the 3 row heading and select Insert Cut Cells. Birch should become row 3, Cedar row 4 and Maple row 5. The names identify the records even though their worksheet numbers change.

Status: Excel's move-and-insert commands and platform-specific dragging checked October 31, 2026. The three-record example is illustrative, not a tested workbook.

Microsoft documents row insertion after cutting in its moving guide. For Excel in a browser, the same guide specifies Cut, then Insert Cut Cells from the destination heading.

Choose the record that should follow the moved row as the destination. For downward moves, pay particular attention to that record's name: row numbers change when the source row leaves its original position.

Move neighboring rows as a group

Select consecutive row headings before cutting to relocate several records together. Review the first and last selected records so an adjacent heading or total does not join the move accidentally.

Microsoft says row moves include contained formulas, formatting, comments and hidden cells. If the record's scope is unclear, reveal the hidden rows and columns before selecting it.

A worksheet row extends across the sheet. If unrelated data sits beside the table, a whole-row move will affect that data too. Work on a saved copy and choose a table-specific edit when only that table should change.

For empty space where a new record will be typed, use Excel's blank-row insertion controls. Moving an existing record does not create a second copy of it.

Prefer an insertion drag when using the mouse

In Windows desktop Excel, select the row heading, point at the selection's edge, then hold Shift while dragging it to the desired insertion position. Release the mouse before releasing Shift.

Microsoft states in its Excel keyboard reference that Shift-drag inserts the moved selection. An ordinary drag can replace destination contents instead.

On Mac, Microsoft's moving guide also documents Shift-drag between existing rows to make room. Start at the selection's edge, not the small fill handle. That handle performs a different operation.

Do not transfer the Windows desktop dragging rules to Excel in a browser: Microsoft's web instructions list different modifiers. Use the named cut-and-insert commands there when avoiding replacement is the priority.

Check the records before making another move

Read the moved record across its columns, then check its immediate neighbors. The record count should be unchanged, and a name should still sit beside its own dates and amounts.

Inspect formulas and important totals after the rearrangement. If a record disappeared, undo immediately before making more edits; do not try to repair the order by moving additional rows around.

If the command is unavailable or the workbook reports a selection error, cancel the cut with Esc. Check with the workbook's owner about sheet protection, merged cells and the intended editable range.

If an ordinary unprotected sheet fails too, tell Microsoft Support which Excel release and operation produced the error. Specify the desktop app or browser version so support can reproduce the right procedure.

The Short Version

Select the row heading, cut the record, and insert it before the record that should follow it. Check the resulting order by names rather than old row numbers, then verify the values and formulas.