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.
If 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."
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
Insider Inc. receives a commission when you buy through our links.
