How to Hide Columns in Google Sheets [Best Method for 2023]

4 Minutes

The hide columns feature in Google Sheets is a great tool to help you focus on specific data without deleting key information and can be implemented both consecutively and non consecutively.

How to Hide a Column in Google Sheets

We have created a sample sheet for you to follow along with our steps. Click here to access the spreadsheets and follow along.

Step 1: Select the Column you want to Hide

The row of letters at the top of each column are called headers, by clicking this letter you will highlight the entire column.

*How do you conceal a column in Google Sheets*

Step 2: Right click on the Column Header to Show the Dropdown Menu

By right clicking the header the dropdown menu will display.

*How do you conceal a column: Display menu*

‍

Step 3: Select Hide Column to Hide your Selected Column(s)

From the menu select the Hide column option.

Once selected the menu will disappear and you will see your data with the chosen column now hidden from view. Note that although hidden from view, the information will still be referenced by any formulas implemented.

*How do you conceal a column in Google Sheets: Results*

How to Hide Multiple Sequential Columns in Google Sheets

Step 1: Select Your Sequential Columns

Click one of the headers you want to conceal then drag the cursor over to the next one, highlighting them both.

*Hiding more than one column in Google Sheets*

Step 2: Right Click on a Highlighted Column Header to Display Column Options

Right click on either of the selected headers for the dropdown menu, this will display options for the highlighted ranges.

Step 3: Select Hide Columns

Select Hide columns C-D. In our example sheet below ‘B’ to ‘E’ now are the only ones showing with ‘C’ and ‘D’ hidden.

‍

How to Hide Multiple Non-consecutive Columns in Google Sheets

Step 1: Select your First Column

Select the first column you want to highlight by clicking the header.

*Hiding more than one column: Selection*

Step 2: Hold Command ⌘ + Click (Mac) or CTRL + Click (Windows) to Highlight Target Columns

Hold the ⌘ key down on a Mac or CTRL on Windows and select the header of the next column you want to highlight. In this case we have selected column ‘B’ and ‘D’

*Hiding more than one column: Multiple column selection*

‍

Step 3: Right Click on a Column Header to display the Column Menu

Right click on one of the selected headers only. The dropdown menu will appear.

*Hiding multiple columns in Sheets: Menu*

‍

Step 4: Hide your Selected Columns

Select Hide columns from the dropdown menu. The selections are now hidden

‍

How to Unhide a Column in Google Sheets

Check out our brief tutorial on how to unhide columns in Google Sheets.