How To Hide Columns From Certain Users in Google Sheets

Last Updated on October 31, 2023 by Jake Sheridan

In this tutorial, you will learn how to hide columns from certain users in Google Sheets.

How To Hide Columns From Certain Users in Google Sheets

You can easily hide columns from certain users 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 columns from certain users in Google Sheets.

Before we begin we will need a group of data to be used to hide columns from certain users 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

To make sure users are unable to unhide the columns, make sure you are sharing the access link with limitation to only viewing.

Summary

In this tutorial, I covered how to hide columns from certain users in Google Sheets. Want more? Check out all the Google Sheets Tutorials.