How To Hide Columns in Google Sheets

Last Updated on October 31, 2023 by Jake Sheridan

In this tutorial, you will learn how to hide columns in Google Sheets.

Sometimes, you might need to hide a column or two in Google Sheets. It might be because it’s not useful anymore, or maybe you want to temporarily get rid of it while you’re working on a project.

Whatever the reason, hiding the column will make your document look neater. This can also help to reduce data entry errors.

So, how do you hide these columns on Google Sheets?

How To Hide a Column in Google Sheets (2 methods)

Here’s how to hide Google Sheets columns for desktop and mobile devices:

Method #1 – Hide columns on desktop

First, you’ll need to open a new Google Sheet on your desktop. Then, you will now decide to hide either a single column or a group of columns.

To hide a single column, you have to right-click on that particular column letter, and from the menu that pops up, click on Hide Column.

If you want to hide more than one column, you have to select a range of specific columns.

To select a range of columns, you have to select a cell and then tap on the shift button on your system to select as many columns as you want.

Then, right-click for a menu that contains Hide Columns to pop up, and you can choose that option:

 This will hide all the columns selected.

Method #2 – Hide columns on Android, iPhone, or iPad

For this step, you can open the App by tapping on the Google Sheets App on your device.

Then select the column or columns you want to hide.

To select more than one column, you have to tap the blue dot that is usually located in the center of the screen. Drag it to select additional columns.

Just lift up your finger after all the desired columns you need hidden have been selected.

After that, tap anywhere in the selected area that is shaded, and options such as cut, copy, etc. will show up.

Then depending on your device:

  • On your iOS device, you will continue to click on the arrow that shows up as part of the option until the Hide option is shown. Then tap the Hide option to hide the selected columns.
  • On your Android device, you have to tap on the three (3) dots for an additional menu to show up, then tap on Hide to cover all the columns selected.

Now you’ve learned how to hide columns from Google Sheets, you can hide as many columns as you want to make your work look more presentable.

This will help improve your efficiency and make your document easier to read.
 

 

Summary

In this tutorial, I covered how to hide columns in Google Sheets. Want more? Check out all the Google Sheets Tutorials.