Lock Cells & Protect Sheet in Excel || Hindi

แชร์
ฝัง
  • เผยแพร่เมื่อ 28 ส.ค. 2024
  • Lock Cells & Protect Sheet in Excel how to use protect sheet & Lock Cell #excel #exceltutorial #msexcel in Hindi - 2007 | 2010 | 2016 | 2013 protect excel workbook with password in Hindi
    how to protect excel sheet with password 2010,
    how to protect excel sheet 2007 with password,
    how to lock excel sheet from viewing,
    make excel read only,
    how to lock an excel file from editing,
    remove password protect excel,
    password protect excel 2016,
    how to lock cells in excel 2013
    how to lock formulas in excel
    how to lock cells in excel 2016
    how to protect a worksheet in excel
    how to lock cells in excel 2007
    how to protect cells in excel 2010 without protecting sheet
    how to lock cells in excel so they don't move when you scroll
    if You are computer user, excel user, ms word user, power point user, sql user, and want to learn computer tips & tricks in hindi, excel tips and tricks, excel secrets, excel shortcut tricks, excel formulas, office work in excel, ms word tips & tricks, power point tips, computer technology ,then must visit our channel deepak eduworld and subscribe.
    ___________________________________________________
    🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳
    𝗣𝗹𝗲𝗮𝘀𝗲 𝗦𝘂𝗽𝗽𝗼𝗿𝘁 𝗠𝗲 𝗙𝗿𝗶𝗲𝗻𝗱𝘀 & 𝗦𝗵𝗼𝘄 𝗬𝗼𝘂𝗿 𝗟𝗼𝘃𝗲 𝗕𝘆 𝗟𝗶𝗸𝗲 𝗦𝗵𝗮𝗿𝗲 & 𝗖𝗼𝗺𝗺𝗲𝗻𝘁𝘀
    🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪
    𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)
    ___________________________________________________
    Hope you will like the video. Thanks For Watching Friends.... Have A Nice
    Day...
    Deepak EduWorld Playlist's:
    ADVANCED EXCEL ►
    goo.gl/A6LdZA
    ADVANCED EXCEL FORMULAS ►
    goo.gl/bbHYu2
    Excel Tips & Tricks ►
    goo.gl/wAj1jh
    Automatic Invoice's in excel ►
    goo.gl/dFhg54
    MS WORD ►
    goo.gl/B4TeSA
    HTML5 & CSS3 ►
    goo.gl/2PFgs8
    COMPUTER Technology videos ►
    goo.gl/paZmpn
    Subscribe Deepak EduWorld ►
    / deepakeduworld
    Follow Me :
    Instagram ► / deepak__nehra
    Facebook ► / deepakeduworld
    LinkedIn ► / deepakedu. .
    FBGroup ► / cse92
    Tags:
    advence excel course, excel in hindi , advanced excel tutorial in hindi, deepak eduworld, deepak nehra, excel tips, excel user, computer user, technology, computer tips, excel course in hindi,

