How to Hide Columns in Google Sheets

Key takeaways

• To hide columns in Google Sheets, open your Google Sheet, highlight the columns to hide, and right-click and choose Hide columns.

• To hide multiple columns in Google Sheets, you simply need to hold down the Shift key when you select the column headers to hide.

• To unhide hidden columns in Google Sheets, select the columns on both sides of the hidden columns, right-click, and click Unhide columns.

Hiding rows in Google Sheets is similar to hiding columns, but you highlight rows instead of columns. Read on for detailed steps on how to hide columns in Google Sheets so you can focus on the key information you’re looking for.

If you’re ready to develop your data analysis skills, consider earning a Google Data Analytics Professional Certificate, where you will have the opportunity to learn in-demand skills like data cleaning and visualization, Python programming, data analysis, and more in as little as six months.

Why learn how to hide rows and columns in Google Sheets?

When you work with data in Google Sheets, hiding data or information columns can help declutter your spreadsheet without losing your information. Hiding columns can also be a useful tool to compare two columns or rows that are not next to each other, as you would temporarily hide the information in between.

How to hide columns in Google Sheets in 3 easy steps

To help you learn how to hide columns in your Google Sheets spreadsheet, we’ve provided a breakdown of the steps you need to know. Here is a quick guide on how to hide columns:

• Open your Google Sheet.

• Highlight the columns to hide.

• Right-click and choose “Hide columns.”

You can also apply these same steps to learn how to hide rows in Google Sheets by highlighting rows instead of columns. Now, let’s go over each step.

1. Open your Google Sheet.

Begin by opening the Google Sheet that contains the columns you want to hide. If you don't have a specific data set, you can use a sample template provided by Google Sheets or create your own sheet to follow along with this tutorial.

2. Highlight the columns to hide.

Click on the column letter of the first column you want to hide. For example, if you want to hide column E, click on the letter E at the top of the sheet.

Pro tip: If you want to hide multiple columns, press the Shift key while clicking the headers of all the columns you want to hide. You will notice the selected columns getting highlighted. In the image below, we have selected columns E and F.

3. Right-click and select “Hide columns.”

After you select the desired columns, right-click on any of the selected column letters. In the menu that appears, click on Hide columns.

Once you click Hide columns, the columns will disappear from view, allowing you to focus on the relevant data.

How to make collapsible columns in Google Sheets?

You can make columns collapsible in Google Sheets by first organizing data into groups. To do this, select the columns you want to group, then select View > Group and choose Group columns. This will give you the ability to both expand and collapse groups of columns by selecting the corresponding plus or minus symbol.

How to hide and unhide columns in Google Sheets

Unhiding columns follows a similar process to hiding columns. To bring back the hidden columns, select the columns on both sides of the hidden columns to ensure the hidden columns are included in the selection.

From here, right-click on any part of your selection. Then, in the menu that appears, click Unhide columns. The previously hidden columns will now be visible again.

Pro tip: You can also unhide columns by clicking on the left- or right-facing arrows that appear next to the hidden column letters.

Common errors when hiding columns

When hiding columns in Google Sheets, it is important to carefully examine the data you are hiding ahead of time. If you have a large spreadsheet and do not keep track of your hidden information, you may have trouble accessing it when needed. To be cautious, ensure that the columns you hide do not contain critical information you currently need for calculations, analysis, or reports.

Read more: Google Sheets Automation: A Step-by-Step Guide

Navigate your next career move with confidence

Explore career paths, assess your skills, and connect with resume guidance while browsing our Career Resources Hub. You can also learn more about using spreadsheet tools with our other free resources:

• Watch on YouTube: How to Highlight Duplicates in Google Sheets

• Read our Career Chat issue: Top Skill Alert: Open Doors With Spreadsheets

• Follow a tutorial: Google Sheets Linear Regression: Learn Predictive Modeling

If you’re interested in developing a new skill or want to get comfortable with an in-demand technology, keep growing with a Coursera Plus subscription. You’ll get access to over 10,000 flexible courses.

Build job-ready skills with Coursera Plus

Start 7-day free trial

• 
• 
• 
• 

Start 7-day free trial