How do I lock cells in Excel?

How do I lock cells in Excel?

https://youtu.be/lvzB9FK1z6o Link to YouTube video How do I lock cells in Excel? If you have created an Excel workbook with calculations in it that you don't want your colleagues to be able to accidentally delete or overtype, you will need to lock the relevant cells.  You may be surprised to hear that by default, all the cells in Excel are locked by default!  But if that is the case, then why can they be edited?  That's because it is a two stage process. So let's imagine you've made this sweet spreadsheet at work, and you want your colleagues to be able to update the cells A3 to B8 (the cells in white) but have the green cells locked down: As I said, by default all the cells are actually locked already, what you need to do now is select the cells that you want to be unlocked, i.e. in this case cells A3 to B8.  Highlight and select this cell range, then right-click and select...
Read More