Last Updated on October 31, 2023 by Jake Sheridan
How To Hide And Unhide Columns In Google Sheets
You can easily hide and unhide columns using native Google Sheets tools with a click away!
Once ready, we’ll get started by utilizing real-world examples to show you how to hide and unhide columns in Google Sheets.
Before we begin we will need a group of data to be used to hide and unhide columns in Google Sheets.
First, you need to have a clean and tidy group of data to work with.
In this example, we want to hide the data for female. First, select column B and D, then right-click and select Hide columns.
Once you are done, your Google Sheets will look like this. You can only see the data for males shown on the Google Sheet. There will be arrows in between the columns to indicate there are hidden columns.
You can simply unhide the columns by selecting the entire data group, right-click, and selecting Unhide columns. Once you are done, your data for Females will be shown on the Google Sheets.
In this tutorial, I covered how to hide and unhide columns in Google Sheets. Want more? Check out all the Google Sheets Tutorials.