NorthStar Analytics

HiDocs High-Quality Ghost Documentation Theme

How to hide and unhide columns in Google Sheets?

How to hide and unhide columns in Google Sheets?

There are sometimes too many columns when working with Google Sheets, which you do not always need. You can hide columns to avoid confusion.

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

Hide Columns with Right Click

  1. Select the column you want to hide.
  2. Right-click and click hide column

Hide Columns with the Drop-Down Menu

  1. Select the column you want to hide
  2. Click the drop-down menu sign
  3. Hide column

How to Hide Multiple Columns?

The hiding steps mentioned above are valid for a single column. To hide multiple columns:

  1. Hide adjacent column
  2. Go to the column you want to select
  3. While holding down Shift, you can continue to make selections 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 column A and column D and in between. When we select column A first and then column D while holding down SHIFT, the in-between ones will be automatically selected.

Hide a discrete column

To select non-adjacent columns;

  1. Choose a column
  2. While holding down CTRL, select the other columns you want.

Thus, the columns in between are not selected. You just select the columns where you want them.

Hide Columns with Shortcut

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

How to Unhide a Column

How to make hidden columns visible?

  1. An arrow appears between the hidden columns. This is the hidden column indicator.
  2. Click on the arrow signs so that column will become visible again.

That's it for hiding and unhiding columns.

How to hide rows? You can find detailed information here->"How to hide rows in Google Sheets?"

How to unhide rows? You can find detailed information 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.