Not exactly. You may want to check out the video about Sheets Manager as it gives you additional capabilities but not exactly what you're asking. th-cam.com/video/Gvznng32u7Q/w-d-xo.html
Thank you for this. But question though, if you download this as excel, the protection and lock disappears. Is there any solutions to that? Or can we disable the download option in files?
Hey, How do I give user wise permission to access certain rows and columns ; so for example, for attendance, If I want to allow User A to input P/A in Row 1 & User A to input P/A in Row W & User 3 to input P/A in Row 3, then how to restrict them by not access their rows and change values.
@@ProlificOaktree Hey Thanks for the link, but my query that I have 5 Employees Names in column A2:A6, and from Column B:Z is where they have to punch in some data in front of their names. Now, How can I restrict every user to not have access or edit others user cell in same sheet. Why I am asking this, because as per your video, If I protect certain cells for User A, then how can I allow same cells for User B in the same sheet. Wish you understand my problem Sir ?
Thanks for the vedio just one quick question how do you hide data from multiple users using google sheets in such a way that they cannot see each others data and setting it in i way only i can see all there data.
Hi Prolific, Thank you so much for this video however, I am not able to view this protect option for my google spreadsheet. Is there any other way to set file protection? Please suggest!
Am I correct in saying that once somebody "makes a copy", all the protection is lost? I'm trying to create sheet to share on the internet with anybody, but I want to protect the formula cells from being overwritten/deleted. Obviously I will need to completely lock editing to only myself, which will force everyone else to make a copy. But that's when all protection is lost. Is there any way to keep the protection? Thanks.
Yes, if someone makes a copy, then they are working with their own file. Therefore, they are the owner and could unprotect anything they wanted. If you want to keep everything protected, then consider sharing it as a link where everyone has viewer access. Then, they can see the file but not make any changes.
@@ProlificOaktree Thanks for confirming my suspicions. The spreadsheet is a calculation sheet, so there are fields that the user needs to enter data, so "view only" won't work.
@@ProlificOaktree i will use that information because i use a form to get information in excel but everytime i submit the form...... it delete the formula that i had use in a cell...
Thank you so much for such a helpful video. May I please ask if it's possible to lock Mark's account out of NY and also block them from seeing what is on the cell?
Hello! I would really like to know how did you manage to hide them as a group? All the blue ones are together and the yellow ones regardless of the order that you open them or hide them again, can you please help me with that?
Hi, Please help to hide sheets for different people. For example, there are 2 groups of people and they have 2 different sheets. Let's say Group1 should not see Group 2 sheet. Is this possible in Googlesheets
I want to stop a few juniors from accessing certain spreadsheets in my google excel file. How can I restrict them from viewing the whole sheet altogether?
Thanks for your videos, but is there any way to hide sheet by each owner? For example, owner sheet 1 can only edit and see sheet 1, cannot see sheet 2, and owner sheet 2 is the same, can only see and edit sheet 2 but cannot see the sheet 1
Help me with one thing please, I want stack some worksheets under one tab ,amd other set of sheets under another tab , so that Every time I click on that particular tab I can choose which of them is to open
I don't know of a control that is that granular. Look into making them and editor, owner, viewer, etc. when you share it. But I don't think you can control what you mentioned specifically.
I have problem with protected view, im protected some cell, andngive permisssion to 1 person But i try it with third account and they still can edit it
Thank you so much for sharing this video. Its really helpful video. But I am looking something else could you please help me in that. I have Google sheet with 9 tabs/sheets and I am going to share it with 10 different people. I want 3 people to edit all 9 sheets but not allow them to share sheet with other people also not allow them to change the settings of sharing, viewing, editing and 4 people to view all 9 sheets but they only edit one sheet which is related to him/her also not allow them to share sheet with other people also not allow them to change the settings of sharing, viewing, editing. With rest 3 people to view the complete google sheet not editing anything and also not allow them to share sheet with other people also not allow them to change the settings of sharing, viewing, editing. Is there any way of doing this? Could you please help me out? If you have already created the video on it please share the link. Many Thanks, Imran
Hmmm. I did one on mobile a few years back. Here it is. th-cam.com/video/LUBbdrEx5sk/w-d-xo.html I would think that it is still pretty relevant. I haven't done text to columns, I'll have to add that to my list. For finding duplicates, how about this one? th-cam.com/video/CrwFQqxzQn8/w-d-xo.html
So even when you hide the sheet, they can still see it if they want too?????????? That defeats the purpose. I don’t want them to see ANY contents of the Hidden tab on the shared sheet EVER. How do you do that??????
@@ProlificOaktree quick question: my Tab names contain the # sign. But when I use the sheet names in a formula, I get a “formula parse error”. Example =(#chart1!A2 + #chart2!A2). How do I fix this? Thanks!!
Hello! Do you have a video where it shows how to group all the sheets under one color? I looked through your videos, but could not find it. Thank you!
Not exactly. You may want to check out the video about Sheets Manager as it gives you additional capabilities but not exactly what you're asking. th-cam.com/video/Gvznng32u7Q/w-d-xo.html
hi, need assistance. i cant fing protection feature on my google sheets. any leads?
Thanks for the video. Is there a way to protect certain cells for myself (owner) so I cannot screw up the formula in the cell accidentally. Thanks
Did you try to just put your own name in when you select who to protect it from?
@@ProlificOaktree Thanks, but this doesn't work as I previously tried!
I don't have Protect Sheet showing when I right click😿
Just hide your formula
Thank you for another very useful video. You always manage to teach me something new.
Alright, mission accomplished. Thanks!
Please Help me Sir
how to protect Specific Cell or Range in multiple Sheets at once?
Thank you for this. But question though, if you download this as excel, the protection and lock disappears. Is there any solutions to that? Or can we disable the download option in files?
I don't know of an option to disable download. That is probably one of the reasons why these are operational considerations, not security.
Sir can u tell me how can i see or check users daily performance in google sheet
i want to allow my users to write to a spreadsheet through my script but prevent them from opening and viewing that sheet. is this possible ?
Hey, How do I give user wise permission to access certain rows and columns ; so for example, for attendance, If I want to allow User A to input P/A in Row 1 & User A to input P/A in Row W & User 3 to input P/A in Row 3, then how to restrict them by not access their rows and change values.
This video explains that th-cam.com/video/QHrF0r02j3s/w-d-xo.html
@@ProlificOaktree Hey Thanks for the link, but my query that I have 5 Employees Names in column A2:A6, and from Column B:Z is where they have to punch in some data in front of their names. Now, How can I restrict every user to not have access or edit others user cell in same sheet. Why I am asking this, because as per your video, If I protect certain cells for User A, then how can I allow same cells for User B in the same sheet.
Wish you understand my problem Sir ?
@@desaitejas Just use the Protect cells range functionality and work through it.
@@ProlificOaktree Hi, I will give it a try and update you.
Thanks for the vedio just one quick question how do you hide data from multiple users using google sheets in such a way that they cannot see each others data and setting it in i way only i can see all there data.
Try this th-cam.com/video/UyBSXgt2_Yg/w-d-xo.html
@@ProlificOaktree thanks👍
Hi Prolific,
Thank you so much for this video however, I am not able to view this protect option for my google spreadsheet. Is there any other way to set file protection? Please suggest!
The "Protect" concepts applies to worksheets or ranges/cells. It does not apply to an entire spreadsheet. Use the Share options for that.
HELP! I cant seem to find the option for protext sheet that is shown at 3:00 time. Mine goes from hide sheet to view comments nothing in between.
I'm guessing that someone shared the document with you so you're not the owner. You have your privileges restricted when you don't own the document.
hi. i am the file’s owner and i am logged in with the google account owner. why do i not see the option “protect file”? thanks
Am I correct in saying that once somebody "makes a copy", all the protection is lost?
I'm trying to create sheet to share on the internet with anybody, but I want to protect the formula cells from being overwritten/deleted.
Obviously I will need to completely lock editing to only myself, which will force everyone else to make a copy.
But that's when all protection is lost. Is there any way to keep the protection?
Thanks.
Yes, if someone makes a copy, then they are working with their own file. Therefore, they are the owner and could unprotect anything they wanted. If you want to keep everything protected, then consider sharing it as a link where everyone has viewer access. Then, they can see the file but not make any changes.
@@ProlificOaktree Thanks for confirming my suspicions.
The spreadsheet is a calculation sheet, so there are fields that the user needs to enter data, so "view only" won't work.
Great video... thank you so much... conyinue with your hard work.... we appreciate it. Great video teacher.
Thank you, glad you liked it!
@@ProlificOaktree i will use that information because i use a form to get information in excel but everytime i submit the form...... it delete the formula that i had use in a cell...
Thank you so much for such a helpful video. May I please ask if it's possible to lock Mark's account out of NY and also block them from seeing what is on the cell?
You can't stop users from seeing cells, just from editing them.
hi. i am the file’s owner and i am logged in with the google account owner. why do i not see the option “protect sheet”? thanks
I don't know!
Hello! I would really like to know how did you manage to hide them as a group? All the blue ones are together and the yellow ones regardless of the order that you open them or hide them again, can you please help me with that?
I work with them in groups by clicking one on the far left or right, holding down the shift key, then clicking one on the other end of the group.
very useful, Thank you very much
Hi, Please help to hide sheets for different people. For example, there are 2 groups of people and they have 2 different sheets. Let's say Group1 should not see Group 2 sheet. Is this possible in Googlesheets
You're probably better off using two different spreadsheets and linking them together with IMPORTSHEET.
I want to stop a few juniors from accessing certain spreadsheets in my google excel file. How can I restrict them from viewing the whole sheet altogether?
I am not aware of a way to stop them from viewing just one sheet.
Thanks for your videos, but is there any way to hide sheet by each owner? For example, owner sheet 1 can only edit and see sheet 1, cannot see sheet 2, and owner sheet 2 is the same, can only see and edit sheet 2 but cannot see the sheet 1
No, you'd have to use separate files.
@@ProlificOaktree Thanks for your reply
how to Creat All Location Sheet?
is it possible to hide a sheet from certain users without giving them access to viewing the sheets in that directory/ table of contents?
hi. Did you find out if this works?
Help me with one thing please,
I want stack some worksheets under one tab ,amd other set of sheets under another tab , so that Every time I click on that particular tab I can choose which of them is to open
I don't think you can do that.
Can I stop people I have added from seeing each others email addresses ? great video
Not unless you just make a shareable link instead of specifically inviting people. th-cam.com/video/CNN967bemQg/w-d-xo.html
How to disable download, print & copy to shared person?
Click on the settings icon in the share window that looks like a gear. You should see these options there.
how to stop users adding new sheets sir, can we disable add sheet link?
I don't know of a control that is that granular. Look into making them and editor, owner, viewer, etc. when you share it. But I don't think you can control what you mentioned specifically.
I have problem with protected view, im protected some cell, andngive permisssion to 1 person
But i try it with third account and they still can edit it
Too hard to troubleshoot without being in your shoes.
@@ProlificOaktree sad 😓
how to hide name of sheet
I don't think you can.
@@ProlificOaktree ok. 😧thanm you
Hi, how to password protect a Google sheets, please?
You don't. It doesn't work like a traditional file in that way. It's protected by who you share it with and who you don't.
Thank you so much for sharing this video. Its really helpful video. But I am looking something else could you please help me in that. I have Google sheet with 9 tabs/sheets and I am going to share it with 10 different people. I want 3 people to edit all 9 sheets but not allow them to share sheet with other people also not allow them to change the settings of sharing, viewing, editing and 4 people to view all 9 sheets but they only edit one sheet which is related to him/her also not allow them to share sheet with other people also not allow them to change the settings of sharing, viewing, editing. With rest 3 people to view the complete google sheet not editing anything and also not allow them to share sheet with other people also not allow them to change the settings of sharing, viewing, editing. Is there any way of doing this? Could you please help me out? If you have already created the video on it please share the link. Many Thanks, Imran
Also, I don't want 10 people to create any type of sharable link.
Not really sure but maybe this would help a bit: th-cam.com/video/CNN967bemQg/w-d-xo.html
all people talk about protect sheets , I dont have any of these options....
You need to be the sheet "owner" to protect sheets. If it is a sheet that is shared with you, this ability can be unavailable.
Plz sir upload a video for google sheet mobile app , google sheet text to colum , and how to know duplicate data in one sheet plz sir 🙏✌
Hmmm. I did one on mobile a few years back. Here it is. th-cam.com/video/LUBbdrEx5sk/w-d-xo.html I would think that it is still pretty relevant. I haven't done text to columns, I'll have to add that to my list. For finding duplicates, how about this one? th-cam.com/video/CrwFQqxzQn8/w-d-xo.html
where is the link
Ooh, I left it off! Thank you for letting me know, I added it back now.
@@ProlificOaktree it says " This site can’t be reached "
That's weird, it works on my end. How about this link, it's the full link.
training.prolificoaktree.com/courses/google-sheets-basics
So even when you hide the sheet, they can still see it if they want too?????????? That defeats the purpose. I don’t want them to see ANY contents of the Hidden tab on the shared sheet EVER. How do you do that??????
Probably best to have a totally separate file.
@@ProlificOaktree quick question: my Tab names contain the # sign. But when I use the sheet names in a formula, I get a “formula parse error”. Example =(#chart1!A2 + #chart2!A2). How do I fix this? Thanks!!
If the user has access to the script editor, he can change everything. Google sheet has no security.