How to unhide Google Sheets
Select the rows above and below the hidden block, right-click, and choose Unhide rows. Tiny arrows between row numbers also reveal hidden rows. Hidden rows are not deleted; formulas still see them unless filtered out.
Steps
-
1
Select neighboring rows around the gap.
-
2
Right-click → Unhide rows.
-
3
Or click the arrows between row numbers.
Related tutorials
These videos might help you go deeper on this topic.
Google Sheets Easter Eggs Beyond PRIDE
Password Protecting Data In a Google Sheet Part 2 The Basics
Make a Tour of Your Sheet
MAKE Your Google Sheets Add-on DISCOVERABLE
Show Sheet Tabs Based on Edit
Create a Public Sheet and Private Sheet: Using ImportRange()
Related blog posts
Written guides that go deeper on this question.
How To Hide Data with Checkboxes in Google Sheets
Checkboxes in Google Sheets are a game-changer. They add interactivity, flexibility, and functionality to your spreadsheets, making data management easier and more enjoyable.
Read post →Quick Google Sheets Tips
Boost productivity and streamline your workflow in Google Sheets with our quick tips and free tools. Breathe new life into your spreadsheets today.
Read post →Hide Gridlines
Boost your sheet readability. Hide gridlines for clearer views and discover more tips in our free blog post. Learn and enhance your spreadsheet skills.
Read post →Better Sheets on YouTube
Watch matching videos from youtube.com/bettersheets.
No exact channel match cached for “How to unhide Google Sheets” yet. Search Better Sheets on YouTube.
Terms and formulas behind this
Want the full definition or how a formula works? Start here.
cell formatting
Cell formatting controls how values display without necessarily changing the stored value underneath. Currency, perce...
Open →filters in Google Sheets
Filtering hides rows that do not match criteria without deleting data. The filter toolbar on a header row is the fast...
Open →FILTER
FILTER returns only the rows from a range that meet one or more conditions. Conditions are boolean arrays the same he...
Open →Google Sheets formulas
A formula is an instruction in a cell that calculates a result from other cells, ranges, or built-in functions. Every...
Open →Google Sheets formula syntax
Every formula starts with = followed by a function name and arguments in parentheses. Ranges use A1 notation, text si...
Open →ROWS()
Google Sheets ROWS() function guide
Open →Related questions
How to unhide rows in google sheet
Select the rows above and below the hidden block, right-click, and choose Unhide rows. Tiny arrows between row numbers also reveal hidden rows. Hidden rows are not deleted; formulas still see them unless filtered out.
Get the answer →How do i unhide rows in Google Sheets
Select the rows above and below the hidden block, right-click, and choose Unhide rows. Tiny arrows between row numbers also reveal hidden rows. Hidden rows are not deleted; formulas still see them unless filtered out.
Get the answer →How to unhide rows on Google Sheets
Select the rows above and below the hidden block, right-click, and choose Unhide rows. Tiny arrows between row numbers also reveal hidden rows. Hidden rows are not deleted; formulas still see them unless filtered out.
Get the answer →How do you unhide rows in Google Sheets
Select the rows above and below the hidden block, right-click, and choose Unhide rows. Tiny arrows between row numbers also reveal hidden rows. Hidden rows are not deleted; formulas still see them unless filtered out.
Get the answer →How to unhide rows Google Sheets
Select the rows above and below the hidden block, right-click, and choose Unhide rows. Tiny arrows between row numbers also reveal hidden rows. Hidden rows are not deleted; formulas still see them unless filtered out.
Get the answer →Need more than a quick answer?
636+ walkthrough videos, unlimited generators, and every template. From $9/month. Practical lessons. Zero fluff.
Need one fix
Watch a free tutorial for the step-by-step version of any answer.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.