Excel SECURITY | How to Protect Worksheet , Workbook , Lock cells and hide Formula in Excel | Hindi

Поделиться
HTML-код
  • Опубликовано: 20 окт 2020
  • Excel SECURITY | How to Protect Worksheet , Workbook , Lock cells and hide Formula in Excel | Hindi
    1.Protecting a worksheet
    2. Protecting a workbook
    3. Creating a shared workbook
    4. Locking /Unlocking cells in a worksheet
    5. Hiding the formula in a worksheet
    Download the Practice Workbook Direct Link
    drive.google.com/file/d/1EwpE...
    Download the Assignment Master Practice Folder here (All Playlist Example at one place)
    drive.google.com/drive/folder...
    Website - "www.innozant.com"
    Let's Connect:
    Instagram ► / innozantoffi. .
    Facebook ► / innozant
    Twitter ► / innozant
    Linkedin ► / inno. .
    Telegram►@Innozantofficial
    #protectworkbook #excelsecurity#Innozant #hideformula #

Комментарии • 76

  • @heeralalkumawat2132
    @heeralalkumawat2132 Год назад +1

    Bhut aasan btaya

  • @heeralalkumawat2132
    @heeralalkumawat2132 Год назад +1

    Sir ye aaj samjh me aaya hai
    Isse pahle nahi aaya tha

  • @muhammadsaqlain5162
    @muhammadsaqlain5162 2 года назад

    very nice trick sir i love you very much.

  • @pramodbhavsar4488
    @pramodbhavsar4488 3 года назад

    Very nice information security in excel file than you

    • @Innozant
      @Innozant  3 года назад

      Thanks Pramod Ji🙏❤️

  • @nainasharma1589
    @nainasharma1589 2 года назад

    really very informative videos..thanks sir

    • @Innozant
      @Innozant  2 года назад

      Thanks ..Keep learning ❤️

  • @balance1772
    @balance1772 Год назад

    Thank you so much Guru Ji...

  • @sandeepaswal8944
    @sandeepaswal8944 3 года назад +3

    Sir Excellent piece of education, I am truly grateful. सर मुझे हर टाइम आपके वीडियो का वेट रहता है | अभी तक आपके विडोज़ की ही प्रैक्टिस करा था | मै 24 hours मै से 10 hours आपके विडोज़ के लिये टाइम देता हूँ | You have a great ability to articulate.

    • @Innozant
      @Innozant  3 года назад +1

      Omg...Bright future hai aage Aapka..ydi Aise mehnat krenge to..God bless you Sandeep.Wil surely meet one day🙏❤️

    • @sandeepaswal8944
      @sandeepaswal8944 3 года назад

      @@Innozant Sir it will be my pleasure to meet you.

    • @vibhashaditya6292
      @vibhashaditya6292 Год назад

      77

  • @AllahDitta-gp5lt
    @AllahDitta-gp5lt 10 месяцев назад

    عمدہ سر

  • @PawanKumar-lc3du
    @PawanKumar-lc3du 3 года назад

    thanx for this informative video

  • @shahzadsiddiqui5117
    @shahzadsiddiqui5117 Год назад

    best video to solve my problem...! respect

  • @amitfore
    @amitfore 3 года назад +1

    Very Very Much Appreciated. Thanks for this informative video.

    • @Innozant
      @Innozant  3 года назад

      Thanks Raj🙏❤️ For such a lovely comment dear.God bless you .Happy Learning,Share and Support.🙂

  • @sarthakbhagu707
    @sarthakbhagu707 3 года назад

    Very useful sir ji

    • @Innozant
      @Innozant  3 года назад

      Thanks Sarthak dear🙏😊❤️

  • @prasenjitmandal5486
    @prasenjitmandal5486 3 года назад +1

    Absolutely amazing sir

    • @Innozant
      @Innozant  3 года назад

      Thanks Prasenji🙏❤️🙏

  • @TRMNPS
    @TRMNPS 2 года назад

    EXCELLENT. REALLY APRRECIABLE. GOD BLESS YOU.

    • @Innozant
      @Innozant  2 года назад

      Thanks Bindu Ji for your valuable appreciation.. Thanks for being part of Innozant family

  • @AllahDitta-gp5lt
    @AllahDitta-gp5lt 10 месяцев назад

    جزاکم اللّٰہ خیرا کثیرا کثیرا کثیرا

  • @hemantgusain1260
    @hemantgusain1260 3 года назад +1

    Truly valueable knowledge

    • @Innozant
      @Innozant  3 года назад

      Thanks Hemant Ji. Happy Learning dear.🙏❤️

  • @sandeepk2388
    @sandeepk2388 2 года назад

    very nice and much informative Sir..
    Thank you so much Sir

    • @Innozant
      @Innozant  2 года назад

      Thanks Sandeep Ji❤️❤️

  • @Jitenderkumar-yp1rn
    @Jitenderkumar-yp1rn 3 года назад

    Bahut badhiya sir ji.. Good information..😍

    • @Innozant
      @Innozant  3 года назад

      Thanks Jitender ki.Happy Learning 🙂❤️

  • @hanimlovey8516
    @hanimlovey8516 11 месяцев назад

    nice

  • @pramodbhatt6906
    @pramodbhatt6906 2 года назад

    Lovely

    • @Innozant
      @Innozant  2 года назад

      Thanks ❤️❤️

  • @Sasi_patidar
    @Sasi_patidar Год назад

    Sir please review or view tab ke upar ek video banao

  • @satishojha6240
    @satishojha6240 3 года назад

    protection is necessary for any database or life again excellent explanation sir thanku very much 😇😇.good night sir

    • @Innozant
      @Innozant  3 года назад

      Thanks Satish Ji,I really like your dedication..Kuch bhi ho Jaye..you never skip a single video..roj Kuch na Kuch naya seekhke aao tabhi sote hai.
      Practice jaroor karte rehna Apne purane topic ke bhi

  • @tjr1421
    @tjr1421 2 года назад

    Sir formula editing k sath apne jo 2 other topic bataye unki video tutorial kaha per hai?

  • @gauravbhatia7987
    @gauravbhatia7987 3 года назад

    🙏

  • @kalwantsingh4997
    @kalwantsingh4997 3 года назад

    Nice

    • @Innozant
      @Innozant  3 года назад

      Thanks Kulwant ji

  • @naeemulhassan1426
    @naeemulhassan1426 Год назад

    Sir. Please educate about coma, semicolon and colon what does functionality in Ms excel. Regards.

    • @Innozant
      @Innozant  Год назад

      Kindly watch basic excel formula vs function videos for the same

  • @pariharkartik690
    @pariharkartik690 6 месяцев назад

    Sir lakin formatting ke option disable ho jayega. Fir client formatting kse karege.

  • @sumantabhuin7433
    @sumantabhuin7433 11 месяцев назад

    Sir, Table format main formula hide ho sakta hai kya?

  • @surenderyadav1991
    @surenderyadav1991 2 месяца назад

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

  • @RahulChauhan-ll9pu
    @RahulChauhan-ll9pu 3 года назад

    👍🙏

  • @sanjukapur5821
    @sanjukapur5821 2 года назад

    Hi sir my question is how I select end of month in conditional formatting in a large list in number of years

  • @amitkumarvip
    @amitkumarvip 6 месяцев назад

    Lekin unlock krne ke baad automatic lock kese lagaya ja skta h sir ? Wo bhiselected area par

  • @supriyodey3327
    @supriyodey3327 Год назад

    sir protect cell hide kaise kiya Jaye

  • @SanjayKumar-uw9kn
    @SanjayKumar-uw9kn 3 года назад

    Sir apse ek request hai ki please ap ek video MIS EXECUTIVE banne ke process par bana dijiye sir.
    Ki hume kya skills ani chahiye.
    Please sir because mere aas pass koi bhi aise person nahi hai jo mujhe guide kar sake.
    Thanks Sir.

    • @Innozant
      @Innozant  3 года назад

      Already basic excel Playlist me -Why MIS(2nd video) bna chuke Hain ..aap use dekhiye ek Baar..Aur alag se BHI bna deta hu video ek career guide Ka.

  • @virendersroha1754
    @virendersroha1754 3 года назад

    Gd st

  • @kunalsharma2661
    @kunalsharma2661 3 года назад +1

    Sir power BI or dashboard same hote h yaa alg alg hote h ??

    • @Innozant
      @Innozant  3 года назад

      Nahi Sharma Ji.. Dashboard hum excel me khud se bnate Hain using pivot table ,chart etc aur power bi data visualization tool hai

  • @sauravsingh5760
    @sauravsingh5760 2 года назад

    Sir protected worksheet m filter kaise lgaye

    • @Innozant
      @Innozant  2 года назад

      Jab already locked hoga phir filter ?

  • @apremi85
    @apremi85 Год назад

    The cell protection feature is not work when we share the file

  • @vishalgandhi4279
    @vishalgandhi4279 11 месяцев назад

    Sir koi esa bi tarika hai.. jese humare pass 3 sheet hai..sheet1...sheet2..sheet3 or hum bs client ko sheet1 dikhana chahte ho... or jab client sheet2 ya sheet3 par click kre.. to password mange otherwise sheet ka data show hi na ho.... main hide nhi krna chahta..

  • @msexcelgooglesheet374
    @msexcelgooglesheet374 3 года назад

    last option is jabra sir ji, isse kehte hai zaroorat se zada kisi ki sahayta nhi karni chahiye.........😂

    • @Innozant
      @Innozant  3 года назад +1

      Haha..bilkul Sahi..Kareeb Hain lekin lekin...😀🙏❤️

  • @KunalSingh-oy1ny
    @KunalSingh-oy1ny 3 года назад

    Sir how can I create a shared workbook??

    • @Innozant
      @Innozant  3 года назад

      review tab me already option hai to create a shared workbook dear.

  • @Sarita_Classes
    @Sarita_Classes 2 года назад

    Sir ek bar aapse milna chahti hun....it will be a great pleasure for me.....🥰🥰🥰🥰

    • @Innozant
      @Innozant  2 года назад +1

      Milna to Sarita ke upar depend karta hai,Aap jis din mujhe ache profile par switch karke aur JOB offer letter le loge,Usi din milnege hum,ab dekh lo ye mera kaam aap kitne jaldi karte ho❤️😊
      God bless you👍

    • @Sarita_Classes
      @Sarita_Classes 2 года назад

      @@Innozant Sir I am a computer Teacher already....clg students ko padhati hun.... main jab bhi class leti bacho ki ..hamesa aapki hi charcha hoti hai puri class main... personally main bacho ko suggest karata hun... aapaki channel follow karne ke liye❤️❤️❤️❤️

    • @Innozant
      @Innozant  2 года назад

      @@Sarita_Classes Thanks Sarita.Really means a lot to me,.God bless You

  • @puransingh-sx2tk
    @puransingh-sx2tk 3 года назад +1

    Shandar trick isko bolte hai “Saanp bhi mar jaye aur Lathi bhi na Tute” Hahahahhahahahaha 😂👌

    • @Innozant
      @Innozant  3 года назад +1

      Hahah...Kareebi to Hain but😀Acha tha ? 😂🙏❤️

    • @puransingh-sx2tk
      @puransingh-sx2tk 3 года назад

      @@Innozant soon k meri bhi hassi nikal gayi haha 😂

  • @mobilecomputertipsandtrick2662
    @mobilecomputertipsandtrick2662 2 года назад

    Yah password break kiye ja sakte hain aasani se. Zip file banake.