Forum Discussion
Unprotect certain cells in an Excel 365 Workbook.
I have an Excel 365 Workbook/Sheet and I want to prevent certain cells from being changed. I have followed all the instructions I can find, but I am unable to do that. Either ALL the cells get protec...
Hi Omahajoe,
By default, all cells are protected but it only gets applied when you turn on the protection to the sheet, using password or even without password.
To unprotect certain cells only, select the cell(s) and then from Ribbon choose Format > (unselect) Protect Cells; OR Right Click > Format Cells > Protection >Untick Protect Cells; and then Review (tab) > Protect Sheet.
Use Like if this post helped to solve your issue and Mark as Best Response if the request can be closed.