Sunday, June 15, 2014

How we Lock our Assignment or work sheet in MS Excel?

1) Select the whole sheet.
2) Right click on anywhere on selected area.
3) Click on format cell.
4) Click on protection tag.
5) Unchecked the locked cell  option and then ok.
6) Click on protect sheet.
7) Right click on selected area.
8) Format cell.
9) Check the locked cell and then ok.
10) Click on Review Ribbon.
11) Click on protect sheet.
12) Assign the password.
13) Unchecked the select locked cell option ok and retype the same password and then ok.

No comments:

Post a Comment