Show or hide columns in Google Sheet

  • Reading time:3 mins read
  • Post category:Formatting
  • Post comments:0 Comments

At times, certain columns become redundant in the course of editing a spreadsheet. And while presenting the spreadsheet to someone you prefer to keep them hidden.

As such occasions it becomes important to know how to show or hide columns in Google Sheet.

The process is pretty straightforward and is very easy to execute. Let’s begin.

Using Keyboard Shortcut to hide columns in Google Sheet

This is probably the easiest of the lot. Follow the below steps:-

  1. Select any cell in the column which you want to hide
  2. Now type “CTRL+ALT+0(zero)”

The column will get hidden as expected.

If you need to hide multiple columns then simply repeat the steps 1,2 multiple times.

Hiding Column in Google Sheet using Right Click Option

This approach is most well known and widely used. Follow the below steps:-

  1. Click the header of the Column you want to hide
  2. Now Right Click
  3. Select Hide Column

Step 1: Say we want to Hide Column B. We go to header of column and right click.

Right Click a Column Header

Step 2: Click “Hide Column”

Right Click a Column HEader

Step 3 : Column B, gets hidden as expected.

Hiding Columns in Google Sheet

If you want to hide multiple columns then we have two ways to do it:

1. Repeat the above mentioned step multiple times.

In the below illustration we will hide Columns B & D.

Hiding Multiple Columns in Google Sheet

2. Select multiple columns before hiding it.

In the below illustration we first select columns B & D. Simple way to do it is press Control and click on column headers.

Then we press right click and select “Hide columns

Hiding Multiple Columns in Google Sheet

Unhiding Columns in Google Sheet

Knowing to Unhide the columns is as important as knowing to hide it.

Here’s a simple hack. All hidden columns come with a two sides arrow symbol.

Unhiding Column in Google Sheet

We simply have to click it to show the hidden columns.

Unhiding Column in Google Sheet

Other way is to simply select the columns around the hidden column. Right Click and select “Unhide Columns”.

Unhiding Column in Google sheet

Closing Remarks

As you would have seen this was easy tutorial overall. You might also be interested in showing/hiding rows. If Yes, click the link below to read it.

An important call out is that we can hide rows or columns in Google Sheet. However, there is no particular way to hide specific cells in Google Sheet standalone.

That’s it on this topic. If you face any issues in implementing the above methods then leave a comment down below. Keep browsing SheetsInfo for more such useful information 🙂

How useful was this post?

Click on a star to rate it!

Average rating 5 / 5. Vote count: 1

No votes so far! Be the first to rate this post.

Liked the content?? Then share the word!!!

Rishav

I love Google Sheets and heavily rely upon it on a day to day basis. SheetsInfo is my attempt to share my learning with all of you. Hope you find the articles easy to read and simple to understand.

Leave a Reply