Can I set a password on a spreadsheet? (Office 2003)

Before setting the password it is important to remember that if you lose or forget the password, it cannot be recovered.  Also remember that passwords are case sensitive.

Yes you can set a password on a Microsoft Excel spreadsheet.

To do this you need to click on the Tools tab and select Options.

A pop up box should then appear. When this appears you will need to click on the Security tab.

This will then give you the option to enter a password to open or to enter a password to modify.

If you don’t want anyone else to be able to access the spreadsheet then you will need to set the password to open.

If you would like people to view the spreadsheet but not modify the data within you will need to set the password to modify.

After entering the password click on OK where you will be asked to confirm the password.

KB5729