Forum Discussion
Excel worksheet protection in Excel Online
Does worksheet protection work in Excel Online? We have a workbook where we have set certain ranges for all users (Everyone) to be able to edit without password. Enable protection on the worksheet ...
I am using Excel online and I cannot even access nor am I seeing cell protection at all....
There are no "Format" options when right clicking a cell.
And where there is "Format" in the drop down, there is nothing that says protection or lock or anything of the sort.
This is so inconsistent and problematic considering we're now in 2022.
Can someone else confirm?
Hello, It seems effectively that you need the desktop version to define the protections. Concerning the format, it depends on how you protect your sheet. Perhaps check the option > Allow all users of this worksheet to: "Format cells". It is correct on my computer.
Regards
Patrice