😲 How To IMMEDIATELY Auto Lock Cells After Data Entered in Excel

Поділитися
Вставка
  • Опубліковано 28 жов 2024

КОМЕНТАРІ • 278

  • @amjadmkhan3383
    @amjadmkhan3383 4 роки тому +13

    UA-cam pe bahut se channel hai.lekin aap ki baat hi alag hai.
    Number 1 tutor in youtube.

  • @VisualKreation
    @VisualKreation 3 роки тому

    Jaise Mahasagar me moti bahot dhoondane se milta hai waise hi muze UA-cam ke Mahasagar me Aapka Channel Mila hai...Really Great & Helpful All Videos..TQ

  • @udaynaththakare7547
    @udaynaththakare7547 3 роки тому +1

    दिपक जी,
    मैं आप के वीडियो रोज देखता हूं, आप बहुत ही खूबसूरत ढंगसे समझाते है, आप की सभी वीडियो अच्छे है, पर मुझे जो काम की है,उसे मैं यूज करता हु, बड़ा सुकून मिलता है

  • @santoshkasar4503
    @santoshkasar4503 3 роки тому +2

    Deepak sir you are best Teacher .
    Sir aise hi ek full video Microsoft Access kabhi Banaiye.

  • @avinashverma52
    @avinashverma52 4 роки тому

    Sir, hr video aapka kaam ka hota hai.agar koi seriously kaam krne wala bnda hai to is trh ke video bahut bahut kaam aate hain.mai is video ko pichley 3 years se dhund raha tha.... aapki kae videos ko mila kr mera pura system developed hai jis pr mai roj office ka kaan kerta hun..You are great...love u bro..

    • @MrChamankumar
      @MrChamankumar 4 роки тому

      Bhai kaha use ki ja sakti yeh sheet

    • @avinashverma52
      @avinashverma52 4 роки тому

      @@MrChamankumar kisi badi sheet me jb data entry hoti hai to kisi ek bhi cell ki figure, agr galti se change ho gai to puri calculation accidently change ho jati hai.mere sath aisa kai baar ho chuka hai.Cell lock ho jane se ye problem khtm ho gai hai.dusri baat koi jaan-buzh kr aapko nuksan nahi pahucha payga.

  • @atulshukal4072
    @atulshukal4072 3 роки тому +1

    बहोत बढीया वर्क नया देकर खुशी पाता हे धन्यवाद साहेब

  • @MrVickybang
    @MrVickybang 2 роки тому +1

    Fantastic Trick explained by Deepak ji

  • @SoHaiL_Khan_64
    @SoHaiL_Khan_64 3 роки тому +1

    Amazing outstanding vba code superb video bro keep it up..

  • @heartqueen69
    @heartqueen69 4 роки тому

    Sir aapke sabhi videos bahut hi helpful hote Hain.
    Plz sir aap telegram par group or channel bana lijiye .
    Plzzzzz

  • @Amjadisbest89508
    @Amjadisbest89508 4 роки тому +1

    Deepak bahi g main ne ap ke video jo ke row & column ko color hilight karne ka treqa ap ne batya tha wo sub ok he lekan jub ek cell ke andar type kartee hain to undo nahi hota plase us ka koi karka bateen thanks for you Deepak bahi

  • @aryashsonkar9204
    @aryashsonkar9204 4 роки тому +1

    Thank u Sir🙏🙏 Apke video's bht ache h sir mai apke video's dekh kr hi study krta hu sir back invoice button with old entry kaise bnae sir back invoice button to bna liya pr enrty kaise laye purani jo new invoice button pr click krne se clear ho jati h sir pls bta dijiye

  • @s.n.zeeshan7273
    @s.n.zeeshan7273 3 роки тому +1

    Superb sir thank you so much for making the video .this is very helpful for me you are so great ..

  • @patelsir2918
    @patelsir2918 4 роки тому +2

    Bahut hi achhi hai ye sir ji

  • @goyalmukeshkumar
    @goyalmukeshkumar 4 роки тому

    Bahut saandar trick sikhate ho aap

  • @jaihind_jaisanatan
    @jaihind_jaisanatan 2 роки тому

    Sir ek video is topic par bhi dalo ki kisi particular drop down list lage hue cell me agar me small lattes me bhi agar type kare to cell selection move hote hi vo capital latter me badal jaye

  • @saleemkareem4014
    @saleemkareem4014 Рік тому +1

    Sir so nice of you. please make same action in Google sheet thanks

  • @nadeempakistan50
    @nadeempakistan50 4 роки тому +8

    bro ,pls make video on ,bank reconciliation and as well as trial balances, because these are very popular matters in professional life

  • @chitragaikar5866
    @chitragaikar5866 4 роки тому +1

    Very helpful feature and working great

  • @differentkuber
    @differentkuber 4 роки тому

    Bahut dino aisi video ki mujhe bahut abasyasakta thi thank you deepak sir

  • @JitendraKumar-zm2xo
    @JitendraKumar-zm2xo 4 роки тому

    Hello sir apki sabhi video bahut hi damdar hoti hain sir
    Great sir ap society k lie bahut acha kam kr rhe hain.
    Sir ye jo apne video bnai cell automated lock krne wali isme sir ak bat clear nahi hui apne direct note pad khola vo jo coding thi note pad me vo coding hme khud se type krni padegi ya kahi se source leni hoti hain plz clear kre sir 👌🙏

  • @AZIMUDDINAHMAD-c3y
    @AZIMUDDINAHMAD-c3y 11 місяців тому

    You are nice man. Always your tips are so helpful. God bless you.

  • @narendrasaini6264
    @narendrasaini6264 4 роки тому +1

    Better sir bhut acha

  • @nadeempakistan50
    @nadeempakistan50 4 роки тому +5

    Deepak your are best teacher i had so far, your styles to demonstrate things is best among the others youtubers.

  • @caaman93
    @caaman93 3 роки тому +1

    You alwz Upload Unique Videos.....Thanks

  • @Mr.KundanThakur
    @Mr.KundanThakur 2 роки тому +2

    Sir nice video 👍

  • @damodarbangalore7003
    @damodarbangalore7003 4 роки тому +2

    Sir, It's working fine. Thank you very much...

  • @sudhirgouti5431
    @sudhirgouti5431 4 місяці тому +1

    Pl explain can we lock multiple cell in different parts of worksheet

  • @rajanphadke
    @rajanphadke 4 роки тому +2

    I like your simplicity , sincerity and teaching style. Thanks for updating 🙏

  • @reneehoward-johnson2092
    @reneehoward-johnson2092 3 роки тому +1

    I love this, it was easy to understand and follow, even thou I don't speak Hindi. Thank you so much

  • @mohdshahbazkhan878
    @mohdshahbazkhan878 Рік тому +1

    Hi sir workbook ko kaese protect krein pls make one more video

  • @RahulYadav-cf1yo
    @RahulYadav-cf1yo 3 роки тому +1

    Thanks sir very good

  • @pramodmaurya1049
    @pramodmaurya1049 4 роки тому +1

    Sir very good video sir excel mis pr video banaaiye

  • @PankajKumar-is7zq
    @PankajKumar-is7zq 4 роки тому

    Wow what a tips
    I most like your post
    Please dile aharing ka video post kijiue

  • @umeshbarde5935
    @umeshbarde5935 4 роки тому

    Nice Sir ji Mujhe eski Jarurat thi Thank's

  • @rajadey1552
    @rajadey1552 Рік тому +1

    I am your big fan. I always watch your videos, and I find your videos very useful. Sir, I am making a request to you, if you could make some videos on google sheets and apps sheets, it would be very helpful. I look forward to your videos. Hope you will accept my request and make some videos on this topic soon.

  • @amarcreation6388
    @amarcreation6388 2 роки тому +1

    Bhai Google sheets me same lock kaise dale please make video on that.
    Help please

  • @exceling3820
    @exceling3820 3 роки тому

    দাদা, আমি বাংলাদেশ থেকে বলছি। আমি আপনার প্রতিটি ভিডিও দেখি এবং আপনার খুব ভক্ত। আমি আপনার ভিডিও দেখে অনেক কিছু শিখতে পারছি। আমি একটি বিষয় জানতে চাই তাহলে সেল পয়েন্টারকে যে কোন সেলের ভিতর স্থির করতে রাখতে চাই যাতে নড়া-চড়া না করতে পারে। প্লিজ হেল্প মি

  • @bhaveshparmar431
    @bhaveshparmar431 4 роки тому +1

    Extraordinary

  • @srikanthkasala7850
    @srikanthkasala7850 4 роки тому +1

    Super Explanation Excellent

  • @talksuspense
    @talksuspense 4 роки тому +1

    Nice information

  • @rajubuddy8476
    @rajubuddy8476 4 роки тому +2

    Well I'm learning something new in you're UA-cam channel 👏👏👏

  • @advgovindtiwari8795
    @advgovindtiwari8795 3 роки тому +1

    I think I may not have learned as much as I have learned from you. Big Thanks Bro.

  • @rana1018
    @rana1018 4 роки тому +2

    Very nice sir

    • @diptendupaul3070
      @diptendupaul3070 4 роки тому +1

      mara list sheet 1, gst billing sheet2 no, job mamna drop list lata ok, but billing ma vlookup , drop down nai latA hai, list hota vlookup hota nai. hab solve kar dija.

    • @rana1018
      @rana1018 4 роки тому

      Sir kindly jo billing hai ap ny dkha us pr kch bna dein

  • @heeren.9
    @heeren.9 4 роки тому

    Excellent Sirji

  • @nitinsingh.2107
    @nitinsingh.2107 4 роки тому +1

    Very good Deepak

  • @prakashsirvisetti6714
    @prakashsirvisetti6714 3 роки тому +1

    Thank you brother

  • @Techtoguide
    @Techtoguide 4 роки тому +2

    Super Work Hai bro.... Love you bro..

  • @sashibhusanmuduli6131
    @sashibhusanmuduli6131 2 роки тому

    This is amazing vedio sir....... ❤️

  • @jimmykhan5627
    @jimmykhan5627 4 роки тому +1

    Very very good, #educationadda1

  • @theblessing1719
    @theblessing1719 4 роки тому

    Let's begin the topic, bhai ye aap bahut mast bolte ho,

  • @AmnaIkram-mt4ey
    @AmnaIkram-mt4ey 5 місяців тому +1

    Sir delete restrictions bhi batayie takeh koi delet bhi na Kar saky

  • @pandharinathjoshi6565
    @pandharinathjoshi6565 4 роки тому

    Different trick sir👌👌

  • @jitendrabomble2218
    @jitendrabomble2218 2 роки тому

    Nice.
    Very important information.

  • @EkBaarMuskurao
    @EkBaarMuskurao 3 роки тому +1

    Mind Blowing sir ji

  • @navinmehta8721
    @navinmehta8721 3 роки тому

    very good and simple.

  • @shyamsunderdas3524
    @shyamsunderdas3524 3 роки тому +2

    Sir, very helpful all of your educational videos. If possible please share "full tutorial about table tools formulas in excel"

  • @vijaymumi
    @vijaymumi 4 роки тому +1

    Nice trick sir

  • @BrijeshKumar-qx2bk
    @BrijeshKumar-qx2bk 2 роки тому

    Acha lga lekin vbg coding ki video banaiye basic se

  • @ashoksahu9546
    @ashoksahu9546 4 роки тому +2

    Wahoo. Excellent video.

  • @fardin78672
    @fardin78672 3 роки тому

    You are great sir

  • @gauravmundhra3086
    @gauravmundhra3086 3 роки тому +2

    Aap Google sheet me after entry cell automatically locked ka vedio daale

  • @LiaqatAli-qk8yp
    @LiaqatAli-qk8yp 4 місяці тому +1

    Amazing

  • @barundevdas6917
    @barundevdas6917 4 роки тому

    Your tutorials is praise worthy & very much useful. Thanks alot.
    One thing regarding this video is that when I reopen the work book, auto lock is not functioning any more in the rest blank cells.

  • @KuchhBaatMereSath
    @KuchhBaatMereSath 2 роки тому

    I💕 यू सर आपकी मेहनत को

  • @inderrajchanauria8221
    @inderrajchanauria8221 4 роки тому +3

    very nice I was looking for this since long
    thanks a lot

  • @deepaksaraswat7641
    @deepaksaraswat7641 Місяць тому

    Great work

  • @dilipdeka4462
    @dilipdeka4462 4 роки тому

    Run macro protect sheet.. Plz video banaye please

  • @differentkuber
    @differentkuber 4 роки тому +1

    Video jabarjast hai but sound problem bich bich hui

  • @afzalmalakwal4649
    @afzalmalakwal4649 Рік тому

    Verry nice bro

  • @rajsahu1029
    @rajsahu1029 4 роки тому +1

    Very interesting and useful for some advance work. It may be use also in typing test in excel data

  • @moodkn
    @moodkn Рік тому

    Excellent... Excellent... Thanks

  • @calculatorolo6185
    @calculatorolo6185 4 роки тому +1

    Brilliant sir 👍

  • @radhekrsna007
    @radhekrsna007 4 роки тому +1

    Wow. Too good

  • @sumitkahar5113
    @sumitkahar5113 4 роки тому +3

    Excellent Video... But I want to lock cell after completing last entry of the row... Is it possible??

  • @pakscaffoldinginternationa6604
    @pakscaffoldinginternationa6604 11 місяців тому

    kiya ye hi trics google sheets par bhi apply hojayegi sir kindly inform karde.

  • @sumitsaha3267
    @sumitsaha3267 3 роки тому

    Deepak sir yeh video mera bohot helpfull raha.. lekin sir kiya mujhe bata sakte ho k , mujhe data entry kitna karna hai pata nahi, lekin mai new entry karta chala jau aur cell automatically lock hota chala jaye... Kiya aisa ho sakta hai?

  • @mncreation674
    @mncreation674 6 місяців тому +1

    nice job❤

  • @kousiksamanta8784
    @kousiksamanta8784 3 роки тому

    Aswome trick sir.

  • @hirasva
    @hirasva Рік тому

    VERY USEFUL VIDEO BROTHER, CAB IT BE POSSIBLE IN GOOGLE SHEET?

  • @SA-yy3wd
    @SA-yy3wd 2 роки тому +1

    Thank you

  • @jawadkhan4786
    @jawadkhan4786 4 роки тому +1

    Wow... Creative idea...

  • @upadhyayhindimaster995
    @upadhyayhindimaster995 2 місяці тому

    kya hm if condition ko apply krke value ko lock kr skte hain mtlb if formula kevval ek he baaar execute ho pls btaye

  • @TechKnowGuide
    @TechKnowGuide 4 роки тому +1

    Saved in watchlater...love u....keep posting thxx

  • @SamirKhan-qs8nn
    @SamirKhan-qs8nn 2 роки тому

    Thank you sir.

  • @bbuschy5883
    @bbuschy5883 4 роки тому

    sir you are amzing 😄😄😄😄

  • @mdaslamniit
    @mdaslamniit 4 роки тому

    Amazing trick 👍

  • @JeevikaandMiteesha2806
    @JeevikaandMiteesha2806 Рік тому +1

    Amazing, Hatss Off

  • @mylifeintheuk2093
    @mylifeintheuk2093 4 роки тому +1

    Do you provide any personal help too ?
    Or provide custom made format !!
    Many Thanks

  • @presscvocational
    @presscvocational 10 місяців тому +1

    Excel मे a3, b4, b6, b9, f12 cell auto लॉक करणे के लिये vba code कैसे बना ये
    Merged cell ऑटो लॉक होता है तो plz विडिओ बनाये

  • @PS-si8iz
    @PS-si8iz Рік тому +2

    I want to use this in different parts of same sheet,but this VBA macro doesn't allow me to do it, please help

  • @rakkiyadav1483
    @rakkiyadav1483 2 роки тому

    Amazing explanation. SuperB content.

  • @rupeshsrivastava2765
    @rupeshsrivastava2765 4 роки тому

    deepak ji kya month restrict ho sakta hai ek particular date k bad
    please reply
    your valuable help is always appreciated

  • @baskaranvaradhan2369
    @baskaranvaradhan2369 3 роки тому +1

    Super

  • @ashutoshathavale4448
    @ashutoshathavale4448 4 роки тому

    there should be provision to submit and then whole row will be blocked..if such vba developed then it will be very gr8 ...still this video is also very good

  • @ratanlalregar6632
    @ratanlalregar6632 3 роки тому +1

    Auto lock system google sheet me bhi hota hai kya....??

  • @mayanabachhar9584
    @mayanabachhar9584 3 роки тому

    Excellent sir

  • @vijaybhairavjibhaiode2357
    @vijaybhairavjibhaiode2357 4 роки тому

    Very nice.......

  • @mahendrachauhan2224
    @mahendrachauhan2224 4 роки тому +1

    Awesome sir

  • @bmcreations1
    @bmcreations1 3 роки тому

    Good one. How to enable autofilter in auto. It is not working after locking the cell

  • @balvantkushwah4646
    @balvantkushwah4646 4 роки тому

    Liked your vedio