How to Stop Showing Rows in Google Sheets: A Step-by-Step Guide

Hiding rows in Google Sheets is a handy skill to have when you’re dealing with a lot of data and want to keep your spreadsheet looking clean and organized. It’s a simple process: you select the rows you want to hide, right-click, and choose ‘Hide row’ from the menu. And just like that, those rows are out of sight! But don’t worry, they’re not gone forever; you can easily bring them back whenever you need to.

Step by Step Tutorial on How to Hide Rows in Google Sheets

Before diving into the steps, let’s understand what we’re going to accomplish. Hiding rows in Google Sheets allows you to temporarily remove them from view. This can be helpful when you want to focus on specific data or clean up your spreadsheet for a presentation.

Step 1: Select the Rows

Click on the row number(s) that you want to hide.

When selecting rows, you can click and drag to select multiple rows at once or hold down the ‘Ctrl’ key (or ‘Cmd’ on Mac) to select non-adjacent rows.

Step 2: Right-Click on the Row Number

After selecting the rows, right-click on one of the highlighted row numbers.

A menu will pop up with various options, one of which is ‘Hide row.’ Be sure not to click outside of the highlighted rows, or you’ll have to reselect them.

Step 3: Choose ‘Hide Row’

Click on ‘Hide row’ from the menu that appears.

Once you’ve clicked ‘Hide row,’ the selected rows will instantly be hidden from view. Don’t worry; you haven’t deleted anything. The data in the hidden rows is still there, just not currently visible.

After completing these steps, you’ll notice that the rows you hid are no longer visible in your Google Sheets document. However, you’ll see a small indicator in the row numbers column that shows where rows are hidden. You can always reverse this action by clicking on the indicators and choosing ‘Unhide row.’

Tips for Hiding Rows in Google Sheets

  • If you need to hide multiple non-adjacent rows, hold down the ‘Ctrl’ (‘Cmd’ on Mac) key while selecting the row numbers.
  • You can hide rows using the keyboard shortcut ‘Ctrl + 9’ (‘Cmd + 9’ on Mac) after selecting the rows you want to hide.
  • Double-check the data before hiding rows to ensure you’re not hiding crucial information that you may need to reference.
  • Consider adding a note or comment to indicate why certain rows are hidden, which can be helpful when collaborating with others.
  • Use the ‘Group’ feature to organize your rows into collapsible sections, which can be an alternative to hiding rows.

Frequently Asked Questions

Can I hide rows based on certain conditions?

Yes, you can use the ‘filter’ feature to hide rows based on specific criteria or conditions.

Is there a limit to how many rows I can hide in Google Sheets?

No, there’s no limit. You can hide as many rows as you need to.

Will hiding rows affect the calculations or formulas in my spreadsheet?

No, hiding rows does not affect calculations or formulas. All data in hidden rows is still included in any calculations.

Can other users see the rows I’ve hidden if I share the spreadsheet?

Yes, if you share the spreadsheet, others will see the rows as hidden, but they can unhide them unless you’ve protected those rows.

How do I unhide rows in Google Sheets?

To unhide rows, look for the small arrow indicators in the row header and click on them. Then, select ‘Unhide rows’ from the menu.


  1. Select the rows you want to hide.
  2. Right-click on the row number.
  3. Choose ‘Hide row’ from the menu.


Hiding rows in Google Sheets is an incredibly useful feature that can help you manage and organize your data more effectively. Whether you’re preparing a report, analyzing data, or collaborating on a project, knowing how to hide and unhide rows can make your life a whole lot easier. Just remember, the data isn’t gone, it’s just out of sight. So, feel free to hide away, secure in the knowledge that you can bring those rows back whenever you want. And who knows, maybe this simple yet powerful feature will open up new possibilities in how you handle your spreadsheets. Happy hiding!

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time. Read our Privacy Policy