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.
Step 3: Right-click on the selected row number, then choose the Hide row option.
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.
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.
Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.
His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop, and more.