New: ready-to-use spreadsheet templatesExplore the collection  →
Google Sheets · Verified tutorial

Hide a row in Google Sheets

Hide row 4 using its row header. Do not delete the row or change any values.

Verified by JosephineAbout 60 seconds
Quick answer

Hide row 4 using its row header. Do not delete the row or change any values.

Step-by-step

1

Select the targetHide row 4.

2

Apply the changeits row header.

Shortcut or faster method

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

Expected result

Row 4 is hidden.

Common mistake

Starting with the wrong cell or range selected.

Troubleshooting

Undo the last change, reselect the intended range, and try again. Row 4 is hidden.

Example spreadsheet data

This is the clean fixture used for the verified run.

EmployeeDepartmentWeekHours
AnnaDesignWeek 132
BenSalesWeek 138
CaraFinanceWeek 235
DevOperationsWeek 240
EvaSupportWeek 336

Video transcript

  1. Open the prepared Team schedule spreadsheet.
  2. Select the target. Hide row 4.
  3. Apply the change. its row header.
  4. Row 4 is hidden.