Elevate your skills and reach new heights with my cutting-edge course and digital product! 🚀 Don't settle for mediocrity when you can excel beyond your wildest dreams. Click the link below to seize this opportunity now! 💡 sheetomatic.graphy.com/s/store #UnlockYourPotential #SkillBoost #DigitalLearning 🌟
I've shared a spreadsheets with my collaborators giving them permission to edit only some cells in particular sheets, so that each editor can edit only selected cells in his personal sheet, but can view the other sheets. The problem is that although sheets are protected each editor can anyway add new sheets. Is there a way to avoid it. Main problem is I don't want anyone to add any sheet in the shared spreadsheet.
once shared in group can we lock the sheet from viewing ? I mean to say after sharing and giving editing rights can we stop that goggle sheet even viewing by all?
Sir agar humare paas same data hae 10 sheets may and hame protected rabge lagana hae sab par tho single time par un 10 sheets par protected rabge kese lagaen
WHATS APP API SALE !!!! April End SALE! - Enable API Access for Google Sheets and Third Party Software at Just Rs.999/- FREE Template to setup. offer is Valid till 30 April 2022. Hurry up!
Can we restrict other users to not create new sheets...? By clicking on ' + ' symbol they are creating number of sheets like sheet 1 and sheet 2 and so on...
mujhe 1 colum me sirf 4 row ko jab protect karna ho tab kya kare ? time table jab school ka hota hai to bahut se teacher 1 hi colum me hote hai sirf alag alag row hota hai, plz reply
Jab protected sheet me filter laga ke bhej raha huun to wo filter use nahi kar paa raha hai. Ye system se ho raha hai par mobile se nahi ho raha hai. Koi solution hai? Please bataye.
Hey !! How can I use password to my sheet ? - Fully Password protected sheet If anyone wants to access the file it must use password to view the file. No one can even get the read access or view the content of the sheet.
Elevate your skills and reach new heights with my cutting-edge course and digital product! 🚀 Don't settle for mediocrity when you can excel beyond your wildest dreams. Click the link below to seize this opportunity now! 💡 sheetomatic.graphy.com/s/store
#UnlockYourPotential #SkillBoost #DigitalLearning 🌟
You have described in the most simple language. Thanks
nice explain... you're a good teacher. Thank you!
Excellent and very useful to all
Thank you very much
Very helpful sir
This is amazing information. Thanku for sharing your knowledge. I have subscribe your channel and also satisfied your lecture.
Very helpful vedeo ...thank u sir
You explain nice I have learnt a lot from your channel one small request pl share shortcut knowledge also thanks
I have already upload one Video on Shorts. many shorts like Excel doesnt actually work. that's why I dont prefer shortcut in Google Sheets
Useful info
I've shared a spreadsheets with my collaborators giving them permission to edit only some cells in particular sheets, so that each editor can edit only selected cells in his personal sheet, but can view the other sheets. The problem is that although sheets are protected each editor can anyway add new sheets. Is there a way to avoid it. Main problem is I don't want anyone to add any sheet in the shared spreadsheet.
*Register for GOOGLE SHEETS Webinar **forms.gle/Tm3M2apUTwEnsg1e6*
Protect option not show in right click
It is very helpfull
Good bro
Sir is this possible in sheets application
Nice video
Thank you sir
Good sir
once shared in group can we lock the sheet from viewing ?
I mean to say after sharing and giving editing rights can we stop that goggle sheet even viewing by all?
Sir agar humare paas same data hae 10 sheets may and hame protected rabge lagana hae sab par tho single time par un 10 sheets par protected rabge kese lagaen
Badiya he Sir
WHATS APP API SALE !!!! April End SALE! - Enable API Access for Google Sheets and Third Party Software at Just Rs.999/- FREE Template to setup. offer is Valid till 30 April 2022. Hurry up!
thank for sharing
Sir mera ik question h ik video bnaye ap jisme check box me tick lgane p side wale column me date or time aaye. Please ik report tyar krke smjhaye
Sir, I am not getting this option. What could be the reason for this?
*Is it possible to share only one tab of a google sheet with editing permission and not share the whole sheet?) (while staying in the same sheet)*
Can we restrict other users to not create new sheets...? By clicking on ' + ' symbol they are creating number of sheets like sheet 1 and sheet 2 and so on...
Sir I want to proctect specific formulas cells in google sheet how I can do it
After data entry cell automatically lock how can do? please suggest
can you lock certain row and column that have been edited today, so it cant be edited tomorrow
Sir agar humare paas same data hae 10sheetsmay
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
Thnx ❤️
is it possible to lock cell after data entered and cannot change again?
Please suggest about above query.
yes you discover hot water , the problem is that those people that have been blocked from edit they also blocked from using filters or sort option .
Thanks! Filter can be applied please watch my Video on Filter View.
Thanks.....Jay mahadev
nice
It's not available in normal Google sheet sir i didn't found
Call me 📞 I will help u
How can we stop viewing once shared to group?
Sir
Mobile me google sheet me kese cell ko protect krte he.please reply
Use Chrome Browser & go for Desktop View, Protect your Sheets & Ranges
Thanks,ive been trying for a long time
Now i know how to do.
I m not getting this option in our G-sheet,pl help for how to get it.
I does not get the option of protect sheet.
THANKU
Sir Android Google sheet may option ka hota Hy protect ka ????
Switch for Desktop Version and check
Mobile mai kaise save karenge file ko...?
Kya me google sheet me copy with protection kar sakta hu
Yes, if you create duplicate file or sheet
mujhe 1 colum me sirf 4 row ko jab protect karna ho tab kya kare ? time table jab school ka hota hai to bahut se teacher 1 hi colum me hote hai sirf alag alag row hota hai, plz reply
Possible hai with same way.
Koi any employee sheet delete na Kr PAYE assa ky kre
Row kaise lock kare our data menu pe protect nahi a raha sir
in my system no shown in data menu or right click
भय्या जिस प्रकार एक्सेल फाइल में पासवर्ड डालने पर दूसरा कोई नहीं खोल सकता उसी प्रकार क्या गूगल शीट में भी पासवर्ड डाल सकते हे
Nahi, not possible
How to password protect certain sheets in Google Sheets?
there is no option of protect sheet showing in our google sheet
Create a new sheet and try it.
Is there a way to protect a range from copying but write in other cells in the same sheet? I mean can protected range have no copy access?
Not possible without Apps Script
The option of "Protect Sheet and Ranges" is not there in my Sheet, Please help me out!!!
Are you owner of the Sheet?
@@sheetomatic
Yes
Same problem with my sheet
@@kritimehta3835
Create a fresh sheet, it will have. Probably it's a new feature and the old sheet doesn't have this option, the new has.
@@s.madeel4049 Ok thanks...will try
How to do in mobile
Mobile me kaise kare ?
Isko mobile application pe kaise
With password kidhr hai... This is only protected the cells how to manually set the password in this sheet
is it possible to protect your sheet so that multiple users can enter their data but neither they cant not change other's data nor see it?.
Do one thing, Protect the sheet and Hide then share it.
mujhe data me protect ka option hi n show ho rha hai
File ka owner kaun hai kya aapke pass Editing Right hai.
How to do filter in protection sheet
yesa option nahi ha ki jise koi view bhi na kar paye karne se pahle password requir ho
Bhai meri google sheet mai protect range nahi arahi, plz help me
हम फॉर्मुला कैसे हाईड कर सकते है? अगर हम गुगलशिट किसिसे शेअर करे तो वो बंदा उस शिटको किसी और के साथ शेअर नही करे उसके लिए हम क्या कर सकते है?
Ye option normal google sheet m nhi aa rha
How to cancel it?
how to protect lock cell range in android ? pl guide
Sir protect ka options nahi dikh raha h kaha setting kate.
Protect ka option tabhi dikhega agar aap Owner hai ya editor
@@sheetomatic editor h sir phir bhi nahi dikh raha h
Create your own sheet and try to protect, check if its working or not
If either person A or B make a copy of the document, they can bypass the protection.
Jab protected sheet me filter laga ke bhej raha huun to wo filter use nahi kar paa raha hai. Ye system se ho raha hai par mobile se nahi ho raha hai. Koi solution hai? Please bataye.
In Mobile there is no such option available
No such option available for Mobile Interface as of now.
Why there is no protect range on my google sheet
Make sure you the Owner and its a Google Sheet not uploaded Excel
If the user has access to the script editor, he can change everything.
Google sheet is not protected and not secure !!!
HEY KUMAR ......DO NOT WRITE DESCRIPTION IN ENGLISH AND SPEAK OTHER LANGUAGE ... SOME RUclips ETICE PLEASE...
Abhi option nhi mil rha
Hey !! How can I use password to my sheet ? - Fully Password protected sheet
If anyone wants to access the file it must use password to view the file.
No one can even get the read access or view the content of the sheet.
Not possible
How to hide formula in google sheet?
Sir mujhe protect range ka option nahi aa rha sheet me?
Are you owner of the file
If yes, it’s should be else need to connect to your file owner
@@sheetomatic problem solve ho gai sir, excel file upload ki thi, jise google sheet me convert karna pada fir aa gya option
@@Ajay_Chakrawarti9 Great
password kaise lagna h sheet par ?
Cell lok exele mobile app
how to lock Sheets tab
Select Sheet Tab > Right Click> Protect sheet.
Thank man
mere me protect ka option ny aa raha hai...
In mobile you can not find, try with system