How to Hide (and Unhide) Rows in Google Sheets

How to Hide or Unhide Rows in Google Sheets

You might want to hide or unhide specific rows when working with large volumes of data in a spreadsheet. For example, for privacy reasons or to make the sheet easier to read. This guide shows you how to hide or unhide rows in Google Sheets.

How to hide rows in Google Sheets

  1. Select the rows you want to hide. For example, we selected rows 4 and 5.

    Select rows to hide
    Select the rows you want to hide.

  2. Right-click and select Hide rows 4 – 5.

    Hide Rows
    Select the Hide Rows option.

  3. You’ll notice the double-sided arrows on the consecutive rows indicating the hidden rows between them.

    Hidden Rows
    Selected rows are hidden.

How to unhide rows in Google Sheets

  1. Select the rows adjacent to the hidden rows with the double-sided arrows. For example, hidden rows 4 and 5 are adjacent to rows 3 and 6.

    Select rows to unhide
    Select the rows that you want to unhide.

  2. Right-click and select Unhide rows.
    Unhide Rows
    Select Unhide Rows.

    The hidden rows will now appear.

    Unhidden Rows
    Hidden rows now show.

Phoebe is an HR assistant in her day job, but is also a web blogger that loves writing guides and sharing her experiences. When she is not out with her friends, she enjoys traveling or binge-watching Netflix. She graduated with a BA in Communication and Media Studies from the University of Utah, and is a chief editor at TechObservatory.

Leave a Comment