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 figured it out...
before you protect your sheet or workbook, you need to first format the cells.
Select the cells your would like to be edited and right click > format cells> protection tab> deselect the locked box.
Once this is complete you cant then allow editing ranges from the review button within the ribbon. And then you can protect the sheet and or workbook.
before you protect your sheet or workbook, you need to first format the cells.
Select the cells your would like to be edited and right click > format cells> protection tab> deselect the locked box.
Once this is complete you cant then allow editing ranges from the review button within the ribbon. And then you can protect the sheet and or workbook.
Thank you. This worked