Last Updated on October 31, 2023 by Jake Sheridan
How To Unhide Rows in Google Sheets
Sometimes you may not want to see some of your data in your spreadsheet.
If you are using Google Sheets and need to temporarily hide some of your data there is a nifty trick you can use: you can hide rows in Google Sheets.
Wait a minute! *cue dramatic music*
If you hide your rows will you be able to get them back?
Yes you will.
When you hide rows you never do it permanently. You will always be able to get your rows and the data within back unless you delete the rows instead of hiding them.
How to Unhide All Rows in Google Sheets
When you are ready to unhide rows it is easy to make them visible again by clicking on this weird little arrow thingy:
If you need some instructions that are clearer than ‘weird little arrow thingy‘, here ya go:
- When you hide rows arrows will appear in the grey number column, which is to the very far left of the sheet.
- Find the arrows in the numbered column above and below the hidden rows.
- Hover your cursor over one of the arrows.
- Your cursor will change to an arrow bar.
- Click one of the arrows. The hidden rows will immediately appear right where they were before. None of your information will be missing.
You can also right click and select Unhide rows:
If someone else sent you the Google Sheet and you still find information is missing you can see if there is a filter on the sheet…
Removing a Filter in Google Sheets
Sometimes, even though you have unhidden all of the rows you may still find information missing. Sometimes the missing information can be due to a filter placed on the sheet.
If there is a filter in place, column headings will be shaded green:
Click the filter button in the top bar to remove it:
This will remove the filter and should make all the data appear in the sheet.
Why Would I need to Hide Rows?
I know what you are thinking: why do I need to hide rows in my spreadsheets?
(And no, it’s not because you are a secret agent with secret spy stuff to hide in Google Sheets, although you might be so apologies for doubting you if you are actually a spreadsheet using super spy.)
A more practical answer is sometimes your sheet is so large that to view your data you need to scroll up and down over and over.
It can be hard to view your data like this. You can forget what you are looking at or have a hard time making a proper analysis of the data.
This is where hiding rows may come in handy. You can hide the rows you do not need and reduce the amount of scrolling you need to do.
Other times you may want to make an analysis of data but remove some of the data you already have on your sheet.
In this tutorial, I covered how to unhide rows in Google Sheets. Want more? Check out all the Google Sheets Tutorials.