Hi,

before you go Tools - Protection - Protect sheet ....

- click each cell you want to be able to edit
- open the formatting dialog and on the Protection tab unselect the "Locked" check box

Then click Tools - Protection - Protect sheet and select the protection options for the sheet, i.e. whether or not users may select protected cells, etc.

You should now be able to clear unprotected cells and change their values.

You may not delete the cells, i.e. remove them from the sheet and have the surrounding cells fill the gap.

If that is not the behaviour you're getting, please upload a sample sheet in which the problem can be reproduced.

Explain what behaviour you would expect .

cheers