If you want your sheet to be password protected, you have the option of entering a password here. This will bring up the Protect Sheet window. To protect the sheet, simply right-click on the tab at the bottom of the sheet, and choose Protect Sheet… from the menu. However, they can still modify the unlocked cells. Once you protect the sheet, users cannot change the locked cells. Now that you've locked/unlocked the cells that you want users to be able to edit, you want to protect the sheet. I share some shortcuts to make this process faster in the Bonus section below. Since cells are locked by default, most of the job will be going through the sheet and unlocking cells that can be edited by users. If you want users to be able to edit a particular cell or range, uncheck the Locked box so they are unlocked. Once we protect the worksheet (in the next step) those locked cells will not be able to be altered by users. Locked is the default setting for all cells in a new worksheet/workbook. Next, make sure that the Locked option is checked. This will bring up the Format Cells window (keyboard shortcut for this window is Ctrl + 1.). Right-click on the cell or range you want to change, and choose Format Cells from the menu that appears. Step 1: Lock and Unlock Specific Cells or Ranges

Here's how to prevent users from changing some cells.

It's easy to do, and it involves two basic steps: The great news is that you can lock or unlock any cell, or a whole range of cells, to keep your work protected. This is especially true for cells that contain formulas and special formatting. If you share your spreadsheets with other users, you've probably found that there are specific cells you don't want them to modify. Lock-Cells-and-Sheet-Protection-Quote-Example.zip Download Protecting Your Work from Unwanted Changes

Freeze first two rows in excel 2007