how to protect cells?

[angela]

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.

 

[Peo Sjoblom]

You need to protect the sheet under tools>protection

--


Regards,


Peo Sjoblom

 

[Xhawk57]

In the Format>Cells menu you can lock and unlock cells, then use
tools>protection and set the options to not allow selection of locked cells.
Hope this helps.

 

[Chip Pearson]

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)

 

[Shane Devenshire]

Hi,

Tools, Protection, Protect Worksheet, and add a password or not.

This is after you un-lock cells where you want them to work.

Cheers,
Shane