How to Hide a Column in Google Sheets - Tips from a Spreadsheet Enthusiast

Hey, spreadsheet fans! Are you in a situation where you need to hide a column in your Google Sheets, but you're not sure how? No need to worry, my fellow number crunchers. With my years of experience as a spreadsheet enthusiast, I've picked up a few tricks to make your life easier. In this article, I will teach you how to hide a column in Google Sheets, using easy steps that anyone can follow.

Why Hide a Column in Google Sheets?

Before I show you how to hide a column, let's talk about why you might want to do this in the first place. One of the most common reasons to hide a column is to remove unnecessary information from view. Maybe you have a large dataset, and you don't need to see all of the columns at once. Maybe there's confidential data in one column that you don't want others to see. Whatever the reason, hiding a column can make your sheets easier to read and protect your sensitive information from prying eyes.

How to Hide a Column in Google Sheets - Step by Step

Here are the simple steps to hide a column in Google Sheets:

  1. Select the column you want to hide. You can do this by clicking on the column letter. For example, if you want to hide column G, click on the letter "G" at the top of the sheet.
  2. Right-click on the selected column. A drop-down menu will appear.
  3. Select "Hide column" from the drop-down menu. The selected column will disappear from view.

See? Easy peasy! Just three simple steps, and you're on your way to a cleaner, more organized spreadsheet. But wait, there's more!

Bonus Tip: Unhide a Hidden Column in Google Sheets

Let's say you've hidden a column and then need to bring it back for whatever reason. No need to panic. You can easily unhide a hidden column by following these steps:

  1. Select the columns before and after the hidden column. For example, if you hid column G, select columns F and H.
  2. Right-click on the selected columns. A drop-down menu will appear.
  3. Select "Unhide columns" from the drop-down menu. The hidden column will reappear between the selected columns.

And just like that, your column is back! Now you can keep working on your masterpiece of a spreadsheet.


So there you have it! By using the simple steps outlined in this article, you can easily hide and unhide columns in Google Sheets. No more fussing or fretting about how to make your spreadsheet look the way you want. By utilizing these tricks, you'll save time and make things easier on yourself. Happy spreadsheet-ing!

By clicking “Accept”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.