How to Uncover Hidden Rows on Google Sheets for Windows and Mac

Table of contents:

How to Uncover Hidden Rows on Google Sheets for Windows and Mac
How to Uncover Hidden Rows on Google Sheets for Windows and Mac
Anonim

This article will teach you how to uncover previously hidden lines on Google Sheets. Hiding rows and columns in Google Sheets is easy and so is discovering them, but the options for doing the latter are not that easy to find. Follow the steps below to learn how to uncover a hidden row on Google Sheets.

Steps

Unhide Rows on Google Sheets on PC or Mac Step 1
Unhide Rows on Google Sheets on PC or Mac Step 1

Step 1. Open Google Sheets

Go to the page https://sheets.google.com from your favorite browser. If you are logged in to Google, the page offers you a list of Google Sheets documents associated with your account.

If it hasn't already happened automatically, log in with your Google account

Unhide Rows on Google Sheets on PC or Mac Step 2
Unhide Rows on Google Sheets on PC or Mac Step 2

Step 2. Open the Google Sheet with the hidden row

If the row is missing you will see a small arrow above and below the hidden row, in the gray column on the left with the row number. You may also notice that the hidden line number is also missing.

If there are no hidden rows in your document, you can hide one to test by right-clicking on a row number in the far left column and selecting "Hide row"

Unhide Rows on Google Sheets on PC or Mac Step 3
Unhide Rows on Google Sheets on PC or Mac Step 3

Step 3. Click on the ▾ symbol above or below the missing line

Click on the triangle above or below the missing line and the hidden line will reappear.

Recommended: