![](/uploads/1/2/7/4/127460723/196833873.jpg)
We lock cells in excel to protect them so that there isn’t any unwanted changes in the cell, by default all the cells in excel are locked which can be seen by right click on the cell and then click on format options which will open a wizard box for us, now click on protection tab and we can see the option for locked cells, to protect a cell after locking it we need to put a protection. Password Protect in Excel. Why we lock cells in our worksheet or why we protect our worksheet with the password. The answer is to protect your worksheet from other users so that he or she cannot make any changes, deletion, moving of data in a worksheet.
Excel for Office 365 for Mac Excel 2019 for Mac Excel 2016 for Mac To prevent a user from accidentally or deliberately changing, moving, or deleting important data, you can lock cells and protect them. Locking cells takes two steps: adding the Lock formatting to the cells, and then turning on protection of the sheet. To lock cells. Select the cells that you want to lock. On the Format menu, click Cells, or press + 1.
Click the Protection tab, and then make sure that the Locked check box is selected.Note: The password is optional. If you do not supply a password, any user can unprotect the sheet and change what was protected.
If you do enter a password, make sure that you choose a password that is easy to remember, or write it down and keep it in a safe place. If you lose the password, you can't access the protected parts on the sheet. Allow Users To Edit Ranges In Excel For Mac 2017Lock cells to protect them in Excel for Mac. Select the cells that you want to lock.
![Excel For Mac Lock Cells Excel For Mac Lock Cells](/uploads/1/2/7/4/127460723/768688165.png)
![Excel For Mac Lock Cells Excel For Mac Lock Cells](http://i.ytimg.com/vi/ZSqD8KFXsW8/maxresdefault.jpg)
On the Format menu, click Cells, or press + 1. Click the Protection tab, and then make sure that the Locked check box is selected. Cisco anyconnect vpn client for mac os x 10.9 download. If any cells should be unlocked, select them.
Disassembler software. On the Review tab, click Protect Sheet or Protect Workbook.jaroteb.
![](/uploads/1/2/7/4/127460723/196833873.jpg)