ไม่สามารถเล่นวิดีโอนี้
ขออภัยในความไม่สะดวก
Advanced Excel - Protecting a Sheet - Excel Tutorial
ฝัง
- เผยแพร่เมื่อ 16 ส.ค. 2024
- Here's my entire playlist of Excel tutorials: bit.ly/tech4excel Learn how to protect sheets in Excel so that only part of the sheet can be altered. Protecting a sheet is especially useful if you share spreadsheets with other people and don't want them to be able to accidentally change or input incorrect data. Please also watch my other Excel video tutorials. ***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa...
Also mentioned in the video is AMAZING music such as the following:
Classic Synthpop and New Wave:
Depeche Mode - Violator: amzn.to/2utJMqp
Alphaville - Forever Young: amzn.to/2tl4gle
OMD - Messages: The Best of OMD: amzn.to/2uyz1Ct
New Music by Classic Synthpop Bands:
A-ha - Foot of the Mountain: amzn.to/2tbfrsv
Alphaville - Catching Rays on Giant: amzn.to/2tbD445
Underground Modern Synthpop:
Code 64 - Departure: amzn.to/2tbEtbd
Echo Image - Compuphonic: amzn.to/2uEvzr4
I WILL POST MORE SOON
Sorry, but there isn't anyone worse than me in computer matters and I can say that after following your videos I and practice at the same time for only thre weeks now, I consider myself a master. My kids are amazed at how well mummy is doing. Thank you, you are the BEST in TH-cam. The best. Simple straightforward, no bs talk, just the best. 😊
Wow, thanks! You've made my day with your kind comments.
@@techteachersandstudents bro you are the best, its a bit surreal, im sitting here thinking, shall i just do all his videos and just be the man lol, yes i will, on my 4th now
Your voice is so relaxing and clear to listen to. I am easily and actively following with your steps! You have found a new fan in me. Wish you were my teacher.
I have always wanted to learn how to do this. Your tutorials are helping me more than you know!!
I honestly enjoyed every part of these tutorials.
I too have downloaded every series of your lesson. Well explained Good job bro. God bless
The way you keep delivering in these videos. Kudos to you👍
Thank you so much for these!!! I've watched your previous tutorials and they're amazing. You're such a life saver! I hope you and your family is safe during this pandemic! Also, I love how you introduced me to synthpop because of your videos haha 🧡
Thanks for your kind comments, and for watching. Long live Synthpop! :)
Thanks a bunch for all the tutorials and for a simple explanation of how things can be done. There is no reason why I wouldn’t subscribe to such a helpful channel. Greatly appreciate it !
U are simply amazing and the way you explain things is the best ever on TH-cam..please keep it up..thanks for sharing your knowledge
You made is so easy!
Thank you!
Very useful indeed. I've never bothered to get to grips with Excel because I perceived it as too complex. I was wrong! Thank you for these tutorials.
Thank you! I was wasting so much time guessing. So helpful. The example was useful.
It's been amazing and a pleasure following your channel
I'm learning a lot with your excel tutorials, i have just a question so far. i'm trying to protect my spreadsheet, but in my excel i don't have access to the dialog box launcher. how can i set it up?
Outstanding. Your teaching method is great. Just learned something new!!
Amazing tricks and your voice is crisp clear
Appreciated
Claps claps
Thank you so much
And it's mine humble request to you please keep on making these meaning full video's for us
Thanks and regards
You saved my life! Thank you so much!!!
I'm glad the tutorials have been useful to you. Thanks for the feedback.
Excellent tutorial on Excel. I believe I learned more than what I forgot. I am starting a new career and need to improve my skills. This was a great reminder and new short cuts.
This is beautiful and concise. Thank you!
“Pa paaa? Can you grant me access to your excel so I can add value to your Synthpop cd column ??” Lol
thanks for making our lives easier!
I was just stuck with password protection but after watching your video everything is clear now.
Your videos are really helpful, thankyou for making these
Thank you so much, these videos are so informative and beneficial!
Thank you, for making these tutorials so clear and easy to follow. And I just added several new albums to my apple music library!
I downloaded the whole playlist the explanations are so clear thank you for doing this
Thanks alot!Your tutorials are great and explanation are very clear and easy to catch up.
Excellent thanks
you're cracking me up w the shameless music plugs hahaha
Your are amazing man...I love you so much
Thank you
This helps a lot. Thank you!
Thanks very useful
Thank you!! Your videos are helping me a lot!
Life saved 🙌
Your tutorials are really good
Those music recommendations though! Lit!!!
Yes roja manesh you r right there
Thanks
I very like your music
recommendations!
Very interesting
ONG!!!!!!! Thank you so much!
Awesome video! One big tip and something that would differentiate you... Cutout out the waffle at the beginning. Shorten your intro and don't give us any scenarios (i.e. say for example you want to...) we already know why we are here! Just get straight to the point. Nonetheless, thanks!
Great video, am mastering Excel thanks to you...
Thank you .✌🏾
Hello, Thank you for all the lessons, they are so much helpful and this specific lesson, it is not allowing to edit the selected unlocked cells after protecting the sheet. it locks every cell if its locked or unlocked. Could you help on the same. Thank you.
Great tutorial!
I can't replicate this in Numbers because the two programs are too different at this stage, but it's easy to follow along even still.
Thank you so much man...
I have a question: I forgot how to move an entire column full of data into another part of the sheet. Do you mention this in one of the tutorials? If yes, which one so I can go over this again. Thank you!
I have a problem when opening the Excel file the barcode column changed automatically the barcode column becomes all the same value any explanation for this problem
Thanks!
Hey! What if the file is in a shared drive? Does it protect the sheet from other users in the shared drive? thanks
i have the office365 version of xcel. it's free.
i can't find the little 'launch buttons' that your version of xcel have.
Is it because my xcel version is free, therefore, there some functions are limited?
is there any way to complete the task of this lesson with the free xcel version?
thank you.
great tut! but where is the link for this work sheet??? :"(
Hi can they delete the whole file itself?
hello there, but how to unlock the cells now? thankx a lot.
U are the best thanks alot
Sir how come when you try to hide it doesn’t not hide
I can still see it
Is there a way to lock the formatting and column width? I can sometimes get in a hurry and drag column widths or grab other elements by accident, and I would love to have a way to avoid that.
Hello, again,
I just can't believe it has taken me this long to find your Excel Videos. Lucky dip I guess!
It is good to find Tutorials like yours, that do not use Finance or Office DB creation, to explain Excel.
I'd like to ask advice, if that is OK? I have created a DB (using your videos). My DB is for CD's. What I am trying to do is create a "link" to individual tracks, on a CD, possibly on a separate page/sheet. Could you help.
Be very nice to know your name too.
Thank's very much.
Dc
Are you talking about hyperlink ? It can be done by Ctrl + K
If a sheet Is protected and I have send the file to someone, can they unprotect it if the sheet is not password protected
GOOD
how do i download this workbook, so I can work along with you?
On my excel spreadsheet, I don't see the font alignment number or styles underneath the home>font tab.
Is it possible to protect the sheet, set a different password for each sheet. The point is that the contents of the spreadsheet is visible only after entering the password? ... how can I do it?
On my excel spreadsheet, I don't see the font alignment number or styles underneath the home>font tab.
Do you know where to find it?
I have a problem , I can't click on "Protect Sheet" help plz!!!
Same with me.
@@snezanasimic8914 I didn't finish the lesson because of it 🙂
Do you have conditional formatting video for excel?
th-cam.com/video/Yu1JE2LuLl4/w-d-xo.html
Check this one out. He has briefly touched conditional formatting part
Good :)
In Tarantino's voice: geeeniuuuuus
Proctecting 😋
whats your name?
ups, already find it. Sorry
Okay, just going to click the launch button... ',:l
Hindi me dalo I am aryawarth
Thank you