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

Google Sheets tutorials›Spreadsheet basics›Delete hidden rows

Google Sheets · Verified tutorial

Delete hidden rows in Google Sheets

Delete the hidden row between Anna and Ben.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

Delete the hidden row between Anna and Ben.

Step-by-step

1

Open the practice sheetUse the example data shown below so the result is easy to check.

2

Delete hidden rowsDelete the hidden row between Anna and Ben.

3

Check the resultCompare the finished sheet with the expected result and correct the target range if needed.

Shortcut or faster method

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

Expected result

The hidden row is removed and Ben becomes row 3.

Common mistake

Starting with the wrong cell or range selected.

Troubleshooting

Undo the last change, reselect the intended range, and try again. The hidden row is removed and Ben becomes row 3.

Example spreadsheet data

This is the clean fixture used for the verified run.

Name	Score
Anna	8
Delete me	0
Ben	6

Video transcript

Open the prepared Practice spreadsheet.
Open the practice sheet. Use the example data shown below so the result is easy to check.
Delete hidden rows. Delete the hidden row between Anna and Ben.
Check the result. Compare the finished sheet with the expected result and correct the target range if needed.
The hidden row is removed and Ben becomes row 3.