In this tutorial, you will learn 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.
How To Hide And Unhide Columns In Google Sheets
Quick Navigation
Before we begin we will need a group of data to be used to hide and unhide columns in Google Sheets.
Step 1
First, you need to have a clean and tidy group of data to work with.
Step 2
In this example, we want to hide the data for female. First, select column B and D, then right-click and select Hide columns.
Step 3
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.
Step 4
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.
Summary
That’s all there is to it. You are welcome to copy the example spreadsheet below to see how it is done. The most crucial lesson is to enjoy yourself while doing it.
In this tutorial, I covered how to hide and unhide columns in Google Sheets. Want more? Check out all the Google Sheets Tutorials.