Recommended: Crashes or Glitches? A Free Driver Scan Usually Finds the Culprit →Recommended: Fix Windows Errors and Clear Junk Files in Minutes - Free Scan →
Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
iTechGuides is reader-supported. When you buy through links on our site, we may earn an affiliate commission. As an Amazon Associate I earn from qualifying purchases. Learn more
This guide demos how to hide rows in Google Sheets.
As at the time of writing this guide the option to hide rows is not supported in the iOS App.
Option 1: Hide Rows Using a PC
- Open Sheets.Google.com. Then click File and select Open.
- Navigate to where you saved the Google Sheets document in your Google Drive. Then select the document and click Open.
- When the document opens, right-click the row you want to hide. Then select Hide row. In this example, I want to hide row 3. I will right-click on row number 3.
It is important to click on the row number column. If you click on the row instead of the row number, the option to hide the row will NOT be displayed.
- The row will be hidden immediately. Once the row is hidden, two arrows will be displayed around the hidden row.
- To unhide the row, hover over the arrows – the background will change from black to white. Then click on any of the arrows.
Option 2: Hide Rows via the Android App
- Open the Google Sheets App on your Android phone.
- Then open the Google Sheets document you want to edit. If you opened the document recently, you will find it beneath Last opened by me.
- Alternatively, you could open the document from your Google Drive. To access Google Drive, click the folder icon on the top right of the Sheets App. Then select Google Drive.
- Once the Google Sheets document is opened, click and hold the row you want to hide until a list of options are displayed. In this example I want to hide row 3. From the displayed options, click the 3 dots on top. Then scroll down the second drop-down list and select Hide row.
- The row will be hidden immediately. On the hidden row tow arrows will be displayed.
- To unhide the hidden row, click on one of the arrows.
- To save your changes, click the blue tick on the top left of the document.
I hope you hope you found the guide helpful and easy to follow! If you did, click on “Yes” beside the “Was this page helpful” question below.
You may also express your thoughts and opinions by using the “Leave a Comment” form at the bottom of this page.
Quick wins for a faster PC:
Repair Windows errors before they cause bigger problemsFix Now →Scan for outdated or missing drivers - takes under a minuteDriver Scan →Clear out junk files and repair common Windows errorsFree Scan →Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
Want more Google guides? Visit our Google How To page.
Quick Recap
Bestseller No. 1
Bestseller No. 3
Bestseller No. 5
Also popular on Amazon
Also popular on Amazon
Also popular on Amazon
Google Sheets Reference and Cheat Sheet: The unofficial cheat sheet reference for Google's free online spreadsheet application
- hole punched
- high quality card stock
- 4 pages
- made in USA
- keyboard shortcuts
Also popular on Amazon
Popular on Amazon
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply. Prices as of November 5, 2026 9:02 am GMT.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone. 
