Hi friends if you are going to collect data or information in excel sheet and you want to restrict users to some part of fields she/he does not change or edit than this article is important for you . as i always forgetting after . This is very interesting.
1.) 1st of All Select entire sheet by left-top-corner
of sheet or by select all option and then open format cell window by ctrl+1 or
by right click on sheet. Then Check mark
yes to Locked option.
2.) Now Select those
cells by ctrl or one by one and again go to format cell and then unchecked the Locked option like below.
3.) Now got to Protect workbook and give the password and
re-enter password.
And now check by editing the sheet, you will not edit...
Nice Post
ReplyDelete