1
Click the first row number
Click the number of the first row you want to hide - here, row 3.
How to hide rows in Google Sheets
Hide rows you do not need to see right now without deleting them, and bring them back with one click.
Operations
2
Shift-click the last row number
Hold Shift and click the last row number to select every row in between.
3
Right-click the selected rows
Right-click one of the selected row numbers to open the row menu.
4
Click Hide rows
Choose Hide rows 3 - 4. The rows disappear and small arrows mark where they were.
5
Click the arrows to show them again
The rows are hidden, not deleted. Click the arrows between the row numbers whenever you want to show them again.
Make this walkthrough your own
Duplicate this template, swap in your own screens, and share it with your team. Free to start — no credit card.