How to Hide a Row in Google Sheets

Is there a row of data in your spreadsheet that you don’t want people to look at, but you aren’t ready to delete it? Whether that information is irrelevant to the topic of the spreadsheet, or it contains information that is only meant to be used as part of a formula calculation, there are many reasons why you could want to hide data in Google Sheets.

Fortunately, you have the ability to hide a row from your spreadsheet. This will keep that data in the sheet, allowing it to be used in formulas, but the data won’t be visible to anyone that is viewing a printed copy of the spreadsheet, or looking at it on their computer.

How to Hide Google Sheets Rows

The steps in this article were performed in the desktop version of the Google Chrome Web browser, but will work in other desktop browsers as well.

Step 1: Sign into your Google Drive and open the Sheets file containing the row that you wish to hide.

Step 2: Select the row number to hide from the left side of the spreadsheet.

select the number of the row that you wish to hide

Step 3: Right-click on the selected row number, then choose the Hide row option.

how to hide a row in Google Sheets

Note that you can use this same method to hide multiple rows as well. Simply hold down the Ctrl key on your keyboard as you click each row number that you want to hide, then right-click one of the selected rows and choose the Hide rows option.

After you have hidden a row, small black arrows will appear above and below where that row was previously. Clicking one of those arrows will unhide the row.

how to unhide a row in google sheets

Now that you know how to hide a row in Google Sheets you can remove data from view that you don’t want anyone to see or edit in the spreadsheet.

Working on a file in Google Docs and the margins are too big or too small? Find out how to change margins in Google Docs and use whichever size margins your document requires.

Get Our Free Newsletter

How-to guides and tech deals

You may opt out at any time.
Read our Privacy Policy