How to Lock Cells 🔒in Excel to Protect your Formulas & Only Allow Input where Needed

Просмотров 696 тыс.

% 10 636

Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-courses
Learn how to lock cells in Excel for creating foolproof templates! This tutorial is ideal for those who want to ensure data integrity in shared documents.
⬇️ Download the workbook here: pages.xelplus.com/lock-unlock-cells-file
✅ What You'll Learn:
▪️ Setting up cell protection: A guide to using Excel's Review tab for sheet protection.
▪️ Password protection: How to add and remove passwords for extra security.
▪️ Formatting cells for protection: Detailed instructions on selecting and locking cells.
▪️ Customizing cell locking: Techniques for locking only specific cells or ranges.
▪️ Utilizing 'Find and Replace' for efficiency: A unique method to select cells based on color for protection.
▪️ Practical tips: Insights on protecting your formulas while allowing inputs in designated areas.
Ever created this perfect shared Excel template only to come back to a total disaster? Collaborating on shared spreadsheets can be painful. But it doesn't have to be that way! In this video I'll show you how you can lock and unlock any cell, or a whole range of cells, to keep your work protected. This way you'd be able to protect your formula cells and allow people to only input in specific ranges or cells. I'll also show you a cool Excel trick which allows you to multi-select cells based on their color and then lock those cells only.
00:00 How to protect cells in Excel
03:20 How to Multi-Select cells based on Color
05:29 Wrap Up
🎬 LINKS to more Excel Basic videos: ru-vid.com/group/PLmHVyfmcRKyx1KSoobwukzf1Nf-Y97Rw0
➡️ Join this channel to get access to perks: ru-vid.com/show-UCJtUOos_MwJa_Ewii-R3cJAjoin
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: lgharani
LinkedIn: www.linkedin.com/company/xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel

Опубликовано:

21 апр 2022

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 592

@LeilaGharani 10 месяцев назад

Grab the file I used in the video from here 👉 pages.xelplus.com/lock-unlock-cells-file

@giyah6038 2 года назад

Not only did I learn how to lock/unlock cells, but also learned how to select only shaded cells. Another really easy and helpful tutorial. Thank you!

@zayaneats9930 2 года назад

Gi Yeh...❤️❤️❤️❤️❤️❤️

@Jaque12345Jaque 2 года назад

Same here. Super helpful!!

@user-qm4dm9gs8o 2 года назад

خخخهههههههههههههههخههههخهخههههههخخهت

@danielcarr2975 2 года назад

Whilst I knew how to lock cells, I had no clue I could select cells using the find function by colour - what an amazing time saving tip - awesome 👏

@wakelingchicken 2 года назад

Hi Leila My Top Tip if you're doing a lot of work locking / unlocking cells is to put the "Lock Cell" button into the quick access toolbar. It then acts as a visual indicator as to whether the highlighted cell is locked or unlocked and allows you to quickly change the setting without going into the Ctrl-1 formatting dialogue. I hope that's helpful for a few people :) Andy

@LeilaGharani 2 года назад

I like that! Thanks for sharing Andy.

@card1_diy 2 года назад

That got me confused too. Im gonna practice

@tiongah7690 2 года назад

that needs macro right?

@wakelingchicken 2 года назад

No@@tiongah7690 , it doesn't need a macro. In the desktop app, above the menu bar, in the title bar top left, you should see the 'quick access toolbar', and on the right of that is a drop down icon that allows you to customise that toolbar. You simply need to add the 'Lock Cell' button from the 'Home Tab'. Maybe Leila will include this tip in a future video for you :)

@keijo456 2 года назад

@@wakelingchicken Thank you for the tip!

@lorikmor Год назад

I can’t like this enough. This is one of the most counterintuitive concepts in Excel. Thanks for breaking it down so simply.

@JayBee-hb2pm 2 года назад

Everything you post about Excel is so relevant to my job role. I just love how you come up with things that make our lives so much easier Leila. Thank you for sharing yet another great tip

@rlibby404 10 месяцев назад

I abandoned hope for good Excel tutorials many years ago, they are usually the most terrible and unreliable videos out there, but you, you really did it.

@silviopontesx 2 года назад

Thank you for teaching us; I watched many of your videos, I admire your sensitivity and the simplicity and fluidity of how you delve into the topic! What a monument to knowledge! Thank you so much!

@michaelcorvin25 Год назад

Thank you for explaining things in a very logical and easy manner! I love your tutorial videos on EXCEL!

@mohammadmosallanejad4912 2 года назад

This guide is what I was thinking about right now, because I have made a worksheet and plan to share it with other colleagues. Thank you Leila ONCE AGAIN.❤️

@MarceColucci 2 года назад

This was brilliant! I've been looking for a way to do this for ages and this explained it so clearly and easily!! thank you Leila.

