How to Lock a Formula in Excel 2007

1. Select the cell containing the formula you wish to lock by highlighting it.
2. Click on the 'Home' tab, which is located on the top of the Excel window.
3. Navigate to the 'Cells' module, which is on the right half of the Excel window. Select 'Format.' A menu displaying cell formatting options will appear.
4. Navigate to the 'Protection' section of the format menu. Click on 'Lock Cell,' highlighting the lock icon.
5. Protect the sheet; until you do so, locking the formula cell will not take effect. Repeat steps 2 and 3. Select 'Protect Sheet' from the cell formatting menu. A dialog box titled 'Protect Sheet' will appear.
6. Select the 'Protect worksheet and contents of locked cells' option. Type in a password that users must enter to unprotect the sheet into the password field; this is not a required step. In the 'Allow all users of this worksheet to' section, choose privileges that you wish users to have when working with the sheet. Finish by clicking 'OK.'