Lock formatting and formulas

[deemer98]

I'm having some troubles in figuring out how to lock formats and formulas on a spreadsheet. I've googled some info, but it's not working. I want my sheet to allow the workers to ENTER data only. Cells A1:P29. How do I get those cells locked from anyone editing the formatting and formulas besides me? I know I can put a password on it, but it's making me use a password to enter data and that's not what I want. Thanks in advance!

 

[JimM]

Right click on the cells you want to be able to edit, select format cells and then the protection tab. Uncheck the 'locked' box
Now when you protect the sheet from the Review menu on the ribbon all cells will be locked other than the ones you've just unlocked

Make sense?

 

[deemer98]

Jim...didn't work. It makes you put in a password in order to do ANYTHING in the sheet and that's not what I want.

If I created the sheet but wanted YOU to be able to only enter data in A1:P29 (without you entering a password) how would I protect the formatting and formulas I created in order to keep you from changing them?