@roywilson9580 2 года назад

I totally agree, it took a lot of research to discover how to use the locked check box. That said cell level locking is something that I have frequently used to protect formulas and other critical contents against accidentally being changed.

@marianb2274 2 года назад

This is perfectly timed for something I am creating for work. What a life-saving (and time-saving) tip! Thank you!!

@DeltaSanjula Год назад

Working in a rural Australia has many challenges, especially when finding quality learning resources. Subscribing to your channel is like access to the ultimate office encyclopedia. Thank you for unscrambling the chaos that sometimes is excel!!

@sulemanhassanali Год назад

You are saving my days! Additional learning how to select specific formatting.

@TarunSharma-ll8ge 2 года назад

I make excel calculators a lot and I use this feature but this color coding will save a lot of my time as I used to manually untick the 'locked' for each cell. Thanks for this video.

@gcecg 2 года назад

Thanks for the great video. I've been using the lock cells feature for some time. An added bonus is that when you navigate the protected worksheet using the enter key, all the locked cells are automatically skipped. It's much quicker to move just among the cells that are editable. Cheers!

@johniethompson8788 2 года назад

I have used the lock and unlock function for cells before but this explanation was the best I've seen and definitely helps me. Now I'm going to go change a few things in my current project. 👍👍

@oedipamaas8660 Год назад

I learned how to lock/unlock cells before. But I forgot. I was definitely doing it the hard way! This mini tutorial should save a lot of time. Thank you Leila! I learn how to solve a lot of excel problems watching your videos. 🤩

@broderp Месяц назад

I hope you are paid very well in some capacity for for your awesome tutorials.....You're methods are to the point, easy to understand and are exactly what I need. Thank you!

@LeilaGharani Месяц назад

I appreciate that!

@michaelstamos5510 Год назад

Leila - you are such a champion - thank you for your amazing guidance

@DssSmyth 10 месяцев назад

As always, you do a great job in explaining the topic. I'm with you, the whole lock/unlock is a bit confusing but I'm in the know now thanks to you!

@ahumblemuslim3009 2 года назад

I'm using Excel on daily basis and your lessons are really helpful, thank you miss.

@nairkrishnadas 2 года назад

Hi Leila, Each of your tips is fantastic. I always learn something new whenever I watch your videos. Thanks a lot

@pambackal 2 года назад

You always have something new to surprise me! Search by cell color format is new, yet another very useful tutorial. Thanks a lot...

@silverlicious2086 2 года назад

Always a good idea to protect certain cells. Especially those that have complex formulas. Have a nice day Leila.

@jonminer9891 2 года назад

Hi, Leila. It was a great lesson. Thanks for sharing! Stay healthy!

@MarissaCatanghal 2 месяца назад

You explain things well. Thank you.

@DennisYeadon 2 года назад

I have used this feature many times. What I liked about the tutorial is the method your used to select all the cells you needed to unlock. Thanks

@reedschmelzle3710 Год назад

Insanely Professional Video! Amazing clarity of information and easy to follow along. I only watched this video once to learn this function. Thank you

@patweyandt1237 Год назад

You are the BEST!! Your videos and tutorials are so easy to follow and understand. Thank you.

@jayshreebhakta9937 2 года назад

I knew how to lock and unlock, but learned something new today that you can use Ctrl + F to search the formatting too!! Thanks Leila, you are the best!!

@nickvandernet 3 месяца назад

Thank you. Very helpful and concise.

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

whenever i need help in excel your tutorial is the best to option...thank you!

@donaldmcintosh6545 2 года назад

Hi Leila - Great tip, thanks. It has always been one of my bug-bears when handing out excel files to my customers.

@arvinndssinha3390 2 года назад

Great Help. Thank you, Leila.

@utahcnatrainingcenters5903 Год назад

Thank you, you explained it very well.

@UA-js9fn 2 года назад

Many thanks for your efforts and supports

@mohammednomanumeruddeen7165 2 года назад

You always simplify stuff. Love it

@shabirnasir Год назад

Your expertise are great..Thank you for your time and videos

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

You're an amazing resource, thanks so much for sharing! I ALWAYS learn more than just the lesson you're teaching.

@magnusalexander2617 Год назад

That was a really smart move! Thanks for sharing!

@JC_Deutscher Год назад

wonderful! great explanation, thanks!

@lukmanayodeji9563 2 года назад

You are really amazing @Leila. I will always be glued to your channel. Triple thump up for you my Mentor. Thanks for your Tutorials. Alhamdulillah, they had really transformed me to Pro Excel User.

@chimo2dax Год назад

Thank you, again, for your tips. Youre a life saver

@ThomTydeman 2 месяца назад

Your videos are terrific. Your content is always clear and concise, and you always impart additional tips and tricks that delight your subscribers.

