Skip to content

App tips

1 min read

How to hide rows in Google Sheets

By Jessica Lau · February 1, 2024
A hero image for Google Sheets app tips with the Google Sheets logo on a green background

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.   

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 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: command+option+9 on Mac or Ctrl+Alt+9 on Windows. 

    Example of how to hide rows in Google Sheets.

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

Example of hidden rows in Google Sheets.

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.

Demo of how to unhide rows in Google Sheets.

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. 

If you want to prevent others from editing hidden columns or rows, check out how to lock cells in Google Sheets.

Automate Google Sheets 

Scanning through spreadsheets is draining. And so is entering data manually. Use Zapier to connect Google Sheets 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, or get started with one of these workflow templates.   

Collect new Typeform responses as rows on Google Sheets

  • Typeform logo
  • Google Sheets logo
Typeform + Google Sheets
More details
    Forms are great at capturing user information, but exporting their results takes time. Zapier can help you analyze those entries in a spreadsheet automatically with this integration. Once you set it up, it will catch every new entry you receive on a Typeform, saving the results to a new row on Google Sheets so you don't have to do it yourself.

    Add Google Sheets rows for new Google Forms responses

    • Google Forms logo
    • Google Sheets logo
    Google Forms + Google Sheets
    More details
      Store responses from your forms directly in a spreadsheet! Use Zapier to automatically send those form responses right in a spreadsheet, and never worry about missing any submissions again.

      Add new Facebook Lead Ads leads to rows on Google Sheets

      • Facebook Lead Ads logo
      • Google Sheets logo
      Facebook Lead Ads + Google Sheets
      More details
        Spreadsheets make it easy to filter and sort through new prospects, but take time to build. Use this Facebook Lead Ads-Google Sheets integration to link your records directly to your ads so you can keep your mind on marketing. After being set up, every new ad lead on Facebook will trigger this Zap, automatically creating a new row on Google Sheets with all those valuable details for you. Learn more in our

        Add new leads in LinkedIn Ads to Google Sheets rows

        • LinkedIn Ads logo
        • Google Sheets logo
        LinkedIn Ads + Google Sheets
        More details
          Your time is best spent nurturing new prospects, not on data entry. Set up this integration to automatically save information submitted by new leads to your LinkedIn Lead Gen Form to a new row in a specified Google Sheets spreadsheet. Sort and filter through them at will, while saving time and effort!

          To get started with a Zap template—what we call our pre-made workflows—just click on the button. It only takes a few minutes to set up. You can read more about setting up Zaps here.

          Related reading

          Get productivity tips delivered straight to your inbox

          We’ll email you 1-3 times per week—and never share your information.

          Related articles

          Improve your productivity automatically. Use Zapier to get your apps working together.

          A Zap with the trigger 'When I get a new lead from Facebook,' and the action 'Notify my team in Slack'