Skip to playerSkip to main content
  • 3 weeks ago
Learn how to protect cells from editing in Google sheet or how do I lock a cell in a spreadsheet? Alternatively, how do I lock cells in Google sheet formula?
Some people like to ask it as how to lock specific sale in Google sheet or how to lock sales and give editing permission to selected users. If that doesn't work, how to lock an entire sheet in Google sheet.

Here are the steps outline on my video.

Protect Specific Cell
1) Data ~ Protect Sheets and Range
OR
a) Right-click on the cell you want to lock
b) View more cell actions
c) Protect range
2) Add a sheet or range
3) Range
4) Select data range icon
5) Select cell(s) to protect
6) Ok
7) Set permissions
8) Done

Protect Cells and Give Editing Permission to Select Users
1) Data ~ Protect Sheets and Range
2) Add a sheet or range
3) Range
4) Select data range icon
5) Select cell(s) to protect
6) Ok
7) Set permissions
8) Custom
9) Done

Protect an Entire Sheet
1) Data ~ Protect Sheets and Range
2) Add a sheet or range
3) Sheet
4) Set permissions
5) Select users
6) Done

Unprotect
1) Data ~ Protect Sheets and Range
2) Select sheet protection rule
3) Click on trash can.
4) Remove


How do I protect cells from editing in Google Sheets?,Why can't I protect cells in Google Sheets?,How do I lock cells in a spreadsheet?,How do I lock cells in Google Sheets formula?,
How to Lock Specific Cells in Google Sheets,How to Lock Cells and Give Editing Permission to Select Users,How to Lock an Entire Sheet in Google Sheet,

Transcript
00:00This is how you can protect your Google worksheet. First, you're going to go to data, protect sheet and range, add a sheet or range here, and then I'm going to select range here and select this range selector and select the cells that you want to protect. Once selected, click OK, set permission. If you have only you, only you can edit this worksheet. If you want to allow other people to get in there, go to custom and then select the user on this list here. If the user is not on this list, enter the email address and that user will be allowed to edit this worksheet.
00:29Once it's done, click on done. And to protect your entire worksheet, go add a sheet or range again. Now this time I'm going to select sheet here and select the sheet that you want to protect. This worksheet number is 228 as you can see here and then set permission and do the same thing as before. I'm going to leave it as default and click on done. Now to get rid of the protection or lock on the worksheet, simply select this and click on the trash can like this and click on remove.

Recommended