---
title: "How to hide rows in Google Sheets"
description: "If you're overwhelmed by large datasets in spreadsheets, here's how to hide rows in Google Sheets so you can see only the data you need."
image: "https://images.ctfassets.net/lzny33ho1g45/1d2ScS0XusebtTq7GvoL2T/783a6630bf45516429baa1a4e7ba4711/google-sheets-app-tips.jpg"
---

# How to hide rows in Google Sheets

If you're overwhelmed by large datasets in spreadsheets, here's how to hide rows in Google Sheets so you can see only the data you need.

I'm the kind of human who, when presented with too much information, short circuits. It's the case with restaurant menus that read more like textbooks (looking at you, Cheesecake Factory). And it's the same thing with [Google Sheets](https://zapier.com/blog/google-sheets-tutorial/).   

One way for me to reduce information overload while parsing data is to make unnecessary information temporarily disappear. 

Here, I'll show you how to hide rows in Google Sheets. (The same thing works to hide columns, too.) 

It's worth noting, though, that hidden rows and columns will still be included in any formulas used in your spreadsheet. If you plan on using formulas, I recommend [using filters](https://zapier.com/blog/how-to-filter-in-google-sheets/) to first narrow down your data instead. 

## How to hide rows in Google Sheets 

Here's the easiest way to hide rows in Google Sheets.

1. Open a Google Sheets spreadsheet.
2. Select the rows you want to hide.
3. Right-click your selection, and click **Hide rows [row numbers].** Or, use the [keyboard shortcut](https://zapier.com/blog/google-sheets-shortcuts/): `command`+`option`+`9` on Mac or `Ctrl`+`Alt`+`9` on Windows.

That's it. A pair of arrows will appear on the rows above and below your hidden selection to indicate there are hidden rows. 

To unhide your selection of hidden rows, click the pair of arrows. Alternatively, select the rows above and below your hidden selection, and use your keyboard shortcut: `command`+`shift`+`9` on Mac or `Ctrl`+`Shift`+`9` on Windows.

**Need to hide columns in Google Sheets instead?** Select the columns you want to hide, right-click the selection, and click **Hide columns [column letters]**. The same pair of arrows will appear in the letter header on either side of your hidden selection. Click the arrows to unhide your columns. 

## Automate Google Sheets 

Scanning through spreadsheets is draining. And so is entering data manually. Use Zapier to [connect Google Sheets](https://zapier.com/apps/google-sheets/integrations) with your go-to apps. This way, you can automate your most time-consuming spreadsheet-related tasks. For example, you can automatically add new lead data and form submissions to an existing spreadsheet. Learn more about [how to automate Google Sheets](https://zapier.com/blog/automate-google-sheets/), or get started with one of these workflow templates.   

**Related reading**: 

- [How to freeze columns in Google Sheets](https://zapier.com/blog/how-to-freeze-columns-google-sheets/)
- [How to split text in Excel and Google Sheets](https://zapier.com/blog/split-text-excel-zapier/)
- [Google Sheets add-ons to supercharge your work](https://zapier.com/blog/best-google-sheets-addons/)
- [How to create and use pivot tables in Google Sheets](https://zapier.com/blog/google-sheets-pivot-table/)