Locking Cells

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.

To Lock Cells

  1. Select the cells you want to lock.

  2. 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.

To Unlock Cells

  1. Select the locked cells you want to unlock.

  2. Select Unlock Cells from the Format menu.
  • The cells are unlocked.


Copyright © 1999, Gobe Software, Inc