@miguelplg19 Месяц назад

Thanks for sharing your knowledge. Really appreciate the help.

@sayla45 Месяц назад

Great tip for managing Excel protection

@suecampanelli311 2 года назад

Agree, the Locked feature was confusing to understand at first. It’s been a few years since I’ve needed to use it and this tip was refreshing. Also, great tip about find coloured cells! Thanks Leila!

@LeilaGharani 2 года назад

Great to hear! Thanks Sue.

@JeffreyJeffersonUK 2 года назад

You have saved me so much time and effort with your videos. Thank you so much. (Also your courses are brilliant!)

@brianjohansen5325 Год назад

As always easy and clear explanation. Thanks

@VishwasKadrolli 2 года назад

I struggled a lot to ensure the sheet is locked and other dont input values other than cells meant to, but your video makes it so simple, I am gonna use it all through out my work. Thanks for the tip!

@ivanbork4175 2 года назад

Use it a lot, normally with the option to only select unlocked cells, but especially the find with format is a cool way to save time I have not seen before, thanks

@jtadena21 4 месяца назад

Such a big help. Thank you so much for this.

@Festus171 2 года назад

Oh my goodness! I can't even calculate the amount of time I have killed doing this the hard way. That is a wonderful tip. I've been looking for a faster way to do this very task for a long time. Thanks so much for sharing!

@swedeman73 26 дней назад

Great job. So simple. You are excellent.

@user-lv4wx9tx1y 9 месяцев назад

Thanks-- this was really clear and helpful. You're a great teacher.

@villiamo3861 Год назад

Superb video - thank you!

@siyabulelatshali1012 2 года назад

I literally just googled this. Your video's are always relevant. Thank you.

@LeilaGharani 2 года назад

Happy to help!

@notreallyhere1136 2 года назад

Perfect timing, this is next on my to do list for a project at work, thank you

@alexwilberforce9023 Год назад

It was really helpful. Thanks for sharing.

@mimicat3065 2 года назад

Aaaaaaww! Gosh.. so simple.. It took me quite a lot of select cells, unlocking and protect/unprotect.. Wow.. you explained it the easiest way.. Super thank you with video.. i love it.. Mabuhay! 🇵🇭🇵🇭🇵🇭🇵🇭🇵🇭🇵🇭 👏👏👏👏👏👏

@diongumbs8984 Год назад

Great tutorial: Short, concise and understanding.

@sachinrv1 2 года назад

Leila you are super amazing. I used to manually select the colored cells I wanted my employees to edit. Never used this FIND FORMAT feature. This is way to handy. Thanks a ton for sharing this trick. I have been following all your videos for couple of years now. You are like "one stop" for advanced Excel needs. Kudos :)

@LeilaGharani 2 года назад

Glad I could help, Sachin!

@Ali_F_Salem 2 года назад

quick and simple explanation, thank you.

@lisay5302 2 года назад

Thank you for explaining this perfectly!

@user-xh1lr3yo3y 2 года назад

Wow! I love you! This is so helpful!

@jessicaarend217 Год назад

This is the most helpful video I have found on this topic. Thank you so very much!

@JuanHernandez-pf6yg Месяц назад

Very useful. Thank you!

@ioannisstagonis8028 Год назад

You saved my day! Excellent work!🙂

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

Leila ♥️ Thanks 😎👍 Just what I was looking for my workbook.

@TheCryptKeeper8 Год назад

superb and clear. Thank you.

@MakupaChemists 2 месяца назад

Thank you so much for the prefect guidance

@Michael_NV 2 года назад

I think that this is a perfect explanation. Thank you. I always wanted to protect just few cells instead of complete sheet, but I never knew how. Till now. 🙂

@phyuzar5979 Год назад

Thank you so much fo r clear guide! I love it!

@mohamedsfart8861 2 года назад

Thank you so much, it's really helpful

@Skans-Gustav 4 месяца назад

Very nicely presented. Thank you. I liked the formatting by colour.

@baskarm9963 2 года назад

I was really looking for this Leila. Thank you😊

@jeffrothman2833 Месяц назад

Excellent! This has confused me for years but you made the process crystal clear. Very well presented.

@LeilaGharani 29 дней назад

Glad you liked it!

@taryn4123 Год назад

Brilliant! I need this in my life

@JeremyMcMahan 2 года назад

I too, have found this confusing. Thank you for the understandable description and examples!

@SanthoshKumar-xy3zm 2 года назад

Very well explained Thank you 🙏

@windsorlewis3344 Год назад

This is amazing and will be so helpful at work tomorrow. Thank you so much!

@vincentcollin6490 2 года назад

We can add that when protecting the sheet, we can uncheck the box "Select locked cells". And therefore leave only the unlocked cells accessible.😉 Thank you for this lesson.