Forum Discussion

Tu_Nguyen_123's avatar
Tu_Nguyen_123
Copper Contributor
Jun 28, 2021
Solved

How can I lock column width but still be able to edit cells?

Hello, I need help with editing protected areas. On the table "Allow all users of this worksheet to;", I already ticked all the boxes except for "format columns" and "format rows". The result is tha...
  • Riny_van_Eekelen's avatar
    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.

Resources