How to Hide & Unhide Columns in Google Sheet (2022 Update)

Working on a data-heavy sheet and want to hide some columns? Follow these tips to hide and unhide your data.

Shivam Kumar blogger image
Shivam Kumar
Updated on :

When you’re dealing with a data-heavy spreadsheet, sometimes it can be helpful to hide some unimportant columns to reduce distractions and get a better view of important data.

Fortunately, Google Sheets make it easy to do this.

In this tutorial, you’ll learn how to hide and unhide columns in Google Sheets.

Ready? Let’s get started…

01. How to Hide Columns in Google Sheets?

Let’s say we have a simple table containing Student’s Name, Registration ID, Gender, Age, Date, and Class.

Here we want to hide the Gender column from our view.

Here’s how we can do so…

  1. Select a column (or columns) you want to hide. To do this, simply click on the column heading letter (A, B, C, D…..) appearing at the top.
select a column to hide in Google Sheets
  1. Right click on the selected column and select Hide column option from the context menu that appears.
Hide Column in Google Sheets

That’s it… Your selected columns will get hidden and you’ll see arrows next to the two columns before and after the hidden columns.

Hidden column in Google Sheets

02. Hide Columns in Google Sheets With Shortcut

What if I tell you there is a quick keyboard shortcut to hide columns in Google Sheets?

Yes, if you’re a keyboard person like me then just select a column (or columns) and follow the shortcut given below:

Hold the CTRL + ALT keys and then press 0 (zero) on your keyboard.

Hide columns in Google Sheets with shortcut

This will hide the selected column.

03. Hide Columns in Google Sheets Application

If you are using Google Sheets on your smartphone, you can hide columns there as well.

Here are the exact steps you need to follow to hide columns in Google Sheets Android, as well as the iOS app.

  1. Open the worksheet in which you want to hide the column.
open google sheet document
  1. Select the column you wish to hide. To select multiple column, simply drag the little blue dots appearing at the both side of the selected column.
select column in Google Sheets android app
  1. Tap anywhere within the shaded area of the selected column, it will bring up a few options such as cut, copy, Auto-fill, etc. Tap on the three vertical dots appearing at the right of the menu.
Google Sheets option menu
  1. Select Hide columns option that appears in the pop-up menu.
Hide column in Google Sheets app

04. How to Unhide Column in Google Sheets?

When you hide a column (or columns), an arrow (caret icons) appears on the border between the two columns before and after the hidden columns.

The quickest way to unhide columns in Google Sheets is to click on one of the two arrows and it will show all the hidden columns between that specific arrow.

Unhide columns in Google Sheets

05. Unhide Column in Google Sheets – Large Datset

The above method is great if you have a few hidden columns and you can spot where columns are hidden in your spreadsheet.

But, what if you receive a large spreadsheet from your co-worker and it has hundreds of hidden columns here and there.

Don’t worry…

In that case, you can unhide all the hidden columns within 1 click without even manually spotting them.

Here is how:

  1. First, select the range of column which may have hidden column in between. To select all the column in your sheet, click on the first column and then press and hold the Shift key and select the last column. It will select all the column in your spreadsheet.
select all columns in Google Sheets
  1. Right-click anywhere and select “unhide columns” from the context menu that appears.
unhide all columns in google sheets

That’s it… It will unhide all the rows between the selected columns…

Google Sheets unhidden column


06. Final Thoughts:

When it comes to working on a large dataset, you often need to compare specific columns with each other.

If the distance between these columns is too much, it can be irritating at times to scroll right & left every time to read the data.

Once you learn how to hide columns in Google Sheets, it will be much easier to read, compare and analyze important columns without too much scrolling in the spreadsheet.

Over to you: Do you find this Google Sheets tutorial helpful? Let me know in the comment section.

Leave a Comment