If you’ve spent hours, or even days, working on an Excel file that you’re preparing to share with a large group, you might not want to give everyone a copy of the file where they all Values change. If there are certain fields or values that you want to keep fairly constant, it’s easy to lock specific fields in your Excel file. However, there are some caveats. The first is that if you want to lock cells in more than one sheet, you must lock those sheets individually.
How to lock a cell in excel ? And another is that you can only do this in Excel for Microsoft 365 and the desktop version of Excel, but not in Excel for Web.
