How to move lines in Excel
You can watch a video tutorial here.
When working in Excel, you may need to move lines 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 lines
Step 1 – Select the rows
- Select the lines
Step 2 – Drag and drop the rows
- Move the pointer over the selected rows 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 lines
- 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