Excel 97 - How do you prevent changes to formulas?

  • Thread starter Thread starter JEFFREY ZAZULIA
  • Start date Start date
J

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
 
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
 
Back
Top