How to Hide a Column in Google Sheets

Sometimes when you are creating a spreadsheet you will focus first on adding all of the data, then format everything so that it is more presentable for your audience. This could include things like making it look better when you print, or applying the correct type of formatting for your data.

But you may discover that you have added data that your audience doesn’t need to see, or may create some confusion. While your initial thought could be to simply delete the column with that data, it’s possible that you could need that data later, or that it is part of a formula. One way to resolve this is to hide that column. This keeps the data in the spreadsheet, but removes it from view.

Hiding Columns in Google Sheets

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 Edge.

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

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

select the column to hide

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

how to hide a column in google sheets

If you decide later to unhide the column, select the column to the left and to the right of the hidden column, then choose the Unhide column option.

how to unhide a column in google sheets

You can hide other things in Google Sheets, too, such as an entire worksheet. Find out how to hide a worksheet tab in Google Sheets if there’s an entire sheet that you don’t want to be visible.