Protect Sheet: clicking in cells removes all previous text
I protected a sheet because I have formulas on the sheet. So, I locked those
cells and left the rest of the cells unlocked. When the sheet is protected,
if I click in a cell and try to add text to the cell, it deletes all the
previous text. Is there any way to stop that from happening?
|