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

Google Sheets tutorials›Spreadsheet basics›Delete rows

Google Sheets · Verified tutorial

Delete rows in Google Sheets

Delete rows 3 and 4 using their row headers.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

Delete rows 3 and 4 using their row headers.

Step-by-step

1

Select the targetDelete rows 3 and 4.

2

Apply the changetheir row headers.

Shortcut or faster method

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

Expected result

Only the header and Website row remain at the top.

Common mistake

Starting with the wrong cell or range selected.

Troubleshooting

Undo the last change, reselect the intended range, and try again. Only the header and Website row remain at the top.

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. Delete rows 3 and 4.
Apply the change. their row headers.
Only the header and Website row remain at the top.