How To Lock Individual Cells and Protect Sheets In Excel

Поділитися
Вставка
  • Опубліковано 26 сер 2024
  • This excel video tutorial explains how to lock individual cells and protect worksheets with a password.
    Excel Tutorial For Beginners: • Excel Tutorial For Beg...
    Top 30 Excel Tips & Shortcuts:
    • Top 30 Excel 2016 Tips...
    ________________________________________
    How To Look Up Customer Data In Excel:
    • VLookUp - How To Extra...
    Excel Vlookup Function:
    • How To Use The VlookUp...
    How To Create a Data Entry Form In Excel:
    • How To Create a Data E...
    Multiple Dependent Drop Down Lists:
    • How To Create Multiple...
    How To Show & Hide Formulas:
    • How To Show and Hide F...
    ______________________________________
    Relative & Absolute Cell References:
    • How To Use Relative & ...
    Lock Cells and Protect Sheets In Excel:
    • How To Lock Individual...
    Excel Interactive Checklist:
    • Interactive Checklist ...
    Excel Pivot Tables:
    • Intro to Pivot Tables,...
    ______________________________________
    UA-cam Channel Growth Accelerator:
    / youtubechannelgrowthac...
    Algebra For Beginners:
    www.video-tuto...
    Final Exams and Video Playlists:
    www.video-tuto...
    Full-Length Math & Science Videos:
    / collections

