• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Support Your Tech

Instructions and tutorials to help you get the most from your applications and devices

  • Android
  • Excel
  • Word
  • iPhone
  • Mac
  • Docs
  • Slides
  • Sheets
  • Streaming
You are here: Home / Google / Sheets / How to Hide a Row in Google Sheets

How to Hide a Row in Google Sheets

July 19, 2019 By Matt Jacobs

Is there a row of data in your spreadsheet that you don’t want people to look at, but you aren’t ready to delete it? Whether that information is irrelevant to the topic of the spreadsheet, or it contains information that is only meant to be used as part of a formula calculation, there are many reasons why you could want to hide data in Google Sheets.

Fortunately you have the ability to hide a row from your spreadsheet. This will keep that data in the sheet, allowing it to be used in formulas, but the data won’t be visible to anyone that is viewing a printed copy of the spreadsheet, or looking at it on their computer.

How to Hide Google Sheets Rows

The steps in this article were performed in the desktop version of the Google Chrome Web browser, but will work in other desktop browsers as well.

Step 1: Sign into your Google Drive and open the Sheets file containing the row that you wish to hide.

Step 2: Select the row number to hide from the left side of the spreadsheet.

select the number of the row that you wish to hide

Step 3: Right-click on the selected row number, then choose the Hide row option.

how to hide a row in Google Sheets

Note that you can use this same method to hide multiple rows as well. Simply hold down the Ctrl key on your keyboard as you click each row number that you want to hide, then right-click one of the selected rows and choose the Hide rows option.

After you have hidden a row, small black arrows will appear above and below where that row was previously. Clicking one of those arrows will unhide the row.

how to unhide a row in google sheets

Working on a file in Google Docs and the margins are too big or too small? Find out how to change margins in Google Docs and use whichever size margins your document requires.

Matt Jacobs

Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.

His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop and more.

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Related

Primary Sidebar

Recent Posts

  • How to Delete a Text Box in Microsoft Excel for Office 365
  • How to Add Line Numbers in Word for Office 365
  • How to Save a Picture to Your Computer from Powerpoint for Office 365
  • How to Enable Data Saver in Spotify on an iPhone
  • How to Change the Font for a Selection in Microsoft Word for Office 365

Featured Posts

how to view remaining iPhone 11 storage space

How Much iPhone Storage Do I Have Left on My iPhone 11?

How to Make a Desktop Shortcut for a Google Docs File

how to delete Spotify podcast download on iPhone

How to Delete Downloaded Podcasts in the Spotify iPhone App

how to download Google Docs as a Word file

How to Download Google Docs as Word

how to add page numbers in Google Sheets

How to Add Page Numbers in Google Sheets

how to hide the Meet section in Gmail

How to Remove the Meet Section from Your Gmail Inbox

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Privacy Policy
  • Affiliate Disclaimer
  • Contact Us
  • About Us

SupportYourTech.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com.

Copyright © 2021 SupportYourTech.com