Block Certain Cells

**serged20** · 05-03-2012, 01:45 PM

Hello Again, I am trying to create a document where the users are only allowed to modify certain cells.
Cells A2, A3, A4, B2, B3, B4 Can not be modified in one documents and I have another where I only want users to modify only 2 cells

Thanks for the help

**dilipandey** · 05-03-2012, 01:52 PM

Hi serged20,

First select entire sheet and unlock all cells, procedure given below to lock / unlock.

Right click on these cells, Format, protection tab, check Locked cells and now protect sheet.. this will lock (block) these cells only

Users to modify only 2 cells..
=======================
Select those two cells, right click , format, protection tab, uncheck locked cells and protect sheet. now all other cells would be blocked and these two cells would be editable. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>