Protect all cells from a sheet except specific cells

**kenjiventurina** · 05-17-2012, 04:36 AM

Hi everyone,

I would like to request for your advice on how can i lock or protect all cells in a worksheet except for some specific cells.

Thanks a lot in advance! Appreciate much if anyone will respond.

**davesexcel** · 05-17-2012, 04:52 AM

You can select the cells that you want to allow editing, then right click and select Format Calls=>Protection and uncheck the locked box then OK
You can then select the Review Ribbon and protect the sheet. Cells that are not locked can be edited.