Every Excel cell is Locked by default; it only takes effect after Review > Protect Sheet. Steps: select the input cells, Format Cells > Protection > clear Locked, then Protect Sheet, then test a locked and an open cell. Source: Microsoft Support.
If you spent hours, or even days, working on an Excel file that you're getting ready to share with a larger group, you may not want to give everyone a copy of that file where they can change all of the values. If there are some fields or values you want to remain fairly static, it's easy to lock specific fields in your Excel file.
Microsoft Excel Lock Cells
One easy way to protect your spreadsheets from those 'oops' moments is by locking cells in Excel. Click the 🔗 in this pin for a quick step-by-step guide to show you how. #Excel #ExcelTips #ExcelTutorial #LearnExcel #ExcelTraining
How to LOCK (Protect) Cells in Excel - An Easy Step-by-Step Guide - YouTube
Lock Cells In Excel Online
How To Open Locked Excel
