This wikiHow teaches you how to restore hidden rows in a Google Sheets file when you're using an Android.
Steps
-
Open Google Sheets. It's the green icon with a white table inside. You'll usually find it in the app drawer.
-
Tap the file with the hidden row(s). This opens the spreadsheet.Advertisement
-
Tap the row number above the hidden row(s). Row numbers are along the left side of the spreadsheet. This selects the entire row and outlines it in blue.
-
Drag the blue handle down over the hidden row(s) to the next visible row. The handle is the blue dot at the bottom of the selected row. Now the entire range of rows, including those which are hidden, is selected.
-
Tap and hold the highlighted rows. A pop-up menu will appear.
-
Tap ⁝ . It's at the end of the menu.
-
Tap UNHIDE ROWS . The hidden row(s) now appear in their original location.Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
About this article
Article Summary
X
1. Open Sheets
.
2. Open the file.
3. Tap the row number above the hidden row(s).
4. Drag the handle down to the next visible row.
5. Tap and hold the highlighted rows.
6. Tap ⁝
.
7. Tap UNHIDE ROWS
.
Did this summary help you?
Thanks to all authors for creating a page that has been read 26,050 times.
Advertisement
