|
 |
A locked cell cannot be edited. Locking cells is very useful if you are
working with a large amount of data and wish to safeguard that data from inadvertent
changes. It is a good idea to lock cells with complex formulas to avoid accidentally
erasing or editing the formulas. Formulas inside locked cells calculate the same as
those in unlocked cells.
- Select the cells you want to lock.
- Select Lock Cells from the Format menu.
- Once locked, the values in a cell cannot be changed. Formulas inside the locked
cells calculate the same as those in unlocked cells.
- Select the locked cells you want to unlock.
- Select Unlock Cells from the Format menu.

|