https://bugs.documentfoundation.org/show_bug.cgi?id=136003
--- Comment #13 from Sahil Gautam <me.sahilgau...@gmail.com> --- There is no easy way to unprotect all the cells of a sheet. So the user has to go the long way, select all the cells, then right click > format cells > cell protection, and then uncheck. That too works only when the sheet is empty (doesn't have anything in any cell). Test it like this create an empty sheet, then check cell protection for all the cells by selecting all, then right click > format cells > cell protection (protected by default). uncheck it, and then check if protection is turned off for all the cells or not, by going to random cells and checking cell protection. (it works for empty sheet i.e. you would be able to unprotect all the cells.) then again close this sheet and create a new sheet, write something in some cells (say 1 2 3 4 5 6 in the first 6 cells of column A). Then go ahead and try to unprotect all the cells again using the same method above. It doesn't work. So there is a need to have a button (or something similar) which can toggle cell protection for either the whole sheet, or the selection. (I don't know if there is any). And Excel doesn't allow deleting rows with protected cells, so I think would be better to keep the behaviour consistent with it. (I mean it might be a big deal for some people) -- You are receiving this mail because: You are on the CC list for the bug.