How to move an entire row in Excel

You can watch a video tutorial here.

When working in Excel, you may need to move an entire row to change the order of the data or to make the sheet easier for the readers to understand. Here we describe 2 ways of doing this.

Option 1 – Drag and drop the row

Step 1 – Select the  row

  • Select the row

Step 2 – Drag and drop the row

  • Move the pointer over the selected row number till it changes to a move pointer
  • Left-click and press the Shift key
  • Drag the row to the new position
  • The new position of the row will be indicated by a green line
  • Release the mouse button and the Shift key

Note: If you do not hold the Shift key while moving the row, it will overwrite the destination row instead of moving it 

Option 2 – Use Cut and Insert

Step 1 – Cut the  row

  • Select the row
  • Right-click and select Cut from the context menu or press Ctrl+X

Step 2 – Insert the cut cells

  • Select the row at the new location
  • Right-click and select Insert cut cells from the context menu

Step 3 – Check the result

  • The row is moved to the new location