0:00
Hey everybody. In this video tutorial,
0:02
I'm going to show you how to lock a
0:04
Google Sheets tab in a Google Sheets uh
0:07
spreadsheet. All right. So, let's say
0:08
you have this new project tab in this
0:11
project management sheet. You want to
0:13
make sure that nobody else edits this uh
0:16
table and any other cell in this tab.
0:19
So, in that case, what he can do is lock
0:22
this complete tab. And here's how to do
0:24
it. So all you have to do is go to the
0:27
data in the menu bar. Click on that and
0:31
you're going to see protect sheets and
0:32
ranges from this dropdown. Select that
0:35
one and then you will see the protected
0:38
sheets and ranges that have been already
0:40
created. So protected sheets are
0:42
basically locked sheets. So what you
0:45
have to do do is click on add a sheet or
0:48
range and instead of a range where you
0:50
can select a table multiple cells or
0:52
just one simple cell what you have to do
0:55
is select sheet here and then you can
0:57
select the specific uh tab or sheet you
1:00
want to uh lock in your Google
1:02
spreadsheet. So let's say in this
1:04
example this new project tab and then we
1:07
can add a description so later we know
1:10
what sheet we have locked. Then we have
1:13
to click set permissions and then you
1:15
have multiple options. So if you want to
1:17
lock Google sheets tab you have to
1:18
select restrict who can edit this range
1:21
and we have this custom option where you
1:24
can add editors. So in this case uh this
1:27
person would also have access to this
1:30
spreadsheet. But what you can also do is
1:32
select only you in which case only you
1:35
will be able to add this uh Google
1:37
sheets tab and no one else will be able
1:40
to do that. So if you click on done,
1:42
change is saved. As you can see, it has
1:44
been added to the protected sheets and
1:46
ranges section here. This new project
1:49
sheet and as you can see it's now
1:51
locked. So only you can edit it. So now
1:55
this is how to lock a complete Google
1:57
Sheets tab in a Google Sheets
1:58
spreadsheet. I hope you found this
2:00
tutorial useful. If you want to get
2:02
access to our complete Google Sheets
2:04
function database or our Google Sheets
2:07
shortcut keys ebook for free and other
2:09
Google Sheets resources and Google
2:11
Sheets templates, then make sure to
2:13
check the links in the description
2:15
below. Also, if you want to learn more
2:17
about how to use Google Sheets, make
2:19
sure to check out our YouTube channel
2:20
and playlists where we have a ton of
2:22
tutorials and more Google Sheets
2:24
tutorials are coming up. So, also make
![Video thumbnail for How To Lock A Google Sheets Tab In Google Spreadsheets? [in 2025]](https://video-meta.open.video/resized-posters/0w9BvkVJQl2/res640.webp?cb=0)
