To move cells in Google Sheets without overwriting data, make room first. Right-click the cell where the data should go, choose Insert cells > Insert cells and shift down (or shift right), then cut the original cells with Ctrl + X (Command + X on a Mac) and paste them into the new empty space with Ctrl + V. To move whole rows or columns, select them by their number or letter and drag them to a new position. Sheets shifts the others out of the way instead of replacing them.
Method 1: Insert space, then cut and paste
- Right-click the cell where you want the moved data to start.
- Choose Insert cells > Insert cells and shift down or Insert cells and shift right. To insert several at once, select that many cells first.
- Select the cells you want to move and press Ctrl + X.
- Click the first empty cell you created and press Ctrl + V.
- If the original spot is now empty, right-click it and choose Delete cells > Shift up (or Shift left) to close the gap.
Method 2: Drag whole rows or columns
- Click a row number (or column letter) to select it. Hold Shift and click another to select several.
- Point to the selected row numbers until the cursor becomes a hand.
- Drag the rows to the new position and let go.
Other rows move up or down to make room. Nothing is overwritten. You can also right-click a row number and choose Move row up or Move row down in some versions.
Method 3: Drag a block of cells (overwrites)
Selecting cells and dragging their border moves them, but it replaces whatever is in the destination. Sheets asks for confirmation before overwriting data. Use this only when the destination is empty.
Tips
- Formulas update automatically when you cut and paste or drag, so references keep pointing to the moved cells.
- Copying instead of moving? Use Ctrl + C instead of Ctrl + X.
- Paste only values with Ctrl + Shift + V to leave formatting behind.
- Undo mistakes with Ctrl + Z.
Related: How to Copy a Column in Google Sheets.
Frequently asked questions
Why does Google Sheets replace my data when I paste?
Pasting always writes over the destination cells. Insert empty cells first, as in Method 1.
Can I move cells in the Google Sheets app on a phone?
Yes. Tap and hold a row or column header and drag it, or select cells, tap Cut, then tap a destination and tap Paste. The Insert cells option may be in the cell menu.
How do I move a whole sheet?
Drag the sheet’s tab at the bottom left, or right-click the tab and choose Move right or Move left.
Kermit Matthews is a freelance writer based in Philadelphia, Pennsylvania with more than a decade of experience writing technology guides. He has a Bachelor’s and Master’s degree in Computer Science and has spent much of his professional career in IT management.
He specializes in writing content about iPhones, Android devices, Microsoft Office, and many other popular applications and devices.