ความคิดเห็น • 70

  • @bhawnadhanuk3005
    @bhawnadhanuk3005 3 ปีที่แล้ว +1

    Very good video sir simple tarike se samjhaya aapne

  • @ramsevakjhariyajhariya2703
    @ramsevakjhariyajhariya2703 3 ปีที่แล้ว

    थैंक्स सर् जो आप बहुत महान सर् जी हों

  • @roshangolay4255
    @roshangolay4255 ปีที่แล้ว +1

    Thanks for sharing Technique

  • @SUJITKUMAR-lw8dm
    @SUJITKUMAR-lw8dm 4 ปีที่แล้ว +2

    Thanks Sir

  • @krishanknhaiya12
    @krishanknhaiya12 10 หลายเดือนก่อน +1

    Wow sir 👍

  • @rajeevchaturvedi4107
    @rajeevchaturvedi4107 4 ปีที่แล้ว +1

    Sir plz video best of five per banaiye this is my Hartley request

  • @kartikmandalia6964
    @kartikmandalia6964 ปีที่แล้ว

    Helped... Thanks

  • @SonuKumar-fm3jn
    @SonuKumar-fm3jn ปีที่แล้ว

    Thaks

  • @sashibhusanmuduli6131
    @sashibhusanmuduli6131 3 ปีที่แล้ว +1

    Thanks bro

  • @chetansinghsolanky822
    @chetansinghsolanky822 ปีที่แล้ว +1

    Very nice

  • @vijaylaxmisharma6318
    @vijaylaxmisharma6318 5 ปีที่แล้ว +1

    Nice video bhaiya

  • @pankajkhutwad6052
    @pankajkhutwad6052 4 ปีที่แล้ว +1

    Thank you

  • @lakhwantsingh308
    @lakhwantsingh308 3 ปีที่แล้ว +1

    Thanku sir

  • @Nishusimplemehdidesign
    @Nishusimplemehdidesign 3 ปีที่แล้ว

    Tq tq tq tq tq tq tq tq tq tq tq tq. Sir ji🤧

  • @kpopocean123
    @kpopocean123 6 ปีที่แล้ว +1

    Thank you sir!!!!

  • @beautifulworld5346
    @beautifulworld5346 7 หลายเดือนก่อน

    Thank u so much

  • @neopanesisters.3129
    @neopanesisters.3129 4 ปีที่แล้ว

    Vry Gud vdo,thanks sir

  • @ImranKhan-eu4gs
    @ImranKhan-eu4gs 3 ปีที่แล้ว +2

    Deepak Bhai, protection sheet table apply ho to kese use karenge?

  • @asimsiddiq475
    @asimsiddiq475 4 ปีที่แล้ว +1

    v. good.

  • @srimantabarik8938
    @srimantabarik8938 3 ปีที่แล้ว +2

    Sir, when we copy any protected cell & past another sheet then all protected cell convert to unlock. Can we do it permanently lock. Plz give me a solution.

  • @jagonathnayak3912
    @jagonathnayak3912 3 ปีที่แล้ว +1

    Depak sir replay.formula lock and cell lock ek sath kasie lagaya. Sir replay.

  • @rajpatel4596
    @rajpatel4596 ปีที่แล้ว +1

    good
    sr password bhul jaye to kya kre

  • @surenderyadav1991
    @surenderyadav1991 3 หลายเดือนก่อน +1

    sir ek Excel sheet me all worksheet pe formula lock and hide karna h. kese kare.
    kyoki har worksheet pe ek ek baar ja ja ke karana pad Raha h

  • @Vijay_Vipra73
    @Vijay_Vipra73 ปีที่แล้ว +1

    all cells (whether locked or unlocked) of my excel worksheet are going protected on cliking protection. can this be resolved?

  • @satnamdhamot5141
    @satnamdhamot5141 3 ปีที่แล้ว

    fine job

  • @muhammedilyasansari7611
    @muhammedilyasansari7611 4 ปีที่แล้ว +1

    Nice video

  • @chaudharysureshbhaik.343
    @chaudharysureshbhaik.343 ปีที่แล้ว +1

    Mobail exel me lok kaise hoga?

  • @kawmalmustafa1537
    @kawmalmustafa1537 3 ปีที่แล้ว +1

    Nice

  • @dooradelhi1073
    @dooradelhi1073 ปีที่แล้ว

    lock hone ke baad bhi data ko copy karke or different sheet pe paste karke use change kiy ja sakta hai. kuchh aisa bataiyye ki poora data hamara safe rahe. protection lagane ke baad data ko koi copy bhi nahi kar paye or usme kuchh bhi change na kar paye.

  • @himanshu641
    @himanshu641 4 ปีที่แล้ว

    Ek qus hai mera apse kya ham 1 google sheet me 4 jagse open kar rah hai or or 4 jan 1 hi. Sheet me kam kar rahe hai to kya hum ais lock kar sake hai kya k 1 wala 2 wale ko much change na kar sake sheet ek hi ya par kam 4 jane kar rahe but woh lock laga sake hai ky a

  • @hanumansahaykhatodiya8543
    @hanumansahaykhatodiya8543 ปีที่แล้ว +1

    Sir only 1 calls ko lock kese kre

  • @naveenkumarsahu3653
    @naveenkumarsahu3653 5 ปีที่แล้ว +1

    thanks

  • @SUDHIRKUMAR-pq2hx
    @SUDHIRKUMAR-pq2hx 3 ปีที่แล้ว

    Hi
    I have a query in excel as below
    Exp....
    I have a Data Sheet on which i have to fill supplier's GSTIN details in a column ...
    GST number has 15 digits as designed by government
    All cells column A are blank yet on which i will fill gst number
    If i fill 14 or less digit in gstin cell then cell prompts and show msg that GST number has 15 digits please fill correctly...what is the condition applied or any background formula or any other solutions...please can you teach me🙏
    Looking for your support
    Thank you so much

  • @kashmirfiberenterprise698
    @kashmirfiberenterprise698 4 ปีที่แล้ว +1

    SIR EK EXCEL FILE KI LINK BHI AAPKE VIDEO ME RAKHE TO BAHETAR HOGA

  • @yehoshuvaandco3842
    @yehoshuvaandco3842 4 ปีที่แล้ว

    Brother can we restrict the workbook to not open in another computers using system mac address

  • @ketandaga
    @ketandaga 3 ปีที่แล้ว

    Sir, I bought office 365 Business Basic but not able to protect and unprotect sheet in excel please guied

  • @rameshujjannanavarcrpneerm2072
    @rameshujjannanavarcrpneerm2072 4 ปีที่แล้ว +1

    How to lock ( without editing)
    header and footer in excell sir??

  • @ShauryaSwarnkar101
    @ShauryaSwarnkar101 4 ปีที่แล้ว

    Excel me formula ko add kaise karae ( formula ke andar ki digit ko add kaise karae)

  • @hasibahmed5248
    @hasibahmed5248 4 ปีที่แล้ว

    good video

  • @dipaleejain5692
    @dipaleejain5692 5 ปีที่แล้ว +1

    Sir row height column width se jhyada kaise

  • @AshwiniKumarExcel
    @AshwiniKumarExcel 3 ปีที่แล้ว

    Sir excel sheet ko google sheet me open hone se rokne ke liye kese protect kare.

  • @dr.atultiwari4954
    @dr.atultiwari4954 3 ปีที่แล้ว

    क्या कोई ऐसा तरीका है जिससे सैळ लाक भी हो जाये और उनमें लिखे फ़ार्मूले भी ना दिखें। मैने कोशिश की थी पर दोनों काम एक साथ नहीं हो पाते। अगर लाक करते हैं तो सैल में लगाये फ़ार्मूले फ़ार्मूला बार में दिखने लगते हैं और अगर फ़ार्मूला बार में फ़ार्मूला को अद्र्ष्य किया जाता है तो सैल एडिटेबल हो जाता है।
    कुछ बतायें।

  • @shankardeo1371
    @shankardeo1371 4 ปีที่แล้ว

    Agar wahi sheet ke protected cell ke bich mein rows insert karke agar wahi formula copy pest karna hai toh kaise karenge insert rows mein bina unprotected sheet kiye

  • @keyurshah679
    @keyurshah679 3 ปีที่แล้ว +1

    Can we have method to automatically "unlock" (for any operation) a otherwise "locked cell" in protected sheet depending on value of another cell ?
    Let's say I have a worksheet in which all the cells are protected in column O.
    My column D has drop down menu to select from @ 58 list.
    What I want to achieve is if someone select from drop-down "subtotal" in any row in column D, respective cell in that row in column O shall be unlocked for subtotal.
    How we can achieve this.
    Looking forward and thanks in advance.

  • @ankushrewale7676
    @ankushrewale7676 4 ปีที่แล้ว +1

    Bhai Mujhe Aise Protect Karna Hai Ki koi copy bhi na Kar Paye only Read Ka option Rehna Chahiye

  • @Akay454
    @Akay454 6 หลายเดือนก่อน +1

  • @gajanankanekar9118
    @gajanankanekar9118 ปีที่แล้ว

    delete row allow kiya hai , magar hota nahi, please check kijiye

  • @swetasinha8185
    @swetasinha8185 4 ปีที่แล้ว

    Device manager ko lock /protect kya ja sakta hai?

  • @viveksardesai5722
    @viveksardesai5722 4 ปีที่แล้ว

    Hello sir.
    Maine ek software banaya he or me us software ko bechnar he agar bech diya to wo cuatomer mera software kisi our ko na beche isliye kya kare

  • @govindtaur4205
    @govindtaur4205 5 ปีที่แล้ว +1

    सर excel में एक शीट में product की लिस्ट ही और हमे दुसरे sheet में product के पहले एक या दो words type किये तो product का नाम आणा चाहिये क्या करे

    • @DeepakEduWorld
      @DeepakEduWorld  5 ปีที่แล้ว

      I ll publish video on this topic shortly

  • @Debasish3863
    @Debasish3863 4 ปีที่แล้ว

    How I can use filter and sort for unlocked columns in protected sheet?

  • @vinitgupta226
    @vinitgupta226 4 ปีที่แล้ว

    Sir isme maine delete columns aur delete rows bhi select kiya tha lekin ye work nhin kar raha hai, ye bata raha hai ki sabse pahle apko sheet unprotect karni hogi,, agar sheet unprotect hi karni padegi toh phir ye options hi kyon diya gaya,, please help me with this. Thank you

  • @PiyushPatel-hl6le
    @PiyushPatel-hl6le 2 ปีที่แล้ว

    How to insert a new row/rows in protected sheet with automatically keeping formulas in new row

  • @archanakiduniya4264
    @archanakiduniya4264 3 ปีที่แล้ว +1

    Main Chahti hu ki formula jo lagaya h usko hide kr de

    • @DeepakEduWorld
      @DeepakEduWorld  3 ปีที่แล้ว

      th-cam.com/video/-WbMLqM-FgI/w-d-xo.html

  • @g.k.sharma6890
    @g.k.sharma6890 3 ปีที่แล้ว

    Deepak ji excel me hum 11 word write krna chahte 12 va write kare to vo write n ho...Jese ifsc code 11 ka hota he to keval 11 digit hi write ho 11 se jyada n ho kese kare

  • @rambilasmandal2471
    @rambilasmandal2471 4 ปีที่แล้ว

    Sir mere excel sheet me lock icon aa ja raha i,, jab hum koi sheet ko protect karte hai to usme ek tala ka icon ban jata hai,,, isko rhik kaise kare plz sir

  • @hanumansahaykhatodiya8543
    @hanumansahaykhatodiya8543 ปีที่แล้ว +1

    Please help me

  • @SanjaySingh-eh2ln
    @SanjaySingh-eh2ln 4 ปีที่แล้ว

    How to disable protected cells warning popup

  • @ankushrewale7676
    @ankushrewale7676 4 ปีที่แล้ว

    Maine Only read Kiya Tya Lekin Copy ya Save As Ho ta Hai Wo Nahi Hona Chahiye Is ke bare me video hai Kya Koi

  • @ajmalshahtravelling7088
    @ajmalshahtravelling7088 6 ปีที่แล้ว

    a

  • @sachinvetal8640
    @sachinvetal8640 3 ปีที่แล้ว +1

    Nice