Shifting cells in Google Sheets without losing anything starts with inserting empty cells where the data should land, then cutting and pasting into that space. Whole rows and columns are easier: drag them by their number or letter, or use the Edit menu, and the other rows or columns make room. The one move to treat with care is dragging a block of cells onto a spot that already holds data.
What are you moving?
| You want to move | Best route | Risk to existing data |
|---|---|---|
| A block of cells into a filled area | Insert empty cells, rows or columns at the destination, then cut and paste | None, as long as the empty space is big enough |
| Whole rows or columns | Drag the row numbers or column letters, or Edit > Move | None: the rest shift to make room |
| A block of cells into an empty area | Drag the selection by its top edge, or cut and paste | None if the destination is really empty; check it before you drop the cells |
| A copy, leaving the original in place | Copy and paste instead of cut | Same as above at the destination |
| Rows into a new order by value | Sort the range instead of moving rows by hand | None, if the whole range is selected |
These steps are for Google Sheets in a web browser on a computer. The Sheets app on Android, iPhone and iPad is covered in its own section, because Google documents fewer moves there.
Make room first, then cut and paste
The safe way to move a block of cells is to create the empty space before you paste, so nothing at the destination gets replaced. Google’s add or move columns and cells help page describes the insert options this relies on.
- Select as many cells, rows or columns at the destination as you are going to move in. If you are moving a block three rows tall, select three rows or three cells.
- Right-click the selection. From the menu, choose Insert cells, or an option such as Insert 3 rows above to add whole rows. For one row or column, the menu offers Insert 1 left, right, above or below.
- Check that the empty space appeared where you expected and that the cells you are about to move have not shifted. If they did shift, note their new position.
- Select the cells you want to move and press Ctrl + X (⌘ + X on a Mac) to cut them.
- Click the top-left cell of the empty space and press Ctrl + V (⌘ + V on a Mac) to paste.

The illustration shows the idea of inserting cells before you paste. Google’s help page names the Insert cells item but does not list the choices under it, so the wording in your menu may differ. Pick the choice that pushes the existing cells out of the way in the direction you want.
Inserting whole rows or columns is the most predictable option because it never splits a row of data. For more on that step, see inserting a column in Google Sheets.
Close the gap you left behind
Cutting leaves the original cells empty. If you do not want that gap, remove it after the paste.
- Right-click the empty row, column or cell.
- Choose Delete row, Delete column or Delete cell, as Google lists them.
- Look at the result before moving on. Google’s help does not describe how the remaining cells shift after Delete cell, so confirm the data lines up the way you intended.
Deleting a whole row or column is the cleanest way to close a gap that runs across the sheet. Deleting a column in Google Sheets covers that on a computer and in the app.
Move whole rows or columns
When the thing you are moving is a full row or column, Sheets handles the shifting for you, and nothing is replaced.
- Click a row number or column letter to select it. To select several next to each other, click the first, hold Shift and click the last.
- Either drag the selection to its new place, or click Edit at the top and choose a direction, such as Move row up.
- Release the mouse. The other rows or columns move aside.
Edit > Move moves the selection one step at a time, which suits small adjustments. Dragging is faster for long distances.
Drag a block of cells by its edge
Google documents dragging part of a sheet, not just whole rows: select the cells, point to the top of the selection until a hand appears, and drag the cells to their new location. This is quick, but anything in the cells you drop them on is affected.
- Use it when the destination is empty, or after you have inserted empty space as described above.
- Google’s help does not say whether Sheets warns you before replacing filled cells, so do not count on a warning.
- If something disappears, press Ctrl + Z (⌘ + Z) right away to undo the drag.
Formulas, formatting and paste options
Google’s help pages do not explain what happens to formulas that point at cells you move, so after any move, click a few formulas that use the moved range and check their references before you rely on the totals.
When you want the contents without the source formatting, Google’s keyboard shortcuts for Google Sheets list Ctrl + Shift + V (⌘ + Shift + V) as Paste values only. Google’s copy and paste help page lists more choices under Edit > Paste special, such as Paste format only, Paste formula only, Paste column widths only and Paste transposed, and notes that Paste special works within one spreadsheet.
If you need the data in both places, copy instead of cutting; copying multiple rows in Google Sheets covers that. Merged cells can make a selection larger than it looks, so if a move behaves oddly, check for them; merging cells in Google Sheets explains how to unmerge.
Move rows and columns in the Sheets app
Google’s Android, iPhone and iPad steps cover rows and columns only. They do not describe moving a block of cells in the app.
- On Android, select the row number or column letter to move. On an iPhone or iPad, touch and hold the row number or column letter.
- Drag the row or column to a new place.
- To add room first, use the Insert button and choose an option; to remove a row or column, use Delete.
For moving a block of cells without disturbing the rows around it, the computer version is the documented route.
Undo a move that went wrong
Press Ctrl + Z (⌘ + Z on a Mac) as many times as needed to step back through the last changes. If you notice the problem later, viewing cell history in Google Sheets shows what a cell held before and who changed it.
Moving cells in Sheets answers
Why did my data disappear when I dragged cells?
The cells were dropped onto cells that already held data. Undo the drag, insert empty space at the destination, and move the cells into that space.
Can I move a few cells without moving the whole row?
Yes. Insert empty cells at the destination with Insert cells, then cut and paste just that block. The rest of the row stays where it is, apart from whatever the insert shifted.
What is the difference between Ctrl + V and Ctrl + Shift + V?
Ctrl + V pastes everything you cut or copied. Ctrl + Shift + V is Paste values only, for when you want the values without the source formatting.
Is there a faster way to reorder many rows?
If the new order follows a column’s values, sort the range instead of moving rows by hand. Sorting a column from highest to lowest shows how.
Before a big rearrangement, make a copy of the sheet tab so you can compare the result with the original.

Kermit Matthews runs Live2Tech from just outside Philadelphia. He is an IT specialist with over 20 years of experience, from a university help desk to small-business IT, IT management and his own consulting practice, and has written tech guides full time since 2020. Steps are checked against the current software on a real device or the maker’s official documentation. More about Kermit.