0:00
Hey everybody. In this video tutorial,
0:02
I'm going to show you how to lock cells
0:04
in a Google Sheets spreadsheet. Right?
0:07
So, if you want to lock so protect a
0:09
specific cell or a table or a whole
0:12
spreadsheet in Google Sheets, here's how
0:14
to do it. So, let's say we have this
0:16
project management sheet and we have
0:18
this project management table and we
0:20
don't want people who have access to
0:22
this sheet to change project status
0:25
here, the project name here and stuff
0:27
like that. So in that case what we have
0:29
to do is lock the cells. So I selected
0:32
the table then we can right click on
0:34
that table and then we can go to view
0:36
more cell actions and we're going to see
0:39
protect range or we can also click on
0:42
data in the menu bar and we also have
0:45
protect sheets and ranges here. And if
0:47
you have selected previously something
0:50
by default that range will be selected
0:52
here in the range section but you can
0:55
also change this later if you want. As
0:57
you can see by clicking on select data
0:59
range yours, you can also add the name
1:03
uh protected or locked range we have.
1:08
And then once you added the name and
1:11
selected the range you want to lock,
1:13
then you have to click on set
1:14
permissions. And as you can see, you can
1:17
completely lock. So restrict who can
1:19
edit this range or you can just show a
1:21
warning when editing this range. But in
1:24
this case, let's say let's restrict who
1:25
can edit this range. We can select it to
1:28
only you or we can add a custom option
1:31
and add editors here who can also edit
1:35
that range. But besides those people,
1:37
nobody else will be able to uh edit that
1:40
locked range we have. But let's say we
1:42
only want oursel to be able to edit this
1:45
locked cell range. Then click on done.
1:48
And as you can see change is saved. And
1:50
now if I go to another profile which I
1:53
have also opened the same Google
1:55
spreadsheet. And if I go to this section
1:57
as you can see we have this um grayed
2:00
out area and I cannot do anything. There
2:03
is a problem. You are trying to edit a
2:05
protected cell or object. So as you can
2:08
see so all in all this is how you can
2:10
lock cells or ranges in a Google sheets
2:13
spreadsheet. I hope you found this
2:15
tutorial useful. If you want to get
2:17
access to our complete Google Sheets
2:19
function database or our Google Sheets
2:22
shortcut keys ebook for free and other
2:24
Google Sheets resources and Google
2:26
Sheets templates, then make sure to
2:28
check the links in the description
2:29
below. Also, if you want to learn more
2:31
about how to use Google Sheets, make
2:33
sure to check out our YouTube channel
2:35
and playlists where we have a ton of
2:37
tutorials and more Google Sheets
2:38
tutorials are coming up. So, also make
![Video thumbnail for How To Lock Cells In A Google Sheets Spreadsheet? [in 2025]](https://video-meta.open.video/resized-posters/038QvkVcll2/res640.webp?cb=0)
