New: ready-to-use spreadsheet templatesExplore the collection →

Google Sheets tutorials›Spreadsheet basics›Move rows

Google Sheets · Verified tutorial

Move rows in Google Sheets

Move row 4 above row 2 using the row header.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

Move row 4 above row 2 using the row header.

Step-by-step

1

Select the targetMove row 4 above row 2.

2

Apply the changethe row header.

Shortcut or faster method

Select the full target range first. This avoids repeating the same change cell by cell.

Expected result

Research becomes the first data row.

Common mistake

Starting with the wrong cell or range selected.

Troubleshooting

Undo the last change, reselect the intended range, and try again. Research becomes the first data row.

Example spreadsheet data

This is the clean fixture used for the verified run.

Item	Owner	Status	Amount
Website	Anna	Open	1200
Campaign	Ben	Closed	850
Research	Cara	Open	640

Video transcript

Open the prepared Practice spreadsheet.
Select the target. Move row 4 above row 2.
Apply the change. the row header.
Research becomes the first data row.