12 December 2007

How to lock only a few cells on a worksheet?

Sometime you want to lock a few cell on your workbook for protect your data. So please follow me

1.Select cell so you don't want to lock
2.Click rigth on mouse
3.Select format cell
4.Select tab "Protection"
5.Uncheck on Locked check box
6.Click buttom OK
7.Select Tools on Manu bar
8.Select Protection
9.Select Protection sheet
10.Set password.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.