How to Move Rows Up and Down Microsoft Excel

March 28, 2026·2 min read

In this article

Interactive demo
Step-by-step guide
FAQ
Similar tutorials

Made with Saltfish·Create your own

Here's how to move rows up and down microsoft excel in MS Excel

Select the entire row by clicking on the row number located on the left side of the spreadsheet.
Position your mouse pointer over the edge of the highlighted row until the cursor transforms into a four-directional arrow.
Hold down the Shift key on your keyboard before beginning to drag the row.
While maintaining the Shift key, drag the selected row to your target location using the mouse.
Release the mouse button first, then let go of the Shift key to place the row in its new position.

Ready to get started with
interactive demos?

Try for free

Frequently Asked Questions

What happens if I don't hold Shift when moving rows in Excel?

Without holding Shift, Excel will replace the data in the destination row instead of inserting the moved row. This means you could accidentally overwrite existing information. Always use Shift to ensure rows are inserted rather than replaced.

Can I move multiple rows at once using this method?

Yes, you can select multiple consecutive rows by clicking and dragging across multiple row numbers, or hold Ctrl while clicking individual row numbers for non-consecutive selection. The same Shift+drag technique works for moving multiple rows simultaneously.

Will moving rows affect my formulas that reference those cells?

Excel automatically updates most cell references when you move rows using this method. However, it's always good practice to double-check any complex formulas after reorganizing your data to ensure they still reference the correct cells.

How to Move Rows Up and Down Microsoft Excel

Here's how to move rows up and down microsoft excel in MS Excel

Frequently Asked Questions

Similar tutorials

How to Create Marksheet in MS Excel

How to Clear MS Excel Cache

How to Count Cells with Text Values in Microsoft Excel