![how to lock certain cells in excel formulas how to lock certain cells in excel formulas](https://cdn-adclh.nitrocdn.com/zciqOWZgDznkuqFpvIJsLUeyHlJtlHxe/assets/static/optimized/rev-ae61699/wp-content/uploads/2016/05/How-to-Lock-Cells-in-Excel-dialog-box-launcher.png)
#How to lock certain cells in excel formulas how to
It also shows how to unlock cells on a protected sheet by a password, or allow specific users to edit those cells without password. Right-click on your selection, select Format Cells, and click on the Protection tab. The tutorial explains how to lock a cell or certain cells in Excel. These will be the specific cells that can be edited even after the sheet is protected.Ģ. Select all the cells you don't want to be locked. Go back to the Protection tab and checkmark the locked. Excel will select all the formulas in the sheet. However, you can specify whether a certain cell should be locked or unlocked in the cell's format properties.ġ. On the Protection tab, uncheck the locked checkbox and then click OK.
![how to lock certain cells in excel formulas how to lock certain cells in excel formulas](http://www.liangshunet.com/lsfile/ct/2019/11/kuwa18ih1077129.gif)
By default all the cells are locked and you need to protect these cells to prevent changes. As mentioned above, all cells are locked by default when you protect the sheet. In this tutorial, you'll learn how to lock cells in Excel. In our example, in an inventory list you might allow unit prices and stock quantities to be updated, but not the item IDs, names, or descriptions. There might be times when you want to lock certain cells from being changed but still allow users to adjust other cells in a worksheet.
Remove the check mark next to Locked, then click OK. Right-click on a selected cell and choose the Format Cells option. Select the cells that you DON’T want to lock. How to Lock Specific Cells in an Excel Worksheet Use these steps to lock a cell in Excel 2010. The cells can only be unlocked when the sheet is unprotected (by going to the Review tab again, choosing "Unprotect Sheet," and entering the password, if required).