How To Protect Formula Cells But Allow Access To Data Cells

I try this method but data entry not allowed

Here is a scenario to protect

formula cells but allow access to data cells:

. Select all cells in the worksheet by clicking on the top left corner of the sheet.

. On the Format menu Click Cells.

. Click on the Protection tab.

. Uncheck the Locked and

Hidden check boxes, then click OK.

These four steps will make all cells in the worksheet unprotected and can therefor be modified. Next step is to
protect the formula cells, and here is how we do it:

. Select all cells that have formulas.

. On the Format menu Click Cells.

. Click on the Protection tab.

. Check the Locked and Hidden check boxes, then click OK.

. On the Tools menu click

Protection and select Protect sheet