Excel 97 - How do you prevent changes to formulas?

[JEFFREY ZAZULIA]

We have a worksheet to insert daily sales figures into during the course of
a month. Is there a way to lock the formulas in a cell so that if someone
enters the wrong info they don't erase the formulas along with the bad info?

Thanks,
Jeff

 

[Max]

Here's a couple of steps:

Select all data input cells to be left *unlocked*
(If you hold down Ctrl key, you can select multiple
discontiguous input ranges with the mouse in 1 swoop)

Click Format > Cells > Protection tab
Uncheck "Locked" > OK

Click Tools > Protection > Protect Sheet
Enter password > OK
Re-enter to confirm > OK

To unprotect:
Click Tools > Protection > Unprotect Sheet
Enter password > OK