Excel - Protection

Hi Teju,

Thank you for using the forum to ask a question.

To add a Password to an Excel file in 2007

Click on the Office Button (Top Left)
Select "Prepare"
Chose "Encrypt Document"
A dialogue box will appear prompting you to create a password.
Once you have confirmed your password, the document will now be password protected.

To remove a password, repeat the first 3 steps.
When the dialogue box appears, you will see the password you have selected. Delete it, and then choose Ok. The password will now be removed.

Please remember that adding a personal Password to a shared file can cause problems. If you forget the Password the file can not be recovered. Read the warnings in the dialogue box before setting a password.

To protect an entire Workbook in Excel 2007
Select the Review tab along the ribbon at the top of the screen.
Click on Protect Workbook and choose the option "Protect Structure and Windows"
A dialogue will appear with the option "Structure" ticked. You can add a password in the space below. Choose Ok.


Kind regards

Richard Bailey
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector