This article was co-authored by How.com.vn Staff. Our trained team of editors and researchers validate articles for accuracy and comprehensiveness. How.com.vn's Content Management Team carefully monitors the work from our editorial staff to ensure that each article is backed by trusted research and meets our high quality standards.
This article has been viewed 24,982 times.
This How.com.vn teaches you how to collapse and hide an entire row, or multiple rows, from a Google Sheets spreadsheet without removing any data, using an internet browser.
Steps
Open Google Sheets in your internet browser. Type sheets.google.com in your browser's address bar, and hit ↵ Enter or ⏎ Return on your keyboard.- If you're not automatically signed in to Google, enter your email and password to log in.
Click a spreadsheet. Find the spreadsheet you want to edit in the list of all your saved sheets, and open it.
Click the number label next to the row you want to hide. Find the number label on the left-hand side of the row you want to hide, and click it. This will select and highlight the entire row.- If you want to hide multiple rows at once, hold down the ⇧ Shift key on your keyboard, and then click another row. This will select and highlight all the rows in the selected range.
Right-click the highlighted row. This will open your right-click menu in a drop-down box.
Select Hide row on the menu. This will collapse and hide the selected row from your spreadsheet. The data in it will not be deleted, but it won't show up on the sheet unless you unhide it.- If you've selected multiple rows, this option will read as Hide rows and indicate the range of selected cells.
Advertisement
Expert Q&A
About this article
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.
