- If you apply protection to cells in a worksheet, the contents of the cells cannot be changed until the protection is turned off.
- Locking cells has no effect unless the worksheet itself is protected.
- By default, when a new worksheet is started all the cells are locked, but the worksheet is not protected, so all cells can be seen as usual.
To protect a range or group of cells in a worksheet using Excel 2007, Excel 2010 or Microsoft Excel 2013:
- Select those cells that you want to unlock.
- Click the Home tab, then in the Cells group, click the Format dropdown.
- Click Lock Cell. This is a toggle, so will unlock the cells.
- Click the Review tab, then in the Changes group, click Protect Sheet.
- If you want to ensure that a password is required, type one into the Passwordto unprotect sheet box.
- Select what you…
View original post 275 more words