Lock Specific Cells in ExcelFollow the steps below to Lock only certain selected or specific cells in Excel worksheet.1. If you had typed a Password, you will be prompted to reconfirm the password.Once the worksheet is protected, all the Cells in the worksheet will be locked and Excel will display вЂњThe Cell or Chart youвЂ™re trying to open is on a protected sheetвЂќ message, whenever anyone tries to modify the worksheet.In case you want to edit the Cells, you will have to first Unprotect the worksheet by clicking on Review tab > Unprotect Sheet.Note: You will be required to enter a Password, in case the worksheet that you are trying to unlock was protected using a Password. In the Protect Sheet box that appears, select Protect worksheet and contents of locked cells option > Enter a Password (optional) > select actions that you want to allow (Select Locked Cells, Select Unlocked Cells, etc) and click on OK.3.

On Protect Sheet screen, select Protect worksheet and contents of locked cells option > select the actions that you want to permit on this worksheet (Select Cells, Insert rows, Format Cells, etc) and click on OK to save the settings.After this only the selected Cells will become locked in the worksheet and all other cells will be unlocked.Also, users will be able to work on the worksheet and perform all permitted actions that you had selected in Protect Sheet window. Next, click on the Review tab and click on Protect Sheet option in вЂњChangesвЂќ group.7. In the Format Cells Dialog box, click on the Protection tab and select the Locked option.6. Now, select only the Specific Cells that you want to Lock and click on the dialog box launcher icon located in Alignment group of the Home Tab.In this case, we have selected Cells D2 to D5 to prevent others from making changes to Rates in the worksheet.5. In Format Cells dialog box, click on the Protection tab and uncheck the Locked box.4.

Function Lock Cells Excel For Mac