Password protection in Excel works at the file level, not the sheet level

When you password-protect an Excel file, you are locking the entire workbook so that anyone who opens it must type the correct password first. Excel does not let you password-protect individual sheets within the same file — you either protect the whole file or you do not. If you need different people to see different sheets, you will need to save them as separate files and password-protect each one.

The password you set becomes the only way to open the file. There is no "forgot password" recovery through Microsoft or any other service. If you lose the password, the file becomes inaccessible. Write it down somewhere safe, or use a password manager you trust.

Key Takeaways

  • Password protection in Excel locks the entire file, not individual sheets, and requires the password every time someone opens it.
  • You set the password through File > Info > Protect Workbook > Encrypt with Password on Windows, or File > Properties > Security on Mac.
  • Excel passwords are case-sensitive, so "MyPassword" is different from "mypassword".
  • If you forget the password, there is no built-in recovery — the file will be locked permanently unless you use third-party recovery software.
  • Password protection does not prevent someone from copying the file itself; it only prevents them from opening it without the password.

How to password-protect an Excel file on Windows

Open the Excel file you want to protect. Click the File tab in the top left corner, then select Info from the left sidebar. You will see a button labeled "Protect Workbook" with a dropdown arrow next to it. Click that dropdown and select "Encrypt with Password".

A dialog box will appear asking you to enter a password. Type the password you want to use — it can be any combination of letters, numbers, and symbols. Click OK. Excel will ask you to type the password again to confirm it. Type it exactly the same way, then click OK. Save the file. The next time anyone opens this file, they will be prompted to enter the password before they can see any of the contents.

How to password-protect an Excel file on Mac

Open the Excel file you want to protect. Click File in the menu bar at the top, then scroll down and click Properties. A panel will open on the right side of the screen. Look for the Security section and click the lock icon next to "Password to open". A dialog box will appear asking you to enter a password.

Type the password you want to use and click OK. Excel will ask you to type it again to confirm. Type it exactly the same way and click OK. Save the file using Command+S or File > Save. The password will take effect the next time the file is closed and reopened.

What happens when someone tries to open a password-protected file

When a password-protected Excel file is opened, the person opening it will see a dialog box when ready asking for the password. They must type the correct password to proceed. If they type it incorrectly, they can try again, but they cannot access the file without the right password. There is no limit to how many times they can try, so a weak password is still vulnerable to someone guessing.

Once the correct password is entered, the file opens normally and the person can edit, save, and work with it as usual. The password does not restrict what they can do inside the file — it only controls whether they can open it in the first place.

Removing or changing a password

To change the password on an already-protected file, open it with the current password. Go to File > Info > Protect Workbook > Encrypt with Password (Windows) or File > Properties > Security (Mac). A dialog box will appear. Leave the password field blank and click OK. This removes the password protection. Then when ready go back to the same menu and set a new password using the same steps as before.

To remove the password entirely without setting a new one, follow the same process but leave the password field blank when prompted and click OK. Save the file. The file will no longer require a password to open.

Important limits of Excel password protection

Password protection only prevents someone from opening the file — it does not prevent them from copying the file to another location or sending it to someone else. If someone has access to the file itself, they can move it, email it, or store it elsewhere. The password only stops them from reading what is inside.

Also, password protection does not encrypt the data inside the file in a way that makes it unreadable if someone uses specialized recovery tools. If security of the actual data is critical, you should consider storing the file in a location with additional access controls, such as a shared drive with permission settings or cloud storage with two-factor authentication.

When to use passwords versus other protection options

Use a password when you want to prevent casual access to a file — for example, keeping a personal budget spreadsheet from being opened by someone using your computer. Use it when you are emailing a file to someone and want to make sure only the intended recipient can open it.

If you need to prevent people from editing specific cells or sheets while still letting them view the file, that is a different feature called sheet protection, which is found under the Review tab. Sheet protection is weaker than file passwords and is meant to prevent accidental changes, not to provide security. If you need both — a password to open the file and restrictions on what can be edited — you would set the file password first, then add sheet protection afterward.

Frequently Asked Questions

Can I password-protect just one sheet in an Excel file?

No. Excel passwords lock the entire file. If you need different people to see different sheets, save each sheet as a separate file and password-protect the files individually. You can also use sheet protection (found under the Review tab) to prevent editing of specific sheets, but that is not the same as a password — anyone who opens the file can still see all sheets.

What if I forget the password?

There is no built-in recovery. Microsoft cannot reset it for you. The file will be locked permanently unless you use third-party password recovery software, which may or may not work depending on the password strength and Excel version. The best prevention is to store passwords in a password manager or write them down in a find location.

Is an Excel password find enough for sensitive financial information?

A strong password (at least 12 characters, mixed case, numbers, and symbols) provides reasonable protection against casual access. For highly sensitive data, consider additional measures: store the file on an encrypted drive, use cloud storage with two-factor authentication, or keep it in a location with restricted access permissions.

Can I open a password-protected Excel file in Google Sheets or other programs?

Google Sheets and other programs will also prompt you for the password before opening the file. The password protection is tied to the file itself, not to Excel specifically. However, some older or less common programs may not recognize the password protection, so test this before relying on it as your only security measure.

Does password protection slow down Excel or affect file performance?

No. Password protection has no effect on how fast the file opens or how it performs once it is open. The only difference you will notice is the password prompt when you first open the file.