How to Hide Rows on Google Sheets on PC or Mac
This wikiHow 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. Open [https://sheets.google.com Google Sheets] in your internet...
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.
4 ★ | 13 Vote
You should read it
- Hide the Windows folder in a professional way
- Instructions for using Hide My Ass to hide IP
- How to Hide the Menu Bar on a Mac
- Tip Hide professional Excel spreadsheets
- Hide and show slides in PowerPoint
- Download Free Hide IP 4.2.0.6: Simple tool to increase security
- How to Hide the Windows Taskbar
- How to Hide a File in an Image File
- How to completely hide a folder with a single command on Windows
- Types of data hiding in Excel - Hide pictures, graphs, rows, columns
- How to use Media Lock to hide files on Windows 10
- 4 free software to hide photos and videos on Android
Maybe you are interested
Try the built-in VPN on Microsoft Edge browser
Are lesser known browsers more secure?
6 Safari Settings to Change to Improve Your Mac Browsing Experience
10 Microsoft Edge Settings You Need to Change to Improve Your Browsing Experience
More than 100 species of bacteria found to survive in microwaves
'Vampire' sparrow: Strange bird that drinks blood to survive