Locking+Cells

Lock/Unlock Cells in Excel
By default, all cells in an Excel spreadsheet are locked. This makes it very easy to protect all data in a single worksheet or in a workbook simply by applying the //Protect Sheet// or //Protect Workbook//option. Unlocking specific cells permits changes to be made to these cells after the protect sheet/workbook option has been applied. Often certain areas of a worksheet are unlocked so that new data can be added. Cells containing formulas, functions, or other important data are kept locked so that once the protect sheet/workbook option has been applied, these cells cannot be changed.

Example: Unlock Cells in Excel 2007
> > > > >
 * 1) Enter the following data into cells A1 to D1: 123, 135, 147, 130.
 * 1) Drag select cells A1 and B1 to highlight them.
 * 1) Click on the //Home// tab.
 * 1) Choose the **Format** option on the ribbon to open the drop down list.
 * 1) Click on //Lock Cell// option at the bottom of the list.
 * 1) The //Lock Cell// option works like an ON/OFF button. Since all cells are initially locked in the worksheet, clicking on the option has the affect of **Unlocking** the highlighted cells A1 and B1.

Protect the Worksheet
By default, all cells in an Excel spreadsheet are locked. This makes it very easy to protect all data in a single worksheet simply by applying the//Protect Sheet// option. Unlocking specific cells permits changes to be made to these cells after the protect sheet option has been applied. Often certain areas of a worksheet are unlocked so that new data can be added. Cells containing formulas, functions, or other important data are kept locked so that once the protect sheet option has been applied, these cells cannot be changed.

Example: Protect a Worksheet in Excel 2007
> > > > > > > > > > > >
 * 1) Open an Excel file to protect. If you open a new file all cells in the worksheet will be protected. If you wish, follow the example above to unlock certain cells in a worksheet.
 * 1) Click on the //Home// tab.
 * 1) Choose the **Format** option on theribbon to open the drop down list.
 * 1) Click on //Protect Sheet// option at the bottom of the list to open the //Protect Sheet// dialog box.
 * 1) This dialog box contains a number of options when protecting the worksheet.
 * 1) The first option is to add a password to prevent worksheet protection from being turned off. This password does not stop users from opening the worksheet and viewing the contents.
 * 1) Next there a number of options that can be turned on or off with check boxes. The first two allow a user to drag select locked and unlocked cells. If these two are turned off, users will not be able to make any changes to a worksheet - even if it contains unlocked cells.
 * 1) The remaining options allow users to carry out specific tasks on a protected worksheet, such as formatting cells and sorting data.
 * 1) These options, however, do not all work the same. For instance, if the format cells option is checked off when a sheet is protected, all cells can be formatted. The sort option, on the other hand, works only on those cells that have been unlocked before the sheet was protected.
 * 1) When you have selected the appropriate options, click OK.
 * Turning Off Worksheet Protection**
 * 1) Click on the //Home// tab.
 * 1) Choose the **Format** option on the ribbon to open the drop down list.
 * 1) Click on //Unprotect Sheet// option at the bottom of the list.