Excel Digest

By default all cells in a worksheet are locked (see image below). I.e when you protect a worksheet every cell in the worksheet will be protected.

To handle cell protection differently then you have change the default settings for the required cells.
Here is a scenario to protect formula cells but allow access to data cells:

Select [...]

In a previous post we talked about how to protect worksheet elements. When you protect a worksheet, by default all its cells will be locked.
If you want to protect or unprotect some cells selectively then do the following:

Select the cells you want to protect / unprotect.
In the main menu click Format.
Click Cells. The Format Cells [...]