Friday, October 19, 2012

Selective cell protection in Spreadsheet

Protecting sheet will locks the entire sheet and not allows users to edit any cell value. In some scenarios, some of the limited cells can be locked by using the following workaround.
  • Select the cells that not to be locked.
  • Right click and select "Format" and then Select "Cell Protection" Tab.
  • Uncheck the protected option to skip from lock.
  • Select Tools Menu → Protect Document → sheet and give password to lock entire sheet. Uncheck "Select Unprotected cells" option to prohibit user even to select the protected cells if needed. 
Here after user can able to enter or modify the values only on allowed cells.

No comments:

Post a Comment