Google Sheets is a powerful tool for organizing and analyzing data.
Sometimes, you might want to focus on specific parts of your data without the distraction of other rows. Hiding and unhiding rows in Google Sheets is an effective way to manage your view without altering or deleting any data.
This tutorial will guide you through the simple steps to hide and unhide rows in Google Sheets, both on desktop and mobile devices.
How to Hide Rows in Google Sheets
Hiding rows in Google Sheets can be done in a few clicks. Here’s how:
1. Selecting Rows in Google Sheets
Whether you are dealing with consecutive or non-consecutive rows, the first step is always to select the rows you want to hide:
For Consecutive Rows:
To hide a series of consecutive rows, first click on the row number of the first row in the series you want to hide.
Hold down the Shift key on Mac. This step is the same for both PC and Mac users.
While holding Shift, click on the row number of the last row in your series. This action highlights all the rows in between.
For Non-Consecutive Rows:
For hiding rows that are not next to each other, click on the row number of the first row you wish to hide.
Then, hold down the Ctrl key (or Command on a Mac).
While holding Ctrl (for PC) or Command (for Mac), click on the row numbers of any other rows you want to hide.
2. Hiding the Selected Rows:
After selecting the rows, right-click on one of the highlighted row headers.
From the context menu that appears, select “Hide row(s).”
How to Hide Rows in Google Sheets Shortcut
For a quicker method on desktop, use this shortcut:
Select the Row(s): Click or Shift-click the row numbers you want to hide.
Use the Shortcut: Press Ctrl + Alt + 9 on PC or Command + Option+ 9 on Mac to hide the selected rows.
How to Hide Rows in Google Sheets on Mobile
Hiding rows in the mobile app is just as easy:
Select the Row: Tap on the row number to select it. For multiple rows, tap the first row, then drag the blue handle to include additional rows.
Hide the Row: Once selected, tap the row and in the menu that appears, tap Hide Row.
How to Unhide Rows in Google Sheets
To make hidden rows visible again:
Find the Indicators: Look for the arrows or highlighted lines indicating hidden rows.
Unhide Rows: Click on these indicators to unhide the rows.
How to Unhide Rows in Google Sheets Shortcut
For a faster approach on desktop:
Select Adjacent Rows: Click the row numbers above and below the hidden section.
Shortcut: Press Ctrl + Shift + 9 on PCor Command + Shift + 9 on Mac.
How to Unhide Rows in Google Sheets on Mobile
On a mobile device:
Identify Hidden Rows: Look for arrows indicating hidden rows.
Unhide Rows: Tap on these indicators to unhide the rows.
Mastering the skill of hiding and unhiding rows in Google Sheets can greatly enhance your data management capabilities. Whether you’re working on a desktop or mobile, these steps will help you maintain a clean, focused view of your data, improving both efficiency and clarity in your work. Keep practicing these steps to become a more proficient Google Sheets user!
Marty is a digital marketer with over 8 years working with clients to introduce word class software solutions for their business.