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.) 1 st 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...
Connecting, Sharing and Discovering