Enter Your Email Below to Try Lido for FREE!
Thanks for Signing Up - Please Check your Email to Verify your Account
Oops! Something went wrong while submitting the form.
100% FREE - No Credit Card Required
Enter Your Email Below to Try Lido for FREE!
Experience all of the benefits of the classic spreadsheet with much more powerful features that save users time!
- One Click Data Imports From Anywhere
- Transform Spreadsheets into Software in Seconds
- Pre-built & Custom Templates
- Visualize Real-Time Data in Centralized Dashboards
Thanks for Signing Up - Please Check your Email to Verify your Account
Oops! Something went wrong while submitting the form.
100% FREE - No Credit Card Required
Recommended articles
- You can easily unhide columns in Google Sheets on your computer or mobile device.
- You can unhide columns or rows either by clicking or tapping on an arrow, or by right-clicking on a computer to bring up another option for unhiding.
- Visit Business Insider's homepage for more stories.
As in any spreadsheet program, you can hide rows and columns on Google Sheets to better organize your document. But once hidden, how do you unhide them?
It's surprisingly simple, and works the same way whether you're in a browser on a Mac or PC or using the Google Sheets app on your mobile device, though you can also right-click on a computer to bring up another option for unhiding.
Check out the products mentioned in this article:
MacBook Pro [From $1,299.99 at Best Buy]
Lenovo IdeaPad 130 [From $299.99 at Best Buy]
How to unhide columns in Google Sheets
You can see that a column [or row, for that matter] is hidden in Google Sheets because the labeled column will be missing – it will skip from B to E, for example, or in the case of rows, 12 to 20. The missing entries are hidden. More importantly, you should see small arrows on either side of the hidden labels.
To unhide it on desktop or mobile, just click or tap the small arrow on either side of the hidden column or row.
Unhide a column by clicking the small arrows in the column labels. Dave Johnson/Business InsiderIf you're on a desktop, another way to unhide is to select a range of column on either side of the hidden column, right-click, and choose "Unhide Columns."
You can also unhide columns by right-clicking on a computer. Dave Johnson/Business Insider
Related coverage from How To Do Everything: Tech:
How to create a graph in Google Sheets to get a visual display of your data
How to add a drop-down list in Google Sheets to group and organize data in your spreadsheet
How to set a print area in Google Sheets, so you can print selected cells or sheets
How to find and track flights using Google Flights to get the best deal on your next flight
How to send a Google Calendar invite to anyone using the desktop site or a mobile device
Dave Johnson
Freelance Writer
Dave Johnson is a technology journalist who writes about consumer tech and how the industry is transforming the speculative world of science fiction into modern-day real life. Dave grew up in New Jersey before entering the Air Force to operate satellites, teach space operations, and do space launch planning. He then spent eight years as a content lead on the Windows team at Microsoft. As a photographer, Dave has photographed wolves in their natural environment; he's also a scuba instructor and co-host of several podcasts. Dave is the author of more than two dozen books and has contributed to many sites and publications including CNET, Forbes, PC World, How To Geek, and Insider.
Read more Read less
Insider Inc. receives a commission when you buy through our links.
Google Docs Editors Help
Sign in
Google Help
- Help Center
- Community
- Google Docs Editors
- Privacy Policy
- Terms of Service
- Submit feedback
Send feedback on...
This help content & information
General Help Center experience
- Help Center
- Community
Google Docs Editors