How To Hide Rows In Google Sheets?

Select the row or rows you want to hide

Right-click the selected row number

Click Hide row

To hide multiple rows, select the row numbers first, then right-click and choose Hide rows

To hide non-adjacent rows, hide each row separately

To unhide rows, click the small arrows that appear between the surrounding row numbers

You can also use the Format or Data menu only if available in your version, but right-click is the quickest method

Suggested for You

Trending Today