In this article:

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

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.

Hiding more than one column: Menu

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.

Hiding more than one column: Results

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 

Conceal multiple columns: Results

How to Unhide a Column in Google Sheets

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

Use our insurance renewal reminder software to easily set up custom reminders from your spreadsheet in just a few clicks. 

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.

Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
ADDCALENDAREVENT
Creates a one- or multiple-day calendar event with optional attendees
ADDHUBSPOT
Adds an object to Hubspot
ADDSLACKCHANNEL
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
CREATEGOOGLEDOC
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL
Sends an email using your Google account
SENDOUTLOOK
Sends an email using your Microsoft Outlook account
SENDSLACK
Sends a Slack message
SENDSMS
Sends an SMS message using your Twilio account
UPDATECELL
Updates cells with given values
UPDATEHUBSPOT
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started