КОМЕНТАРІ • 192

  • @TheOrganicChemistryTutor
    @TheOrganicChemistryTutor  8 місяців тому

    Final Exams and Video Playlists: www.video-tutor.net/
    Full-Length Videos & Worksheets: www.patreon.com/MathScienceTutor/collections

  • @zipperbook501
    @zipperbook501 2 дні тому +1

    The steps in this tutorial are very easy to understand. I was able to mimic the same steps with a spreadsheet form I created for work. I was able to protect certain cells that seemed to be overwritten by multiple people when they would enter their customer project data. This "safety protection" method is a life-saver / time-saver. Thanks for the video. 👍

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

    BRUH ... WHERE THE F WERE YOU ALL THIS TIME, I NEEDED THIS SO BADDLY

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

    These were the BEST instructions! I tried going to several websites, but they used FAR too many words to do a simple task. I really appreciate your style.

  • @flower-butter3920
    @flower-butter3920 Рік тому +17

    bro you could've had the numbers already ready before the start of the video so you can get to the point. 🙃

  • @eliseofernandojr7575
    @eliseofernandojr7575 4 роки тому +39

    Topic for this lesson starts at 3:18. You're welcome.

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

    That's all I wanted. Thsnks

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

    I've been trying to figure this out for months. This is exactly what I needed. Thank you.

  • @yusufit7627
    @yusufit7627 2 роки тому +2

    I was thinking that I've heard this voice, watched the channel name, boom this is the everything teacher 😄👏🏻. Keep it up

  • @nicolesimpson7826
    @nicolesimpson7826 Рік тому +5

    This was fantastic! It works and you are an excellent instructor, nice, good examples and simple to follow. Thanks again

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

    I spent an hour trying to figure it out myself and then finally stumbled upon this video. Job done in seconds .. thank you very much

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

    Thank you for the knowledge.

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

    Exactly what I needed! Thank you for not wasting my time!!!!

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

    thank you so much it was really helpful to me

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

    Thank u very much it is very useful and easy to understand

  • @user-wf6qu1pt8k
    @user-wf6qu1pt8k Рік тому

    one of the simplest way to explain .. works perfect ....thx

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

    Thank you for sharing very clear

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

    Excellent vedio.it is need to learning us.and found the degital Bangladesh.

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

    This is best way to explain.. Unlike the other videos where you get more confused.

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

    Thanks. Very helpful.

  • @711Arigna
    @711Arigna 3 роки тому

    Thanks for great information.

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

    Thank you for the helping video

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

    Educative ... thanks very much

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

    Just came to remember how to unlock cells when protecting sheet. Showed it near the start. Quick, concice and informative. Hope you are still uploading Excel contant because it is very desirable and hard to find well spoken concice videos.

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

    you do a great job, TOCT... The organic Chemistry Tutor - this refreshed my memory.

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

    Thank you for the information

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

    You have explained it in such a simple manner....I tried many videos earlier....I could never get it. Thank you

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

    Thanks a lot ....solve my problem.

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

    THANK YOU!

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

    Thanks for the information

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

    Thank you so much!!

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

    Thank you for sharing your knowledge. Your Calculus Videos are awesome.

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

    Fantastic job explaining it quick and easily

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

    Thanks! This worked perfectly for what I was trying to do.

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

    Great turtorial . Thank you!

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

    Thanx easy and clear

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

    The best tutorial sir. Thanks!!

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

    Very clear and concise. Great video. I will subscribe . Thank you

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

    Thank you!!

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

    Thank you this was very helpful.

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

    Thank you. I was looking for this option.

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

    Thanks man. I've been looking for this

  • @RaysDrawingArt
    @RaysDrawingArt 3 роки тому +3

    Very clear and simple explanation! Thank you this is what I have been looking for

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

    After watching and learning...I feel like a genius now! LoL Thank you!

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

    Thank you sir.

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

    THANK YOU SIR

  • @evaristosigauque9964
    @evaristosigauque9964 3 роки тому +3

    Thanks for the lesson. Simple and straight to the point.

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

    This is a nice video I always come back to it

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

    Thank you for this tutorial!!!! LIFE SAVER!!!

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

    I Like it. Very Clear. Very Helpful

  • @remindfullness
    @remindfullness 4 роки тому +6

    Awesome, this is just what I needed! Thank you!

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

    Thanks bro!!

  • @mlcalderaro
    @mlcalderaro 5 років тому +1

    great work, thanks...very illuminating for beginners

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

    Thanks a lot. You made it so easy to understand. God Bless YOU :)

  • @MD-cu8tt
    @MD-cu8tt 2 роки тому

    Thank you , to the point without bla bla bla

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

    Great stuff! thank you

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

    Tqqqqq so helpful tqqqq again

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

    Great video! Thank you so much for your help !

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

    waw!!! thank you so very much

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

    Do you have a video on hiding and unhiding tabs/sheets with a password?

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

    thank you so much...

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

    Very well explained. Thanks.

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

    Thank you

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

    great explanation...you got my like

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

    This is amazing video in excells work relative.

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

    thank you

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

    Thank you! Very clear and concise!

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

    This is very helpful. Thank you

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

    So helpful. Thank you so much

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

    Thanks for sharing, I just need it today

  • @courtneydebian
    @courtneydebian 5 років тому +1

    Great Explanation!

  • @javedahmed8343
    @javedahmed8343 8 місяців тому

    Wonderful

  • @MuhammadZeeshan-rw8sg
    @MuhammadZeeshan-rw8sg 3 роки тому

    Really helpful. Thanks

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

    Excellent Video - Thank you

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

    What if I wanted to hide columns and rows to a protected sheet?

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

    Thanks

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

    Very useful for the your teaching

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

    Very well done! Thank you.

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

    Thanks for the info. Very simple and clear instructions.

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

    Thanks🌹

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

    Great explanation, need help here. All step done, but even I unhighlighted the columns with filter, I still can do filter. Can pls help???😢

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

    It’s worked thanks you!

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

    Thanks a looooootttt

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

    Very clear, ty!

  • @saki7952
    @saki7952 6 років тому +1

    When will you finish excel math? We are waiting for other math videos. I like u very much.

  • @993porky
    @993porky 4 роки тому

    Informative, clear, concise brilliant thanks

  • @aqibishfaq1313
    @aqibishfaq1313 5 років тому

    Very helpful video thanks for sharing your knowledge

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

    Thank you so much ☺️

  • @RajveerSingh-fc9ml
    @RajveerSingh-fc9ml Рік тому

    Thanks Sir

  • @eng.a
    @eng.a 2 роки тому

    Thanks 👏🏻👏🏻👏🏻🥺🥺🥺

  • @trock111jomy
    @trock111jomy 2 роки тому +2

    Individual Cell Protections begins at 3:35

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

    thanks

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

    Thank you for your valuable Info

  • @m.m1048
    @m.m1048 3 роки тому

    Hi is it possible to remove notification from protected case. I dont want it pop me out window all time when I try to modify protected case?

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

    Your voice, man !! You're doing a great job.

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

    What I exactly needed, Great Explanation Thank you!!

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

    very clear and simple, that's what I need!!! Thanks

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

    Excelente amigo. Justo what I need.Thankyou.

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

    Thank you so much,

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

    Start at 3:18 for tutorial