By default, all cells are locked (once you protect the worksheet), so
to lock only a subset of cells, you first need to unlock all the
cells. Press CTRL A twice to select all the cells on the worksheet.
Then go to the Format menu, choose Cells, then Protection. There,
uncheck the Locked option. Click OK. Now, select the cells you want to
lock. Go back to Edit, then Cells, then Protection, and check the
Locked option. Then protect the worksheet from the Tools menu. Cells
that are locked only behave that way when the worksheet is protected.
If the sheet is not protected, locked cells can be modified.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Wed, 12 Nov 2008 07:14:01 -0800, angela
wrote:

I have set up a spreadsheet for a co-worker. How do I protect the formulas
so they can't be inadvertently (or intentionally) deleted or written over?
I've tried the instructions "Lock only a few cells on a worksheet" but I can
still change the cells that I want protected.