jane has attended:
Excel Intermediate course
Password protection on spreadsheet
how do i protect my spreadsheet and all the data from others who might have access to my work
RE: password protection on spreadsheet
Hello Jane
Thank you for your question.
You can apply a password to open a file, which you can do by going to File - Save as, then clicking the Tools button and select General Options.
You will then have an option to set up a password to open the file.
Otherwise you can set up protection that won't stop people from opening the file, but will stop them from editing your a worksheet.
On the worksheet you wish to protect, go to Tools - Protection - Protect Sheet, and then set up a password for the protection if you wish.
Protection has to be applied on a sheet-by-sheet basis.
Kind regards
Amanda