We all use excel sheets for some or the other purpose and many times we also want to protect them to restrict unauthorized access. Here are the simple steps to protect excel sheets (latest excel version):
- Open the excel sheet.
- From top menu, click on “File”.
- Then select “Passwords…”
- Enter “Password to open”.
- Enter “Password to modify”.
- Next, you will be asked to “Reenter password to proceed”. Same as Step 4.
- Next, you will be asked to “Reenter password to modify”. Same as Step 5.
- Save and close the file.
That’s it. Next time when you open the file, you will be prompted to enter the password.