How to move or swap rows in Google Sheets
Learn to move, reorder, or swap rows in Google Sheets using drag-and-drop, cut-and-insert, and keyboard shortcuts without losing data.
Quick answer
Select a row by clicking its row number, then drag it up or down to move it. To swap two rows, cut one row using Ctrl+X, insert a blank row where you want it, right-click and choose 'Cut cells' then 'Insert cut cells' to swap positions without overwriting data.
Steps at a glance
- Click the row number to select the entire row.
- Hover over the row number until the hand icon appears.
- Drag the row to its new position and release.
- To swap rows, cut one row with Ctrl+X.
- Right-click the destination row and select "Insert cut cells".
- Repeat for the second row if swapping two rows.
- Check formulas and formatting after moving rows.
Summary
Google Sheets lets you reorder rows using simple drag-and-drop or a more precise cut-and-insert method that swaps two rows without overwriting either one's data. Knowing both approaches helps you reorganize datasets quickly while keeping formulas and formatting intact.
Step-by-step guide
Step 1
Select the Row You Want to Move
Click the row number on the left side of the sheet to highlight the entire row. You can select multiple adjacent rows by clicking and dragging across their row numbers.
Step 2
Drag and Drop to Reorder
Hover your cursor over the selected row number until a hand icon appears, then click and drag the row up or down to its new location. Release the mouse button when you see the blue insertion line marking where the row will land. This method works well for moving one row a short distance in a small dataset, such as adjusting entries alongside a /guides/google-sheets/sort-a-table setup.
Step 3
Cut and Insert to Swap Two Rows
To swap two rows without dragging, right-click the row number of the first row and choose "Cut". Then right-click the row number where you want it to go and select "Insert cut cells" — Sheets shifts the existing row down instead of overwriting it. Repeat the process for the second row to complete the swap.
Step 4
Use Keyboard Shortcuts for Faster Moves
Select the row, press Ctrl+X (Cmd+X on Mac) to cut it, then right-click the destination row and choose "Insert cut cells" from the menu. This keeps formatting intact and is faster than dragging when working across long spreadsheets.
Step 5
Verify Formulas and Data After Moving
After moving or swapping rows, scroll through the affected area to confirm that formulas referencing those rows updated correctly and that formatting like /guides/google-sheets/format-as-currency or conditional rules didn't shift out of place. Google Sheets automatically adjusts relative references, but absolute references may need a manual check.
Step 6
Freeze Header Rows to Avoid Confusion
If you're reordering many rows, use /guides/google-sheets/freeze-rows to lock your header row in place so it stays visible and doesn't get accidentally moved during drag operations.
Why this matters
You're reordering a task list, attendance sheet, or sales ranking and need row three to sit above row one without deleting either. Learning the right technique saves you from accidentally overwriting data and lets you reorganize large datasets confidently and quickly.
Frequently asked questions
What's the difference between moving and swapping rows?
Moving a row simply changes its position, shifting other rows to make space. Swapping exchanges the positions of two specific rows, which requires cutting and inserting rather than a simple drag.
Can I move rows without affecting formulas?
Yes. Google Sheets automatically updates relative cell references when you move or swap rows. Only absolute references (marked with $) require manual adjustment afterward.
Is there a keyboard shortcut for moving rows?
There's no single shortcut for dragging, but you can cut a row with Ctrl+X and insert it elsewhere by right-clicking and choosing "Insert cut cells," which is faster than manual dragging for larger sheets.
Can I swap rows that aren't next to each other?
Yes. Cut the first row, insert it above or below the second row's new position, then repeat the cut-and-insert process for the second row to complete the swap.
Create interactive demos like this one — free, no coding required.
Start for free →