Excel > Excel 2007 Intermediate > Excel Protection

Excel File Protection

Workbooks can be protected to prevent unauthorised changes.

A password can be set to prevent unauthorised users from opening the workbook, or to ensure they can only open a read only copy.

Save and protect a workbook

  1. Click the Office Button and then click Save As
  2. The Save As dialogue box is displayed

  3. Click Tools > General Options
  4. Accessing general optionsExcel School

    The General Options dialogue box is displayed

    Excel spreadsheet passwords

  5. Enter a password in the Password to open and/or Password to modify fields
  6. Click Ok
  7. The Confirm Password dialogue box is displayed

    Confirm password

  8. Re-enter the password
  9. Click Ok
  10. Finish saving the workbook as normal

On opening the workbook the user will be prompted to enter a password. In the image below the user has the option of opening a read only workbook, or entering a password to open it for modifying.

Entering the spreadsheet password

Protect an existing workbook

  1. Click the Office Button, select Prepare and click Encrypt Document
  2. The Encrypt Document dialogue box appears

    Encypt document

  3. Enter a password
  4. Click Ok
  5. Re-enter the password in the Confirm Password dialogue box
  6. Click Ok

Follow us on

Facebook  Twitter  You Tube