Forum Discussion
sheet protection
Dear team, I have one question, how to protect excel sheet in term of allowing data entry to enter the data but thy cannot delete any earlier data ??
This kind of protection isn't possible as far as I know, because Excel doesn't distinguish between different kinds of editing of cells (deletion vs. editing vs. adding). You can prevent the deletion of rows/columns, but not the overwriting or deletion of individual cells (without preventing all editing).
