MS Excel - Protect Sheet

Поделиться
HTML-код
  • Опубликовано: 14 янв 2018
  • MS Excel - Protect Sheet
    Watch More Videos at:
    www.tutorialspoint.com/videot...
    Lecture By: Mr. Pavan Lalwani Tutorials Point India Private Limited

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

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

    To Get Certification, Click Here: bit.ly/38Jyu3p
    Use coupon "RUclips12" to get ‘’FLAT 12%’’ OFF at Checkout.

  • @eashakarmankar5327
    @eashakarmankar5327 Год назад +15

    No unnecessary timewasting intros, nothing extra, just simple, easy to catch and clear content. That's what we need. Amazing Work.

  • @flyingfoxes.
    @flyingfoxes. 4 года назад +21

    College student here in California learning Excel from you. YOU ARE THE BEST ON RUclips!!!! THANK YOU!

  • @tomajuoga6268
    @tomajuoga6268 4 года назад +4

    sir,I just started watching your videos view weeks ago,,I must tell you this,you are the best and I love your explanations,,,Thanks I have really learned much from you.Bravo!!

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

    Thank you for this very simple video to understand excel in better way..

  • @asharsumari9313
    @asharsumari9313 2 года назад +2

    simply made simple to understand.Thank you sir

  • @ictshare1
    @ictshare1 5 лет назад

    YOUR LESSON WAS HELPFULL!!

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

    I learned more in this short video than I did on the hours of trying to get this Information before. Very easy to understand thank you

  • @zinhlekhoza8250
    @zinhlekhoza8250 4 года назад

    What an amazing tutorial !!!

  • @MohitSharma-SKD
    @MohitSharma-SKD 5 лет назад +4

    your teaching skill is too good

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

    Thank for such an important information sir
    A big hands of you

  • @1970murthy
    @1970murthy 5 лет назад +1

    very neat presentation. Good.

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

    To the point - what i needed

  • @adeelahmed-sj2ce
    @adeelahmed-sj2ce 6 месяцев назад

    Nice way to present, very informative and easy to understand

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

    Simplicity of teaching method makes you unique

  • @BimanChGhosh
    @BimanChGhosh 4 года назад +2

    Can I protect sheet with edit rights to multiple person for particular areas of a worksheet?

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

    MASHALLAH you are too good and confident :)

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

    Thank you so much bro for sharing this information.

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

    Good information
    I think it was special for me
    I was need it
    I salute you

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

    Short video but sweet, easy to remember.

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

    good presentation it is helpful thank u

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

    Best way of teaching I ever scene

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

    Cool.. Thank u so much...

  • @anuurajawat2664
    @anuurajawat2664 5 лет назад

    DEAR SIR I LIKE YOUR VIDEO AND VERY VERY THANKS

  • @mallikarjunavamsi9600
    @mallikarjunavamsi9600 5 лет назад

    Nice....Teaching...

  • @maseeshaikh2312
    @maseeshaikh2312 5 лет назад

    Excellent Boss

  • @AmitMandal-ue6gn
    @AmitMandal-ue6gn 3 года назад

    Excellent Dear my friend

  • @baxterismyyoutubename5077
    @baxterismyyoutubename5077 3 месяца назад

    Thank u its useful

  • @vickynri6167
    @vickynri6167 5 лет назад

    Good guideance sir ji 👍

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

    Thank you for this information

  • @entertainment24by78
    @entertainment24by78 4 года назад

    Sir, how can we protect a dynamic table?

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

    Thanks for good information

  • @charlesrodrigues6747
    @charlesrodrigues6747 4 года назад

    very useful thanks

  • @mangleshtiwari103
    @mangleshtiwari103 5 лет назад

    nice presentation

  • @JAVEDKHAN-eg3iv
    @JAVEDKHAN-eg3iv 2 года назад

    Awesome sir 😎

  • @dhanaraj2686
    @dhanaraj2686 5 лет назад

    Protect the sheet option are available in the Google spreadsheet please give your suggestions

  • @divyapreeth1531
    @divyapreeth1531 5 лет назад

    Thank you 😊

  • @simplekitchenwithsana3655
    @simplekitchenwithsana3655 8 месяцев назад

    Excellent

  • @Yadavsindia
    @Yadavsindia 4 года назад

    Thank you very much sir,😊🙏

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

    Sir is there is any way to protect the sheet to share with defined personal only

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

    Thank you very much

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

    Thank you.

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

    quick and easy !

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

    Thank you sir...

  • @saravanana588
    @saravanana588 5 лет назад

    Thanks sir...

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

    Very good video ❤️❤️❤️❤️❤️❤️❤️

  • @zahurulislam269
    @zahurulislam269 4 года назад

    I need excel sheet heading gridline display option inactive protection video

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

    Thanks sir.

  • @gauravdesk
    @gauravdesk 7 месяцев назад

    Thanks 🎉🎉

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

    PLS. I try to protect a sheet which contain a created table with some formulas after I protected it the table can't increase automatically with formula> also when I try to open it with google sheet it give my an error with some formula> I use 2016 Microsoft excel. Thank you for your help

  • @jagadishdas4907
    @jagadishdas4907 4 года назад

    Thank you Sir

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

    It will work in Google sheet also?

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

    Good....

  • @deepaksurendran5463
    @deepaksurendran5463 15 дней назад

    Hi Sir. How to protect a full row if i select "completed" from drop down list.

  • @Village_ki_aspirant
    @Village_ki_aspirant 9 месяцев назад

    Thank you

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

    sir , i have a doubt ? how can i contact you ?
    is there any email id?

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

    Is this touch screen computer how are u using the touch features???😃

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

    Can we copy the Data from protected Excel sheet ??

  • @parmarboyz
    @parmarboyz 5 лет назад +2

    How to enable search in Protected Worksheet.

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

    Thnq very much sir

  • @shuburnachodhuary3368
    @shuburnachodhuary3368 4 года назад

    I have question I have to protect the whole excel sheet but there are some specific cells where some one can entry the data how can I do this. Just to be informed the writer can't insert and any column and row

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

      Right click on specific cell and click format, then go to protection tab and remove check from locked.
      after removing check, protect file again.
      that specific cell is editable now.

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

    Good morning
    Can anyone tell me...if I close 1 excel workbook it's closing All the excels workbook....I want to close separately....I don't want to close all at once.

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

    Thank you😊😊😊😊😊😊😊

  • @maheshrana79
    @maheshrana79 4 года назад +1

    great

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

    I have used marcros for multi selection dropdown..
    After i protect the sheet..
    Multiple select drop down option not working.

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

    Is it possible to protect a file that is shared in g drive

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

    Keep it up

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

    Thank u

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

    thanks sir

  • @muralikrishna.vajjala
    @muralikrishna.vajjala 5 лет назад +3

    Dear sir , I am following your excel tutorials and I found that these are very interesting and your presentation skills are also very good. I feel that it will be very easy to follow you if you could provide the worksheets in the description. Thank you

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

      you all prolly dont give a shit but does any of you know of a trick to get back into an instagram account..?
      I was stupid lost my login password. I love any tricks you can give me

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

      @Dario Thomas instablaster :)

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

      @Colson Landry i really appreciate your reply. I got to the site on google and I'm in the hacking process atm.
      Seems to take quite some time so I will get back to you later with my results.

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

      @Colson Landry It did the trick and I now got access to my account again. I'm so happy:D
      Thank you so much you really help me out!

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

      @Dario Thomas No problem xD

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

    How can we protect all the worksheets in single method in whole workbook?

  • @haqobatil9832
    @haqobatil9832 4 года назад

    sir i want to protect just locked cells via vba button

  • @saikiran-qu4tn
    @saikiran-qu4tn 2 года назад

    Thanks

  • @pramodaksharam
    @pramodaksharam 4 года назад

    THANKS...

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

    how do i protect multiple worksheets at once? (i have over 50)

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

    Nice

  • @MsJocelyn19
    @MsJocelyn19 4 года назад +1

    Hi Sir, how do I protect a specific worksheet from being view?

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

      Hi,
      You can protect a sheet from Review menu. In case you are looking to hide it, then you can just right click on the sheet tab and select hide.
      You can review our channel for more excel learnings.
      ruclips.net/video/gD9fEM9WNfw/видео.html

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

    Can protected sheet be copied?

  • @sahilarora53
    @sahilarora53 4 года назад

    Hello sir.
    I am going to open any excel sheet. It shows it is opening but get out of the excel in Android phone and while opening the excel for the first time, it shows your organization protects the data.. Kindly guide and help sir for opening the same.

  • @AjeeshKFREEDISHDTHTECH
    @AjeeshKFREEDISHDTHTECH 5 лет назад +1

    Sir kindly plz explain how to lock cell

    • @ictshare1
      @ictshare1 5 лет назад

      if you want lock cell you should do that
      1. select on cell who you want to lock
      2. click on the home tab
      3. click on the format
      4. click on lock cell
      ---------------------
      5. click on the review
      6. click on protect sheet
      7. insert your password
      8. ok
      ----------------------
      Result
      - The cell you lock you can write text or number but another cell that not lock you can't write.

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

    Hi thanks for your videos, but these steps are not working in table, when applying these steps excel table then are not extending automatically,,, Please assist. thanks

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

    Sir 2007 doesn’t have option for info?

  • @moniruzzamanshamim9661
    @moniruzzamanshamim9661 4 года назад

    please give me some graphics design tutorial

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

    www thanks brother

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

    Sir how can i unprotect workbook

  • @pavanpro3644
    @pavanpro3644 4 года назад

    How to unlock it

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

    How can I copy and paste if some of cell is protected

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

    How to lock Excel work book before opening it. like in our mobile phone password enter

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

    can we insert password for each sheet like as we are protecting workbook ?

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

      so no one can enter any sheet without writing pass?

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

    I WANT TO PROTECT DATA . BEFORE OPEN THE WORKBOOK PASSWARD ENABLE . hOW I DO THIS

  • @venkatparimi288
    @venkatparimi288 4 года назад +1

    Dear sir
    how to set all worksheets single password is possiable sir

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

      Hi Venkat,
      I have created a video for the same.
      ruclips.net/video/gD9fEM9WNfw/видео.html

  • @jameelrasheed5268
    @jameelrasheed5268 4 года назад

    how to protect sheet 1 sheet 2 sheet 3 in excel in which 3 users and one user use sheet 1 and so on how to lock on sheet 1,2,3 in different passwords ?

  • @khan.hassan
    @khan.hassan 4 года назад +1

    But how can I protect *particular cells* ?
    I mean selected cells not the whole sheet.

    • @ankursharma6157
      @ankursharma6157 4 года назад

      ruclips.net/video/K23LzCiUcNo/видео.html
      Hope, this helps.

  • @deepikaarora4960
    @deepikaarora4960 4 года назад

    Shape or other data sheet work book ko protact krne ke bad bhi sheet me data ya shape insert or dlt ho rhe h

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

    👍

  • @shridhar2763
    @shridhar2763 4 года назад

    Sir
    Can we download external linked file,
    Pls help, i can send you that file which has external links ... I want to download that external link

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

    Wow, too many ways to do one thing.

  • @Elearner6162
    @Elearner6162 7 месяцев назад

    22/12/23

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

    I cant protect the sheet

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

    i can hear durga puja dhol ...haha