Forum Discussion
How can I lock column width but still be able to edit cells?
- Jun 28, 2021
Tu_Nguyen_123 By default, all cells are set-up to be locked. But that doesn't come into effect until you protect the sheet. So, unprotect the sheet first (if it still is protected), select all cells that the user should be able to edit, go to Format Cells, Protection and remove the check mark before the "Locked" option. Now protect the sheet again with the options you showed in the picture. Users should now be able to edit the specified cells, but not format rows and columns.
Tu_Nguyen_123 By default, all cells are set-up to be locked. But that doesn't come into effect until you protect the sheet. So, unprotect the sheet first (if it still is protected), select all cells that the user should be able to edit, go to Format Cells, Protection and remove the check mark before the "Locked" option. Now protect the sheet again with the options you showed in the picture. Users should now be able to edit the specified cells, but not format rows and columns.
Riny_van_Eekelen: it works now! thank you so much 🙂