Locking or Unlocking Worksheet Cells
To prevent accidental changes to your data, you can lock worksheet cells. When you lock selected cells, you cannot make changes to them until you unlock them. When you lock cells, users can unlock the data and make changes unless you add password protection to the worksheet. For security or confidentiality reasons, you might want to hide formulas from view. If so, you can hide or unhide them using the Protection tab in the Format Cells dialog box.
Lock or Unlock Worksheet Cells
Select the cell or range you want to lock or unlock.
Click the Home tab.
Click the Format button, and then click Lock Cell to lock ...
Get Excel® 2013 On Demand now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
