NorthStar Analytics

HiDocs High-Quality Ghost Documentation Theme

How to hide rows in Google Sheets?

How to hide rows in Google Sheets?

There are sometimes too many rows, which you do not need when working with Google Sheets. Therefore you can hide them to avoid confusion.

You can hide a row with a right-click, or with the help of the 'help menu'. Let's take a look at the right click first.

Hiding Rows with Right Click

  1. Select the rows you want to hide.
  2. Right-click
  3. Hide row

Hiding Rows Using with Help Menu

  1. Select the rows you want to hide
  2. Click the help menu
  3. Write ‘Hide’
  4. Click -> Hide Rows

How to Hide Multiple Rows?

The steps for hiding mentioned above are just for a single row. To hide multiple rows, please follow these steps:

  1. Hide adjacent rows
  2. Go to the rows you want to select
  3. While holding down Shift, you can keep selecting to the right or left with the arrow sign; or you can select with the mouse while holding down Shift. For example, we want to select rows A and rows D and in between. If we select rows A first and then rows D while holding down SHIFT, the in-between ones will be automatically selected.
  4. Hide a discrete row by selecting the rows you want. Select the other rows while holding down CTRL. In this way, the remaining rows are not selected.

Hiding Rows with a Shortcut

  1. Select the rows you want to hide. (Selecting multiple rows mentioned above)
  2. Ctrl+Alt+9 (hold down Ctrl + Alt at the same time and press 9).

How to Unhide Rows?

How to make hidden rows visible? An arrow appears between the hidden rows. This is the hidden rows indicator. Click on the arrow signs so that signs and rows will become visible again.

That's it for hiding rows. You can find a detailed article about making rows visible here->" How to unhide rows in Google Sheets?"

Make your business data transparent!
  • Subscribe to a package

    Subscribe and explore the limits of your business with data or thinking to expand your agency value proposition with Google Data Studio dashboards?

  • Request unlimited dashboards

    You can request as many dashbaords you might have and as many revisions as you might need. We create a queue of your tasks, the first tasks that come in are the tasks that we’ll deliver first.

  • Your Data Studio Department

    Optimise your business with complete transparency through dashboards or provide value-added Google Data Studio service to your agency clients.

Make your business transparent

The fastest easy-to-use Google Data Studio dashboards without any recurring cost.