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.
We have created a sample sheet for you to follow along with our steps. Click here to access the spreadsheets and follow along.
The row of letters at the top of each column are called headers, by clicking this letter you will highlight the entire column.
By right clicking the header the dropdown menu will display.
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.
Click one of the headers you want to conceal then drag the cursor over to the next one, highlighting them both.
Right click on either of the selected headers for the dropdown menu, this will display options for the highlighted ranges.
Select Hide columns C-D. In our example sheet below ‘B’ to ‘E’ now are the only ones showing with ‘C’ and ‘D’ hidden.
Select the first column you want to highlight by clicking the header.
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’
Right click on one of the selected headers only. The dropdown menu will appear.
Select Hide columns from the dropdown menu. The selections are now hidden
Check out our brief tutorial on how to unhide columns in Google Sheets.
If you enjoyed this article, you might also like our article on how to delete a column in Google Sheets or our article on how to change cell size in Google Sheets.
If you want to learn how to send email notifications from Google Sheets, we also suggest checking out our detailed guide.
