MS-Excel / General Formatting

Excel 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.
[Previous] [Contents] [Next]

In this tutorial:

  1. Protecting Excel Data
  2. Quickly Hide an Open Workbook
  3. Make a File Read-Only
  4. Mark a Workbook as Final
  5. Inspecting a Workbook
  6. Hide and Unhide Columns and Rows
  7. Excel Unlock Cells
  8. Protect Worksheets
  9. Excel Restrict User Data Entry
  10. Excel Assign a File Password
  11. Excel Hide Cell Formulas
  12. Protecting a workbook's structure
  13. Using a digital signature in Excel
  14. Signing a Workbook