excel protected sheet - some cells are unlocked for user input getting cleared on click

[AgentBaadal]

i have protected a excel sheet of data entry
locked some cells and kept some cells unlocked for user input .
But when the unlocked cells are being clicked for slight modification , the entire cell data is getting cleared .
How to avoid this ?

any help would be greatly appreciated...thanks in advance

 

[Skyybot]

Running any Macros?

 

[AgentBaadal]

Running any Macros?

i have protected a excel sheet of data entry
locked some cells and kept some cells unlocked for user input .
But when the unlocked cells are being clicked for slight modification , the entire cell data is getting cleared .
How to avoid this ?

any help would be greatly appreciated...thanks in advance

no macros , no vba , no other things . used only some " if " cases only simple excel file for input and output data entry.

i have locked the titles and kept unlocked the input boxes , and then protected the sheet .
when i enter some long name of data as input and due to some spelling mistake or some other in input cell , while entering names on other cells i click on previous cell i observed , the data inside cell disappears and i have to enter the input of that cell again.

 

[AgentBaadal]

Found the solution :

while keeping some cells locked , and cells unlocked in protection window (ctrl +1)
i was keeping checkmark on lock cell for " cells to be kept locked"
i was keeping checkmark on hidden for "cells to be kept locked"
(i thought hidden would keep formulas hidden from showing)

similarly
i was keeping checkmark on lock cell for " cells to be kept unlocked
i was keeping checkmark on hidden for "cells to be kept unlocked "

solution:
Here the main magic, keeping the checkmark on HIDDEN for cells to be kept unlocked , after making the sheet protected was making unlocked cells data disappear , i just "removed " the tick of hidden.
and it solved my problem . thank you . hope this thread would be helpful to anyone out there with same problem.