How to Hide Column in Google Sheets: A Step-by-Step Guide

Hiding a column in Google Sheets is a simple process. Right-click on the column letter at the top, then select “Hide column” from the dropdown menu. Voila, the column disappears from view, but don’t worry, it’s not gone for good. You can easily access it again whenever you need it.

After you hide the column, it will no longer be visible on your sheet, but the data within it is still there, safe and sound. A small arrow indicator will appear where the column used to be, signaling that a column is hidden in that spot.


Have you ever found yourself in a situation where your Google Sheets spreadsheet is just too cluttered? Maybe you have some sensitive information you don’t want just anyone to see, or maybe you’re doing a presentation and only want to show relevant data. Whatever the reason, hiding a column in Google Sheets can be a nifty trick to have up your sleeve.

Google Sheets is a powerful tool used by millions for everything from budgeting to project planning. Knowing how to navigate and manipulate your data effectively can save you time and make your work much more efficient. Hiding columns is one such skill that can help keep your work organized and focused. This feature is particularly useful for professionals dealing with large datasets or teachers managing student information. It allows you to customize your view and protect sensitive data without altering or deleting any information.

How to Hide Column in Google Sheets Tutorial

Before we dive into the specifics, let me give you a heads up on what these steps will achieve. By the end of this tutorial, you’ll be able to hide any column in your Google Sheets document, which can help you focus on the data that matters most to you at any given time.

Step 1: Select the Column

Click on the letter of the column you wish to hide.

When you select the column, the entire column will be highlighted, indicating that it is ready for you to perform an action on it.

Step 2: Right-click on the Column Letter

Right-click on the column letter to bring up a menu of options.

A drop-down menu will appear with various actions you can take. It’s important to click on the column letter, not the cells within the column, to ensure you’re selecting the entire column.

Step 3: Choose “Hide column”

From the menu, select “Hide column.”

The column will immediately disappear from view, decluttering your sheet in the process. The action is instantaneous, so be sure you’re ready to hide the column before clicking.


FocusHiding columns allows you to focus on the data that is immediately relevant to the task at hand without the distraction of unnecessary information.
OrganizationIt can improve the organization of your data, making it easier to navigate and understand large spreadsheets.
SecurityWhen you need to share a spreadsheet but want to keep certain data private, hiding columns is a quick way to secure that information.


Overlooked DataHidden columns can sometimes be forgotten, leading to confusion or errors if you or someone else is unaware that data is missing from view.
Accidental DeletionWhen columns are hidden, it’s easier to accidentally delete them because they are out of sight. Users must be careful when editing the sheet.
Limited AccessibilityOn mobile devices or in a shared setting, it might be harder to access or unhide the columns, which could limit the usability of the spreadsheet.

Additional Information

When working with Google Sheets, it’s essential to understand the impact of hiding columns on your overall workflow. Although the process is reversible, frequent hiding and unhiding can become cumbersome, especially in collaborative environments. It’s always best practice to inform your collaborators if you are hiding columns to avoid any potential confusion or data mishaps. Also, remember that while the column is hidden, the data within it can still be referenced in formulas, which means your calculations will remain accurate even if the source data isn’t immediately visible.

Another handy tip is to use color-coding or notes to mark hidden columns, making it easier to remember their existence and purpose when you’re skimming through your sheet. And if you’re worried about privacy, know that even if you share a sheet with hidden columns, viewers won’t be able to see them unless they have edit access and know how to unhide them.

Remember, hiding columns in Google Sheets doesn’t delete the data; it simply tucks it out of sight. This can be particularly helpful when you’re dealing with sensitive information that you don’t want to display during a presentation or screen share.


  1. Select the column you want to hide.
  2. Right-click on the column letter.
  3. Choose “Hide column” from the menu.

Frequently Asked Questions

How do I unhide a column in Google Sheets?

To unhide a column, click on the arrows that appear in the column headers where the hidden column should be, and the column will reappear.

Can I hide multiple columns at once?

Yes, you can hide multiple columns by clicking and dragging to select multiple column letters before right-clicking and selecting “Hide columns.”

Is there a shortcut to hide columns in Google Sheets?

There currently isn’t a keyboard shortcut to hide columns in Google Sheets, but you can use the right-click menu or the “View” menu at the top to hide them.

Will hiding columns affect my data?

Hiding columns does not affect the data within them; it simply removes them from view. The data can still be referenced in formulas and calculations.

Can viewers see hidden columns?

Viewers with “View” access cannot see hidden columns, but those with “Edit” access can unhide and view the columns if they choose.


Mastering the art of hiding columns in Google Sheets is a game-changer for anyone looking to streamline their data management and presentation. It not only helps with organization and focus but also adds a layer of security for sensitive information. As you become more familiar with Google Sheets, you’ll find that this feature, alongside many others, can significantly enhance your productivity and data analysis capabilities.

So go ahead, give it a try and see how it can benefit your spreadsheets. And if you ever find yourself in a pickle, just remember, there’s always a way to unhide that column and bring your data back into the spotlight.

Get Our Free Newsletter

How-to guides and tech deals

You may opt out at any time.
Read our Privacy Policy