Это видео недоступно.
Сожалеем об этом.
How to protect range or sheet in Google Sheets||Lock Cells in Google Sheets||Protect with Password
HTML-код
- Опубликовано: 13 апр 2020
- Join us for Premium Learning Contents - bit.ly/joinsheetomatic 👉Get a ‘Profession Google Workspace Account’ here: bit.ly/referralurl
👉You don't want to make a boring form. And your audience won't answer one. Create a typeform instead-and make everyone happy: bit.ly/3HavWxA
Jotform: Whether you're selling a product, accepting a fee, or collecting a donation, Jotform allows you to get paid directly through your form. Ready to get started?
bit.ly/jotForm
WATI WhatsApp API For Business - Official WhatsApp partner
Send Order Updates, Reminders, Payment updates on WhatsApp using Official Business APIs. Setup WhatsApp Business with WATI & get chatbot, broadcast and third party.: bit.ly/sheetomatic
-------------------------------------------------------------------------------------------------------------------------------------------------------------
Check out my videos on:
👉How to Get a Professional Email:bit.ly/getProfessionEmail
👉How to Send Messages on WhatsApp from Google sheets Automatically: bit.ly/WhatsAppAutomations
👉How prepare FMS:bit.ly/createFms
👉Google Data Studio:bit.ly/Lookerstudio
👉Google AppSheet: bit.ly/appSheetVideos
👉Google Forms: bit.ly/googleFormVideos
👉Google Sheets: bit.ly/googleSheetVideos
👉Google Calendar: bit.ly/CreateCalendar
Subscribe to my all-new channel, Sheetomatic - Admin Support, and learn about Admin Console! :bit.ly/sheetomaticadminsupport
-------------------------------------------------------------------------------------------------------------------------------------------------------------
Useful links:
👉SkillShare: Every student who signs up using your referral link gets 1 free month of Skillshare. : bit.ly/myCourseInSkillShare
👉Udemy: Google Form for Beginners in Hindi bit.ly/MyudemyCourse
------------------------------------------------------------------------------------------------------------------------------------------------------------
For business enquiries
Enquiry Form - bit.ly/SheetomaticEnquiry
Call us - +919329103106 | sheetomatic@gmail.com
Readymade Solution which I offer in Good Price and Better Services.
👉Delegation system WA & Email Integrated
👉Staff Checklist with WA and Email Notifications
👉Purchase order system with auto Pdf Send to Supplier on Email & WA
👉Material Inward ( GRN) system on behalf of Purchase Order
👉Material Outward ( Issuance System)
👉Inventory Management System Master Dashboard
👉Quotation system with auto Pdf Send to Client on Email & WA
👉Proforma Invoice with auto Pdf Send to Client on Email & WA
👉Order Collection system with auto Pdf Send to Client on Email & WA
👉Invoice Making System with auto Pdf Send to Client on Email & WA
👉Dispatch Order System with auto Pdf Send to Client on Email & WA
👉Lead Capture system with Email And WA Notification to Client
👉Sales Lead Funnel with Follow-up Dashboard WA Integrated
-------------------------------------------------------------------------------------------------------------------------------------------------------------
Let’s connect online:
📱 Instagram: / sheetomatic
👨🏻💻 LinkedIn: / shyam-kumar-03051986
😄 Facebook: / sheetomatic
🖋 Ask me on Quora: sheetomatic.qu...
-------------------------------------------------------------------------------------------------------------------------------------------------------------
🙋♂️ Who am I:
I am a quick learner and passionate about the building great products that make business owners lives easier, I have more than 6 Years of Experience in process automation and development in various industries like: Manufacturing, Service, Digital Products, Distributors, Schools, Institutes, CA, Doctors, Insurance Advisers, etc.
I am excited to partner with you!
-------------------------------------------------------------------------------------------------------------------------------------------------------------
►Tags: google sheets,google sheets protect,protect google sheets,lock sheets,lock google sheets,google sheets lock range,google sheets lock column,google sheets lock sheet,google sheets lock sheets,sheets lock sheets,lock sheets in google sheets,google sheet full tutorial in hindi,google sheet,google sheet in hindi,google sheet tips,google sheet formula,learn more,protect sheets,protect cells,google drive,learn google sheets,lock cells,protect range
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
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.
Excellent and very useful to all
Thank you very much
Useful info
nice explain... you're a good teacher. Thank you!
Sir, I am not getting this option. What could be the reason for this?
Very helpful vedeo ...thank u sir
It's not available in normal Google sheet sir i didn't found
Call me 📞 I will help u
This is amazing information. Thanku for sharing your knowledge. I have subscribe your channel and also satisfied your lecture.
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
*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)*
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?
Thank you sir
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.
It is very helpfull
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...
Good sir
After data entry cell automatically lock how can do? please suggest
Good bro
How can we stop viewing once shared to group?
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
thank for sharing
Badiya he Sir
Nice video
can you lock certain row and column that have been edited today, so it cant be edited tomorrow
there is no option of protect sheet showing in our google sheet
Create a new sheet and try it.
Thanks.....Jay mahadev
Sir I want to proctect specific formulas cells in google sheet how I can do it
Mobile mai kaise save karenge file ko...?
Thank man
I m not getting this option in our G-sheet,pl help for how to get it.
is it possible to lock cell after data entered and cannot change again?
Please suggest about above query.
I does not get the option of protect sheet.
Thnx ❤️
THANKU
Row kaise lock kare our data menu pe protect nahi a raha sir
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.
भय्या जिस प्रकार एक्सेल फाइल में पासवर्ड डालने पर दूसरा कोई नहीं खोल सकता उसी प्रकार क्या गूगल शीट में भी पासवर्ड डाल सकते हे
Nahi, not possible
nice
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.
Sir Android Google sheet may option ka hota Hy protect ka ????
Switch for Desktop Version and check
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 password protect certain sheets in Google Sheets?
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
With password kidhr hai... This is only protected the cells how to manually set the password in this sheet
Koi any employee sheet delete na Kr PAYE assa ky kre
If either person A or B make a copy of the document, they can bypass the protection.
Ye option normal google sheet m nhi aa rha
in my system no shown in data menu or right click
If the user has access to the script editor, he can change everything.
Google sheet is not protected and not secure !!!
How to do in mobile
Bhai meri google sheet mai protect range nahi arahi, plz help me
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
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.
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 cancel it?
Isko mobile application pe kaise
Kya me google sheet me copy with protection kar sakta hu
Yes, if you create duplicate file or sheet
How to do filter in protection sheet
how to protect lock cell range in android ? pl guide
हम फॉर्मुला कैसे हाईड कर सकते है? अगर हम गुगलशिट किसिसे शेअर करे तो वो बंदा उस शिटको किसी और के साथ शेअर नही करे उसके लिए हम क्या कर सकते है?
Why there is no protect range on my google sheet
Make sure you the Owner and its a Google Sheet not uploaded Excel
How to hide formula in google sheet?
Abhi option nhi mil rha
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.
mere me protect ka option ny aa raha hai...
In mobile you can not find, try with system
Kindly Tell me how to protect sheets in mobile app....i know how in desktop...
Try Desktop mode in Chrome browser
@@sheetomatic i know, but it should be done in app...in mobile chrome is difficult to handle
@@Neetpgwallah there is no such option available in the App as of now
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
Cell lok exele mobile app
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
@@ajaychakrawarti1473 Great
how to lock Sheets tab
Select Sheet Tab > Right Click> Protect sheet.
HEY KUMAR ......DO NOT WRITE DESCRIPTION IN ENGLISH AND SPEAK OTHER LANGUAGE ... SOME RUclips ETICE PLEASE...
*Register for GOOGLE SHEETS Webinar **forms.gle/Tm3M2apUTwEnsg1e6*
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!
password kaise lagna h sheet par ?