How to Hide a Row in Google Sheets

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.