From the course: Excel: Avoiding Common Mistakes (Microsoft 365)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Lock cells with worksheet protection
From the course: Excel: Avoiding Common Mistakes (Microsoft 365)
Lock cells with worksheet protection
- [Instructor] We're looking at a worksheet called Protect Sheet in our chapter two file. It's over 700 rows of HR type data and multiple people have access to this file. But I'm in charge and I don't want others to make changes where there shouldn't be changes. Column E has formulas. I'll double click on cell E2, we see a formula there. Now if data has to be adjusted in column D, the hire date, I do want the formula to do its job and do it correctly but I don't want somebody typing here. Imagine where someone's looking at a sheet of paper and says this hire date should have been 2015, so I'll just type a four here 'cause that's what it will be if this is 2015. Can I type a four here right now? I can and what am I about to do? To wipe out the formula. I'm not going to do that, I'll press escape. I don't want anybody altering data in column E. I want to allow changes in column D. I certainly don't want them…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.