I am really puzzled by the way the protection works in excel..it seems almost to stupid..

Well, my problem is I have some cells that should NOT be locked or protected in any way (user may delete / edit / merge...etc).

The cells have been formatted with NO locking, but as soon as the sheet is protected I am not allowed to delete?!

also, when I unprotect the sheet and check the cells locking is back on?!

Can anyone explain why? Or have the people at MS screwed up again?