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.
Step 3: Right-click the selected column, then choose the Hide column option.
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.
If you would like to unhide the hidden column, select the two columns around the hidden one, then choose the Unhide column option.
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 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.