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.
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.
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.
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.
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.
To hide a row or multiple rows follow these steps:
You might also like our articles on how to insert multiple rows in Google Sheets and how to hide columns in Google Sheets. Find out how to send an email from Google Sheets by clicking here.
