Protecting Cells in Worksheet

 1.   Highlight entire worksheet by clicking immediately to the left of the column A header and immediately above row 1 header.

  2.   Right click on highlighted worksheet and then left click on format cells.

  3.   Click on the protection tab and uncheck Locked.  Then click OK.

   4.   Then select the cells that you are interested in protecting.

   5.   I have selected cells A1 to Q30

  6.   Right click on the highlighted area and left click on format cells.

  7.   Select the protection tab and tick the locked check box.  Then click OK.

  8.   Click on the Home tab> then click the format dropdown button in the cells section> then click protect sheet.

  9.   Select the options you want to allow such as Format Cells> Then enter a password> Then click OK.

 10.   Enter the password again for confirmation. Click OK.

 11.   Finally, save the workbook.