How to Change Your Excel File Password Guide

Why You Might Want to Change Your Excel Password

Excel files often contain sensitive information—financial records, student grades, personal data, or confidential business details. If you've shared your password with colleagues who no longer need access, or if you suspect someone has guessed it, changing your password is a practical security step. Unlike changing passwords for email or social media accounts, changing an Excel file password happens at the file level itself, not through Microsoft's servers. This means the process is entirely within your control and happens on your computer.

Free Guide to Renting Without Perfect Credit →

There are several scenarios where you might find yourself needing to change an Excel password. Perhaps you set up a file with a temporary password months ago and never updated it to something more secure. Or maybe you're preparing to share a file with new team members and want to ensure previous users can't open it. In educational settings, instructors sometimes protect answer keys or grading rubrics and need to update who can view them. Small business owners managing inventory sheets or budgets may rotate password access as employees change roles.

The actual process varies depending on what version of Excel you're using—Microsoft 365, Excel 2021, Excel 2019, or older versions all handle password changes slightly differently. Additionally, Excel offers two types of password protection: one that prevents people from opening the file entirely, and another that prevents them from editing it. Understanding which type you currently have matters because the steps to change them aren't identical.

One important detail: if you've forgotten the current password, there's no built-in recovery option within Excel itself. You cannot use a "forgot password" feature like you would with online accounts. This guide covers changing a password you currently know. If you've lost track of your password, that's a different challenge requiring third-party tools or recreating the file.

Practical takeaway: Before you start, identify which type of password protection your file has and which version of Excel you're using. You can find the version by opening Excel, going to File, then Account, and looking at the "About Excel" section. Knowing these details will make the password change process straightforward.

Understanding Excel's Two Types of Password Protection

Excel gives you two distinct password options, and they work in completely different ways. The first is an "open password," sometimes called a file password. This prevents anyone without the password from even opening the file. The second is a "modify password," which lets people open the file but prevents them from making changes to it unless they enter the password. A file can have just one type of protection, both types, or neither. Understanding which one you currently have is essential before attempting to change anything.

Get Your Free Manatee County Water Bill Guide →

The open password is the more restrictive of the two. When someone tries to open a file protected with an open password, Excel immediately displays a dialog box asking for a password before showing any content whatsoever. This means the file's data remains completely hidden from anyone who doesn't have the correct password. In educational contexts, this might protect an exam or answer key. In business, this might protect financial forecasts or client lists. The open password essentially makes the file inaccessible without credentials.

The modify password, by contrast, lets the file be opened and viewed by anyone, but prevents editing. Someone can read the spreadsheet, view all formulas and data, and even copy information from it—but they cannot make changes, save over the original, or add new content. This is useful when you want to share information widely but maintain a single authoritative version. For example, a teacher might use a modify password on a grade calculation sheet so students can see the formulas and understand how grades are computed, but can't alter the sheet itself.

To check which type of protection your file currently has, open the file and look for these clues: If you were prompted to enter a password before the file would open, it has an open password. If the file opened without a password prompt but certain editing features are grayed out or disabled, it likely has a modify password. Another way to check is to go to the Tools menu (or Review menu in newer versions) and look for "Protect Sheet" or "Protect Workbook" options. Protected files will show these options as currently active.

Some files have both types of protection simultaneously—they require a password to open AND a different password to edit. This is common in situations where you want to distribute a file to many people (all of whom need one password to open it) but allow editing only to a small group (who need a different password to make changes). Changing passwords in this scenario means you'll need to go through the process twice.

Practical takeaway: Before changing any password, clarify which type of protection you're dealing with. Try to edit the file—if editing is blocked, you have a modify password. If you couldn't open it at all, you have an open password. This clarity will guide which steps you actually need to follow.

Changing an Open Password in Microsoft 365 and Excel 2021

Changing the password that prevents people from opening your file requires you to remove the old password and set a new one. In Microsoft 365 and Excel 2021, the process begins by opening the file itself—you'll need to enter the current password to do this. Once the file is open, navigate to File in the top menu bar, then click on "Info" on the left side. This section shows various properties and options related to your file.

Learn How to Right Click on Your Laptop →

Look for a button or option labeled "Protect Workbook" in the Info section. Clicking this will reveal a dropdown menu with several choices. Select "Encrypt with Password" (the exact wording may vary slightly depending on your Excel version, but "Encrypt" is the key word to look for). This action opens a dialog box titled "Encrypt Document." This dialog displays a single text field where you'll enter a new password. Note that when you type, the characters appear as dots for security—you won't see what you're actually typing.

The password field in the Encrypt Document dialog typically has no length restrictions, though most people create passwords between 8 and 20 characters. You can use uppercase letters, lowercase letters, numbers, and special characters like exclamation marks or dollar signs. Creating a stronger password means using a mix of these elements rather than just letters. However, be aware that Excel passwords are case-sensitive, meaning "Password123" is different from "password123." This matters both when setting the password and later when you or others try to open the file.

After typing your new password into the Encrypt Document dialog, click OK. Excel immediately asks you to confirm the password by typing it again in a second dialog that appears. This confirmation step prevents accidental typos—if the two passwords don't match, Excel will tell you and ask you to try again. Once the passwords match and you confirm, Excel processes the change. The file is now protected with your new open password.

Here's a critical point many people miss: changing the open password on an existing file overwrites the old password completely. You don't need to enter the old password to set a new one in this process, which surprises many users. The system assumes that if you have the file open, you have legitimate access to it. The moment you click OK on the new password confirmation, anyone trying to open this file in the future will need the new password, not the old one.

Practical takeaway: Write down your new password somewhere secure (a password manager is ideal) before you forget it. If you lose an Excel file's open password, there's no standard way to recover it. The password protection will remain, and the file will be permanently inaccessible without entering the correct password.

Changing a Modify Password in Microsoft 365 and Excel 2021

Changing a modify password follows a similar initial path but diverges at a critical point. Open your file (you won't need a password to do this if only the modify password is set) and go to File, then Info. Look for "Protect Workbook" and click the dropdown. This time, instead of selecting "Encrypt with Password," you're looking for an option related to protecting the sheet or workbook from editing. In Excel 2021 and Microsoft 365, this is often labeled "Protect Current Sheet" or "Protect Workbook Structure," depending on whether you're protecting the individual sheet or the overall workbook settings.

Your Free Guide to Dental Implant Options in Apex →

When you select the protection option for editing, a dialog box appears asking you to enter a password. Unlike the open password scenario, this dialog also has a confirmation field where you must re-enter the password immediately. Some versions of Excel show both fields on the same screen; others show them separately. The key point is the same: both entries must match. Type your new password in the first field, then