How to show hidden rows in Google Sheets on computer

Table of contents:

How to show hidden rows in Google Sheets on computer
How to show hidden rows in Google Sheets on computer
Anonim

In this article, we'll show you how to show hidden rows in Google Sheets. Hiding rows and columns is as easy as showing them, but you need to know where the corresponding option / icon is.

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 the Google Sheets site

Go to https://sheets.google.com in a web browser. If you are already signed in to your Google account, a list of your spreadsheets will be displayed.

If you haven't logged in to Google yet, do so now

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 table with hidden rows

If the row is hidden, you will see icons in the form of small triangles (above and below the hidden row) on the left gray panel with row numbers; also you will notice that the hidden line number is missing in the line number panel.

To hide a row, right-click on its number in the left panel of numbers and select "Hide row" from the menu

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 the small triangle icon (▾) above or below the hidden row

This will show the hidden row again.

Popular by topic