Spreadsheets that you create in Google Sheets can serve a number of different purposes. Sometimes certain parts of a spreadsheet may not be relevant to a current task, and could serve to confuse someone that sees them. But you may need that data later, so it becomes necessary to hide the data from view without deleting it.
Tip: You can merge cells in Google Sheets if you need one cell to span across multiple columns.
Google Sheets provides you with the option to hide data in your file, including an entire row, if you so choose. Our tutorial below will show you how to select and hide a row in Google Sheets, then how to unhide that row later, if necessary.
Google Sheets – How to Hide a Row
The steps in this article were performed in Google Chrome, but will also work in other desktop Web browsers as well. Note that you can use a similar method as the one described below if you want to hide a column in Google Sheets.
Step 1: Go to your Google Drive at https://drive.google.com/drive/my-drive and open the Google Sheets file containing the row that you want to hide.
Step 2: Click the row number at the left of the spreadsheet to select the row that you want to hide.
Step 3: Right-click the selected row number, then click the Hide row option.
If you want to unhide a row, then you will need to click one of the black arrows that appears after you hid the row initially.
Hiding a row of data is helpful when you might need the data later, or if it’s referenced by formulas. But if you don’t need a row at all, then deleting it might be a better option. Learn how to delete multiple rows in Google Sheets if you have a lot of rows that are no longer necessary.
- How to merge cells in Google Sheets
- How to wrap text in Google Sheets
- How to alphabetize in Google Sheets
- How to subtract in Google Sheets
- How to change row height in Google Sheets
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.