How to Hide a Column in Google Sheets


Occasionally you will have a spreadsheet that becomes very large and difficult to work with. If that spreadsheet contains some information that you are no longer editing, or that you don’t need to view, then you might decide that you would like to hide the column.

Hiding a column is often preferable to deleting a column, as that column might contain information that you will need in the future, or that is being used in a formula. Our guide below will show you how to hide a column in Google Sheets, as well as how to unhide that column later, if necessary.

 

How to Hide a Column in a Google Sheets Spreadsheet

The steps in this article were performed in Google Chrome. These steps will work in other desktop Web browsers as well.

Step 1: Go to your Google Drive at https://drive.google.com/drive/my-drive and open the spreadsheet containing the column that you want to hide.

 

Step 2: Click the column heading above the column to hide. It’s the gray row of letters at the very top of the spreadsheet.

select a column in google sheets

 

 

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

how to hide a column in google sheets

 

 

To unhide a column in Google Sheets, simply click the small arrows that are left over on the surrounding column letters after the column has been hidden.

how to unhide a column in google sheets

 

 

Do you need to change the width of more than one column in your spreadsheet? Learn how to change multiple column widths at once in Google Sheets and save yourself a lot of time from doing it one by one.

birthday t-shirts for boys
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.