Computer and Software Support


Protect sheet 

 Excel

You can have it so that a cell cannot be altered. If you have data in cells you don't want altered, you will protect the data by selecting the Protect Sheet feature. By default, the cells are selected to be protected. How ever they are not protected till you tell Excel to protect the sheet. To do this, follow these steps

  1. Right-click a cell that you do not want to protect (Cells you want to edit once the sheet is protected)

  2. Click Format Cells

 

  1. Click Protection

   

  1. Uncheck Locked

   

  1. Click OK

   

  1. Repeat steps 1 through 5 for each cell you don't want protected

  2. Click Review

   

  1. Click Protect Sheet

   

  1. Click OK

   

  1. Save the workbook