• Skip to main content

Master Your Tech

Mobile phones, software, consumer electronic how-to guides

  • iPhone
  • Excel
  • Powerpoint
  • Word
  • Google Drive
You are here: Home / Google Drive / How to Hide Columns in Google Sheets

How to Hide Columns in Google Sheets

posted on March 17, 2019

When you are working on a spreadsheet in the Google Sheets application, it’s pretty common that your original data layout may not be what you ultimately need.

Whether you find that you don’t need certain data at all, or that some data is in the wrong location, there are a few options you have that let you restructure your spreadsheet. While you might consider deleting rows or columns as part of this restructuring, there could be data in those locations that you need later. Our guide below will show you how to hide columns in Google Sheets so that the data isn’t visible, but can still be used or accessed in the future.

Google Sheets – Hiding Columns

The steps in this article were performed in the desktop version of the Google Chrome Web browser, but will also work in other desktop browsers like Firefox or Safari.

Step 1: Sign into your Google Drive at https://drive.google.com and open the Sheets file containing the column you want to hide.

Step 2: Select the column letter at the top of the spreadsheet for the column of data that you want to hide.

select the column to hide

Step 3: Right-click the selected column, then choose the Hide column option.

how to hide columns in google sheets

Note that if you have hidden a column with data that is included in a chart you will see a pop up at the bottom of the window where you can elect to continue including that data in the chart.

google sheets hidden data in charts

If you would like to unhide the hidden column, select the two columns around the hidden one, then choose the Unhide column option.

how to unhide column in google sheets

You can select multiple columns by clicking on one of them, then holding down the Ctrl key on your keyboard and clicking the other column.

Matthew Burleigh
Matthew Burleigh

Matthew Burleigh has been a freelance writer since the early 2000s. You can find his writing all over the Web, where his content has collectively been read millions of times.

Matthew received his Master’s degree in Computer Science, then spent over a decade as an IT consultant for small businesses before focusing on writing and website creation.

The topics he covers for MasterYourTech.com include iPhones, Microsoft Office, and Google Apps.

You can read his full bio here.

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Filed Under: Google Drive

Search

  • Contact Us
  • Privacy Policy
  • Terms and Conditions

Copyright © 2023 MasterYourTech.com