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

Google Sheets tutorials›Spreadsheet basics›Unhide rows

Google Sheets · Verified tutorial

Unhide rows in Google Sheets

Ensure every row is visible. If any rows are hidden, unhide them. Do not change any values.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

Ensure every row is visible. If any rows are hidden, unhide them. Do not change any values.

Step-by-step

1

Select the targetEnsure every row is visible.

2

Apply the changeIf any rows are hidden, unhide them.

Shortcut or faster method

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

Expected result

No rows are hidden.

Common mistake

Changing the source values while applying the formatting or structure change.

Troubleshooting

Undo the last change, reselect the intended range, and try again. No rows are hidden.

Example spreadsheet data

This is the clean fixture used for the verified run.

Employee	Department	Week	Hours
Anna	Design	Week 1	32
Ben	Sales	Week 1	38
Cara	Finance	Week 2	35
Dev	Operations	Week 2	40
Eva	Support	Week 3	36

Video transcript

Open the prepared Team schedule spreadsheet.
Select the target. Ensure every row is visible.
Apply the change. If any rows are hidden, unhide them.
No rows are hidden.