Thread: Lock Cells
View Single Post
  #2   Report Post  
David Billigmeier
 
Posts: n/a
Default

First, make sure all cells are unlocked... Format-Cells-Protection and
unselect 'Locked'

Second, select only the cells you want to lock and Format-Cells-Protection
again, this time make sure 'Locked' is checked (for these cells).

Third, Tools-Protection-'Protect Sheet'

The first step will make sure only the cells you don't want changed remain
locked, while the other cells remain editable.


--
Regards,
Dave


"Diana" wrote:

I was wondering if someone could help me...I was wondering if there was any
way to lock a couple of cells so that the information cannot be erased, only
modified when needed?