How to Hide Rows in Google Sheets

Hiding Rows is yet another great facet of Google Sheets that everyone would be better off knowing how to do. I will show you how to do so in just a few easy steps.

Step #1: Select the Row(s)

How to Hide Rows in Google Sheets Step 1

First, you will need to select the row that you wish to hide. That means clicking the actual number of that row.

 If you wish to select multiple rows, hold Shift+the Down Button until you have selected the rows that you want to hide.

Step #2: Hide the Row

How to Hide Rows in Google Sheets Step 2

Next, you will simply right-click your selected row and click "Hide Row" in the drop-down menu. That will do the trick and hide the desired row(s).

How to Hide Rows in Google Sheets

As you can see, row 4 is hidden from view. If you wish to reveal that row, click the arrow next to row 3 and 5.

That is how you hide rows in Google Sheets.

Leave a Reply

Your email address will not be published. Required fields are marked

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Google Sheets Magic Tricks!

Interactive, Easy and Free Way to Learn 5 Awesomely Cool Google Sheets Tricks!