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

#tip #excel #microsoft #shorts #short #shortvideo #shortsvideo #howto #how #google

свернуть