How to "lock" Excel worksheet?

Whats the best way to lock an entire worksheet in MS Excel 2003 so that ONLY the worksheet creator can make changes to the values in each cell?

4 answers Last reply
More about quot lock quot excel worksheet
  1. Click on Tools -> Protection. From here, you can select whether to protect the sheet, the workbook or to protect and share the workbook.

    Each option has a box to put in a password.
  2. OK I agree with that trick but, if we want only color format is locked and rest function will open to edit for user.

    Please give reply
  3. In the "Review" tab, click on the "Protect sheet"

    I also recommend doing "Protect workbook" to lock the visibility of the sheet
  4. How to lock secure to folder
Ask a new question

Read More

Excel 2003 Excel Windows XP