locking cells

[denhar]

I have set up an extensive spreadsheet for my "non-Excel" co-workers.
do not want them inadvertently typing in the cells that have formulas.
Other than putting a comment, is there any way to lock those cells s
they can not enter information by mistake

 

[Dave Peterson]

Each cell has a locked/unlocked property.

Format|cells|protection tab.

Lock the cells you want and unlock the cells that the user should be able to
change.

Then protect the workbook.
Tools|protection|protect sheet.

But there are lots of things that the user can't do on a protected sheet.

 

[denhar]

do I protect the worksheet or the workbook because I see options fo
both

 

[Dave Peterson]

You protect the worksheet.

Sorry about the typo:

Then protect the workbook.
Tools|protection|protect sheet.

should have read:

Then protect the workSHEET.
Tools|protection|protect sheet.