This is a very clear explanation. One thing I would recommend insisting -- because it is indeed so different from Excel -- is that you CANNOT TEST your protection, since, as the permitted user you can still edit ALL cells, and you have no warning when the cell is protected or not. That puzzled me for a while. I guess the solution to that is the "show protected cells" in the "view" menu. Now, your presentation was very good because, at one stage, you do mention very quickly that we -- as the permitted user -- can always edit any cells. That's when I got the answer to my headache! Thanks again! :)
Hi, thanks for the information, but there is no "Protect sheet" shows in my google sheet, but do have in my excel, for this suitation, how can I protect my information in google sheet? thank you.
How would you protect a dynamic range of empty cells? For example, I have a spreadsheet linked to a drop off form that auto populates into a queue (the spreadsheet). We currently have an issue with people constantly clicking in empty cells below the data which is getting edited unintentionally, which in turn breaks a lot of the elements we have in our queue. If I can protect those empty cells, in theory we could prevent the above data from becoming corrupted from co-worker neglect.
I had a same problem as you guys, and the way to solve that is super simple. Only one thing you need to is file>save as a google sheet. And you can see protect range in your data section.
Thank you for the video! I follow you a lot...I protected the entire sheet but with the exception of some cells. This sheet is shared as a "template" in the organization and they open it from the published "templates". But when it is opened, it does not respect the protection and all the cells can be edited. How can I limit it?
This - like all of your videos - is great and insightful! My only concern is how to restrict editors from being able to duplicate the worksheet/tab as this creates an "unprotected" copy within the same sheet. Not sure if anyone has a solution. Any ideas would be appreciated. 🙏
Thanks a lot. May I protect same cell range in multiple sheet at a time. eg. A1:F2 from sheet 1 and A1:F2 from sheet 2 ..... and many more sheet? Pls suggest
Great video lesson. I am wondering if there is a way to implement this cell range restrictions to specific email accounts in MS Excel. I am thinking Allow Edit Range is similar to this one but I am not sure how to implement giving access to cell ranges based on user's MS account. Thanks.
Hello and thanks for the video. I have a question. Shall this work if someone makes a copy of the spreadsheet? And next, is it possible to prevent changing sheet's name even if it's copy of the original? I ask cause currently I'm making one big sheet that works as a calculator for a game and I'm planing of public sharing it when it's done. :)
What if I want to allow access to only 1 specific user to 1 specific range inside a specific sheet in a worksheet? At the moment if I'm trying to do that, I get all users to have access to that specific range in the specific sheet...that's a problem
I've found some challenges with email addresses as the primary access token. Is there any way to use a password for the entire sheet? I heard there was a separate ProtectedSheet but that seems to be for Excel.
How to copy the edit restrictions to multiple sheets? Rather when I duplicate the sheet, the restrictions that I set for the original are all gone. Could somebody please suggest? Thanks
I know, it is a bit of time since the video was uploaded. But got the question from a friend, and when looking around, I found this video. But it is more a unique case. Because if you in a cell add a check-box, that can either be marked or unmarked. If you use this to lock it, would it then keep others from being able to mark it or does it only keep them from not being able to remove the check-box. Because the purpose would be to protect it, so people can't alter text and remove the check-boxes, but they should be able to mark the boxes. Is there a way to do that, or is it either locked or unlocked???
Suppose I have three sheet in one google spreadsheet. Now I want to set A20 field protect in Sheet1. but how that will be working in sheet2, sheet3 also?
I'm putting a Workbook together using only cell functions, the script stuff is a little out of my league. The Workbook is intended to make and record estimates, invoices, and receipts. I also have a "Records" tab where I am trying to record/log a list of information from the the documents I create (Name, Tax Amounts, Dates, Totals, ect). In this tab are rows of cells pulling and reflecting data from a "Master" invoice making tab I've built to make these documents. My question is; Can I (Lock?) or (Stamp?) these row ranges in my Records tab? The problem I'm running into is when I clear the data from my "Master" invoice making tab, I lose the information on my "Records" log tab. I was hoping to "Protect" these ranges but it won't let me define as a "Range Name" or "Protect(ed) Range" (I'm not even sure this is what I want to do). I think it has something to do with these cells in the "Records" tab pulling from the "Master" invoice tab? Thank you in advance & for all the great videos!
I have tried this on several sheets but the problem I have is when I "Share" it with someone, they are asked to request access permission before they can access the sheet. I can't find a way around this so i can't test the protection of the cells in my sheet before I send it to a customer. (I am trying to use it as an order page for our products)
The exception doesn't work in all cases. I'm doing the same thing as the author of the video, but even if I set protection for the certain sheet with an exception for a certain cell/range, no one else can edit those cells/ranges that should have had an exception set. I was trying to figure out what's the issue and why it doesn't work for me. The issue is, once I set "data verification" for a cell, that cell is automatically inaccessible to any other user (except for users that have edit rights). I wasn't able to figure out why it's not possible or how to go around it. It would be really helpful if this issue would be mentioned in the video. Google doesn't mention this anywhere as well (not even in responses to users trying to get help with this).
Help me please, How to enable editing and disable deleting at the same time .. like allow choosing from dropdown list but disallow deleting any choices ?
Hi, thank you very much for the Google Sheet series. Would you be able to make a video on bumping down an entry on Google Sheet if there isn't one? Thank you!
There is a issue... say i am the owner and i want to set data validation rule which i can only change but other editor cannot change they only can input the data into it. is ther is any option in google sheet
Sir i havw a question : i want create a excel Google Sheet. Under many sheets of different stores in one book but i want give rights every store to edit & see their own sheet only not others. Please help
Possible to set different password for a drop down menu for each individual data? I’m trying to set a homework tracker for my students and only can be viewed by parents with a password for their child.
Thank you very much for the class. Your teachings are very helpful. Is there a way to protect Cell, Column or Row from editing after Data entry? Please Help Us
Thank you for this useful information. How can I allow different ranges to different gmail ids for editing, for example I want to allow almost 100 different people to edit a google sheet, to a range where their e mail ids are filled, they can edit only. Example A1 has e mail id of James and I want to allow James to edit B1 to G1, Similarly A2 has e mail id of Tom and I want to allow Tom to edit B2 to G2.
If I have multiple users and I want to know who made changes on a certain range, is there a way to put the name of the user in a cell? I don’t wanna use history. I want to use a way that can show me a report of users who made changes.
Has anyone found a way to allow other users to edit the cells but not change the formats (font size, wrapping options, alignment settings etc)? It seems that whenever someone copy/pastes it will change all these settings.
I want a sheet protected from other users accessing it, except one, like a dedicated sheet for the user But at the same time, I want that specific user from only edit a specific field. This has not solved my issue.
Thank you for this insightful video. Is it possible to set a time at which a sheet can lock out certain users who have been given permission to the sheet? For instance, users should not be able to make entries/edits on the sheet after 6pm. Is this possible?
How about protected object ? I created an object that could run some script, It's fine if I'm the one who trying to run it, but when I use other email, it won't work and telling that this object is protected. Could you help me? I couldn't find any information regarding protected object, Thank you so much
can we protect (lock) sheet that contain importrange data (but still automatically update the data when the source data updated) ? thank you for the Lesson (I'm sorry for my English)
Please some buddy help me i want to make one formula i have 1 digit if it is less than 1.5 it is considered as 1 if it is greater than 1.5 considered as 2 what formulas should I use?
Good morning sir, I just want to restrict color range in google sheet, so that no one will be able to change colour of sheet, only owner can change color of sheet. Is it possible? If yes kindly guide me.
This is a very clear explanation. One thing I would recommend insisting -- because it is indeed so different from Excel -- is that you CANNOT TEST your protection, since, as the permitted user you can still edit ALL cells, and you have no warning when the cell is protected or not. That puzzled me for a while. I guess the solution to that is the "show protected cells" in the "view" menu.
Now, your presentation was very good because, at one stage, you do mention very quickly that we -- as the permitted user -- can always edit any cells. That's when I got the answer to my headache! Thanks again! :)
Hi, thanks for the information, but there is no "Protect sheet" shows in my google sheet, but do have in my excel, for this suitation, how can I protect my information in google sheet? thank you.
but actually, I can't find protect sheet wording! would you suggest?
You're the BEST! every tutorial is well explained with no boring explanations, thank you !
Indeed this has given me great insight on worksheet protection
But if you download the sheet as an excel sheet would it be possible to edit this?
How would you protect a dynamic range of empty cells? For example, I have a spreadsheet linked to a drop off form that auto populates into a queue (the spreadsheet). We currently have an issue with people constantly clicking in empty cells below the data which is getting edited unintentionally, which in turn breaks a lot of the elements we have in our queue. If I can protect those empty cells, in theory we could prevent the above data from becoming corrupted from co-worker neglect.
Thanks very much sir. I have been confuse how to protect cells from being edited or change. You show it clearly and doing it are so simple.
Hey, Thank you for your tutorial that was easy to follow. You have saved me a headache looking for answer in the google sheet.
Hi, I can't see the option "protect Sheet" on right click on a particular worksheet to protect that worksheet
me too
I don't see that option either when I right click. How do I change that?
I had a same problem as you guys, and the way to solve that is super simple.
Only one thing you need to is file>save as a google sheet. And you can see protect range in your data section.
@@munguunue4556 thank you so much!
Same here
Thanks. Just what I needed to know. Clear and concise.
Me here agaaaain!! lol!! Thank you Sir I appreciate your effort on doing those videos!!
Is it possible to share a sheets document with specific cell permissions but also disallow the other user from creating new blank tabs/sheets?
i tried to follow what you did but there is no protect range option when i right click, is this feature removed?
what if I want protect myself from changing it? would that be possible?
Thank you for the video! I follow you a lot...I protected the entire sheet but with the exception of some cells. This sheet is shared as a "template" in the organization and they open it from the published "templates". But when it is opened, it does not respect the protection and all the cells can be edited. How can I limit it?
This - like all of your videos - is great and insightful! My only concern is how to restrict editors from being able to duplicate the worksheet/tab as this creates an "unprotected" copy within the same sheet.
Not sure if anyone has a solution. Any ideas would be appreciated. 🙏
Thanks a lot. May I protect same cell range in multiple sheet at a time. eg. A1:F2 from sheet 1 and A1:F2 from sheet 2 ..... and many more sheet? Pls suggest
Great video lesson. I am wondering if there is a way to implement this cell range restrictions to specific email accounts in MS Excel. I am thinking Allow Edit Range is similar to this one but I am not sure how to implement giving access to cell ranges based on user's MS account. Thanks.
Hello and thanks for the video. I have a question. Shall this work if someone makes a copy of the spreadsheet? And next, is it possible to prevent changing sheet's name even if it's copy of the original? I ask cause currently I'm making one big sheet that works as a calculator for a game and I'm planing of public sharing it when it's done. :)
Hi! Have you found a way to solve the problem you mentioned? Cause I have the same issue
What if I want to allow access to only 1 specific user to 1 specific range inside a specific sheet in a worksheet?
At the moment if I'm trying to do that, I get all users to have access to that specific range in the specific sheet...that's a problem
I've found some challenges with email addresses as the primary access token. Is there any way to use a password for the entire sheet? I heard there was a separate ProtectedSheet but that seems to be for Excel.
I don't see that protect feature in the tablet app. Is it not available? How about in Chromebook version?
the cell that is protected is there a way to skip that cell to the cell that can be modified instead of doing that tabbing the cell to be modiefie.
How to copy the edit restrictions to multiple sheets? Rather when I duplicate the sheet, the restrictions that I set for the original are all gone. Could somebody please suggest? Thanks
I know, it is a bit of time since the video was uploaded. But got the question from a friend, and when looking around, I found this video. But it is more a unique case. Because if you in a cell add a check-box, that can either be marked or unmarked. If you use this to lock it, would it then keep others from being able to mark it or does it only keep them from not being able to remove the check-box.
Because the purpose would be to protect it, so people can't alter text and remove the check-boxes, but they should be able to mark the boxes. Is there a way to do that, or is it either locked or unlocked???
Suppose I have three sheet in one google spreadsheet. Now I want to set A20 field protect in Sheet1. but how that will be working in sheet2, sheet3 also?
Could you do this on a template and make it active on opening
is there a way to be able to allow insert rows is a column is protected from editing?
You saved my job bro...😁
I'm putting a Workbook together using only cell functions, the script stuff is a little out of my league. The Workbook is intended to make and record estimates, invoices, and receipts. I also have a "Records" tab where I am trying to record/log a list of information from the the documents I create (Name, Tax Amounts, Dates, Totals, ect). In this tab are rows of cells pulling and reflecting data from a "Master" invoice making tab I've built to make these documents.
My question is; Can I (Lock?) or (Stamp?) these row ranges in my Records tab? The problem I'm running into is when I clear the data from my "Master" invoice making tab, I lose the information on my "Records" log tab. I was hoping to "Protect" these ranges but it won't let me define as a "Range Name" or "Protect(ed) Range" (I'm not even sure this is what I want to do). I think it has something to do with these cells in the "Records" tab pulling from the "Master" invoice tab?
Thank you in advance & for all the great videos!
very helpful video sir... thanks
Teacher...I wish there was a way to Protect the Formatting/Layout of Cells from actions such as Cut & Paste...even from myself (Editor)!!!
Thank you very much, well explained. Request to make videos on google app script explained for Protection class?
Nicely explained!!
I have tried this on several sheets but the problem I have is when I "Share" it with someone, they are asked to request access permission before they can access the sheet. I can't find a way around this so i can't test the protection of the cells in my sheet before I send it to a customer. (I am trying to use it as an order page for our products)
I want to create protected cells including myself. How to do it using appscript.
The exception doesn't work in all cases. I'm doing the same thing as the author of the video, but even if I set protection for the certain sheet with an exception for a certain cell/range, no one else can edit those cells/ranges that should have had an exception set. I was trying to figure out what's the issue and why it doesn't work for me. The issue is, once I set "data verification" for a cell, that cell is automatically inaccessible to any other user (except for users that have edit rights).
I wasn't able to figure out why it's not possible or how to go around it.
It would be really helpful if this issue would be mentioned in the video. Google doesn't mention this anywhere as well (not even in responses to users trying to get help with this).
Did you find help to this, if yes you can kindly share because rights to edit give access to the entire sheet but not cells with edits permission
Please make a video tutorial on how did you make your sheet look like that please please please. thank you!
Thanks for How to product the same sheet but multiple user control in same sheet
exm, A column only edit Mr. A B column only edit Mr. B how to do this
Help me please,
How to enable editing and disable deleting at the same time .. like allow choosing from dropdown list but disallow deleting any choices ?
Hi, thank you very much for the Google Sheet series. Would you be able to make a video on bumping down an entry on Google Sheet if there isn't one? Thank you!
Useful information
Can we refrain the allowed person from using or entering a formula to get the answer easily, like for example there are data that need to be added
Hi thank you
This is possible to mobile application
I can't find this facility.
I only want to protect the data validation but want to allow entry of values?? Any suggestion..
I was in great need of it. Thanks a lot.
Wonderful tutorial
Very informative presentation
Can you protect a ’workbook’ such that when I hide a sheet others can’t unite it?
Good one
There is a issue... say i am the owner and i want to set data validation rule which i can only change but other editor cannot change they only can input the data into it. is ther is any option in google sheet
Sir i havw a question : i want create a excel Google Sheet. Under many sheets of different stores in one book but i want give rights every store to edit & see their own sheet only not others. Please help
Great video! Thank You a lot!
i just wonder how can i for a certain user lock ranges for editing and still let him use filters and group/ungroup rows/columns......
Possible to set different password for a drop down menu for each individual data? I’m trying to set a homework tracker for my students and only can be viewed by parents with a password for their child.
Thanks for another great video ❤️
how can we protect the charts in google sheets from being edit?
Sir... Great video... Sir tel me... How passed date cell automatically lock... Please share this type of video 🙏🏿
Watching thanks in advance
Thank's Sir, I got something new here. That's "Except certain cells" is very cools :)
how do we create such google sheet ie a1 to h7 and rest other areas in sheet are not usable for entry/edit
please help
Extremely useful! Well explained
Thank you very much for the class. Your teachings are very helpful. Is there a way to protect Cell, Column or Row from editing after Data entry?
Please Help Us
Cool Video - How May I Protect the Chart generated from the Data. Thanks. Hope to hear from you soon!
Before this i was always accidentally changing something i shouldnt in my accounts, but now with your help i will be warned first atleast, thank you
Why after I highland the cell and right click, the Protect Range is not show on the list for the option?
This is to prevent people from editing. what about copying? will they be able to copy?
How to protect checkbox/dropdown-list cells but still have them be toggle-able while sharing to anonymous?
Thank you for this useful information. How can I allow different ranges to different gmail ids for editing, for example I want to allow almost 100 different people to edit a google sheet, to a range where their e mail ids are filled, they can edit only. Example A1 has e mail id of James and I want to allow James to edit B1 to G1, Similarly A2 has e mail id of Tom and I want to allow Tom to edit B2 to G2.
Hi, same problem here, have you already find the solution?
If I have multiple users and I want to know who made changes on a certain range, is there a way to put the name of the user in a cell? I don’t wanna use history. I want to use a way that can show me a report of users who made changes.
Yes. Use installable onEdit trigger.
Learn Google Spreadsheets Thank you for your reply. Any video around there explains that. Highly appreciated 🌹.
Hi, how we can _create a sheet inside a spacial folder_ using *Google Apps Script?*
Extremely useful, thank you for the videos you make!
Why the sheet became unprotected once I share it to another person when "make a copy"? Is there anyway to overcome this?
Why my googlesheet did not have that protect range button?
How to protect the cells if the sheet is shared to public
But if they download it, the protection will be remove
Has anyone found a way to allow other users to edit the cells but not change the formats (font size, wrapping options, alignment settings etc)? It seems that whenever someone copy/pastes it will change all these settings.
I want a sheet protected from other users accessing it, except one, like a dedicated sheet for the user
But at the same time, I want that specific user from only edit a specific field.
This has not solved my issue.
Thank you Very much. Very usefull for new learners.👃👃👃👌👌👌
Glad to hear
Thank you for this insightful video. Is it possible to set a time at which a sheet can lock out certain users who have been given permission to the sheet? For instance, users should not be able to make entries/edits on the sheet after 6pm. Is this possible?
You can create a script with timed trigger to run every day and protect/unprotected at certain times.
How about protected object ?
I created an object that could run some script, It's fine if I'm the one who trying to run it, but when I use other email, it won't work and telling that this object is protected.
Could you help me? I couldn't find any information regarding protected object,
Thank you so much
Great video!
Very helpful, thank you .
This past few days, I am having trouble with protected ranges. From can edit, they became can view only.
what to do if protect range tab is not there ?
Very nicely presented 👌 very useful
can we protect (lock) sheet that contain importrange data (but still automatically update the data when the source data updated) ? thank you for the Lesson (I'm sorry for my English)
Why, it doesn't update after you protect?
Please some buddy help me i want to make one formula i have 1 digit if it is less than 1.5 it is considered as 1 if it is greater than 1.5 considered as 2 what formulas should I use?
How to do in google sheet lock in phone ap
Thank You so much for this video👍🙏
Can this be shared to non-Google email accounts for editing with protection to most of the document?
It doesn't have to be a Google email account, but it has to be a google account.
How do I reverse this? The whole sheet is protected but I want to unprotect certain cells.
Good morning sir, I just want to restrict color range in google sheet, so that no one will be able to change colour of sheet, only owner can change color of sheet. Is it possible? If yes kindly guide me.
sir pls rep
Thanks for this
hi, need assistance. i cant fing protection feature on my google sheets. any leads?
Make sure it's not an Excel file and you're the owner.
thank you for this video. it helps a lot.
Glad it helped!
How can I give authority to the editor to hide/unhide the locked sheet?
Thank you for making this video 😃
Appreciated bro