Locking Cells to Prevent Changes
After you protect a worksheet, you can lock an individual cell to prevent it from being changed. This level of protection goes beyond simply protecting a worksheet; it prevents anyone using the worksheet from changing the contents or formatting of the cell. Excel 2007 enables this option by default.
Lock Cells
Select the cells you want to lock.
Right-click the selection and click Format Cells on the shortcut menu.
Click ...
Get Microsoft® Office Excel® 2007 Plain & Simple 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.
