How To Hide (and Unhide Rows) In Google Sheets - TechObservatory

Home » How To Unhide Rows In Google Sheets » How To Hide (and Unhide Rows) In Google Sheets - TechObservatory

Maybe your like

Skip to content TechObservatory Menu Menu Google SheetsGuides How to Hide (and Unhide) Rows in Google Sheets Phoebe Sanchez Avatar

Phoebe Sanchez

8 November 2023
How to Hide or Unhide Rows in Google Sheets
↳ In this article How to hide rows in Google Sheets How to 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.

Photo of author

Phoebe Sanchez

Phoebe works in HR Administration for IBM and other tech companies, and graduated with a BA in Communication and Media Studies from the University of Utah. She is a chief editor at TechObservatory.

Related Articles

Leave a Comment Cancel reply

Comment

Name Email

Notify me of follow-up comments by email.

Δ

Most Read

Latest Posts

  • Does GNC Take Apple Pay?
  • Does Cook Out Take Apple Pay?
  • How to Check if Your iPhone Is Locked or Unlocked
  • How to Change Your Name on iPhone
  • How to Get Water Out of AirPods

About

Legal

TechObservatory 3D Text Logo Close Search for:

Tag » How To Unhide Rows In Google Sheets