How to Hide and Unhide Rows in Google Sheets
In this article we cover 3 simple step-by-step methods for hiding and unhiding rows in Google Sheets.
If you read this tutorial on unhiding columns in Google Sheets, you might think the same can be applied for rows. The answer is yes! Hiding rows can come in handy if you end up with long spreadsheets where you still have to read the rows one-by-one. We'll take you through the steps to hide and unhide rows.
How to Hide Rows
Step 1: Select the row number you are hiding. If you want to select several rows then do either of the two:
If you are selecting a continuous number of rows, first hold down the SHIFT key in your keyboard and select the first and last row in the series. You could get something similar to this:
If you are selecting a number of rows that are not adjacent to each other, first hold down the CTRL key in your keyboard and select all the rows to be hidden. You could get something similar to this:
Step 2: Once the row is selected, right click on its row number. A drop-down box will appear. Click on the Hide row.
The row is now hidden.
If the rows form a continuous series, then the text Hide rows would be followed by the numbers of the rows to be hidden.
If the rows do not form a continuous series, then click the command Hide rows.
How to Unhide Rows
It is easy to spot if there are hidden rows, as there will be interruptions in the number of rows on the left side of the spreadsheet. To unhide hidden rows, the steps are likewise simple and quick.
Method 1: One-click method
When you hover the cursor to the pair of arrows that mark where the hidden rows are located, a box containing two arrows will appear. Click on it.
Method 2: Right-click method
Sometimes you may not be able to do Method 1. Here is another way of unhiding the rows.
Step 1: Press SHIFT or CTRL on the keyboard to select the two rows bordering the hidden rows. In the example here, rows 8 and 12 sandwich the hidden rows 9 to 11. Select rows 8 and 12.
Step 2: Right click on the selected row numbers. A drop-down box will appear. Click Unhide rows.
How to Hide Rows in Google Sheets
To hide a row or multiple rows follow these steps:
- Click on the row you want to hide or drag your mouse along the row numbers to highlight multiple.
- Right click on the highlighted row(s)
- Choose 'Hide Row'
- The row(s) will automatically be hidden