Thursday, March 27, 2008

Unlock Cells

  1. Select the cells you want users to be able to modify.
  2. Choose Home => Cells => Format => Format Cells, which displays the Format Cells dialog box.
  3. Click the Protection tab and deselect the Locked option. Click ok.
    Optionally, choose Home => Cells => Format => Lock Cells. Because, by default, Excel locks all cells, choosing this option turns the Lock Cells option off. Click the option again to turn on the Lock Cells option.

No comments: