Protecting the formatting in Excel 2007

A combination of 2 settings provides you this functionality:

1. Select the cells where data entry will be performed, go in Format Cells, Protection and uncheck LOCKED.

2. On the Ribbon, under Review, PROTECT your worksheet. Notice that some exceptions are available: Select, Format cells, Insert, Delete, etc. Just leave them all unchecked, except Select. If your users need to insert rows, also include the exceptions to "Insert rows" (and perhaps "Delete rows").

• Under Review, unlock Protect, then go to to Home tab.
• under Font (bottom right corner) open Formatting, select the Protection tab and uncheck the Locked box.
• On the sheet, select the cells you would like to protect and go back to your formatting (under Font) and Protection and recheck the Locked box.
• Then go to your Review tab and select Protect sheet. Remember to select what actions someone will be able to change.