Lock Cells/Protect Data In Cells

1. Create a simple spreadsheet as shown below
   
   
   
   
2. The cells we want to protect in the above sample are the Employee ID, Percentage and Total.
   
   
3. Select B1 to B5.
   
   
   
   
4. Choose the Format option on the Home ribbon to open the drop down list and then click on the Lock Cell option at the bottom.
   
   
5. Next go to the Format option on the Home ribbon again to open the drop down list and then click on the Protect Sheet option to enable the cells to be locked out.
   
   
   
   
6. Make sure that you have Select unlocked cells showing as seen above. You can also password protect the sheet as well.
   
   
7. Click on OK and now you will only be able to edit the Income column of the sheet.