Excel Protect Sheet: How to Change a Password

How-to basics · Updated November 21, 2026

To change an Excel worksheet protection password, first remove the current protection with the existing password, then protect the sheet again using the new one. In Excel for Microsoft 365 on Windows, go to Review > Unprotect Sheet, enter the current password, and then choose Review > Protect Sheet to set a replacement.

What changing a sheet password means

Excel does not provide a direct edit-password box for a protected worksheet. Changing its password is a two-part process: unprotect the sheet with its current password, then turn protection back on with a new password. The sheet’s data and formulas remain in place during this process; you are changing the protection setting, not rebuilding the worksheet.

This applies to a worksheet tab, not necessarily the whole workbook. A file can have several protected sheets, each with its own password, while the workbook’s structure may also be protected separately. If only one tab is protected, changing that sheet’s password does not automatically change passwords on other tabs or change the password needed to open an encrypted file.

You need to know the existing sheet password to use the standard change procedure. If you do not know it, Excel does not offer a normal password-reset control for worksheet protection. That situation calls for a backup, the workbook owner, or another legitimate copy—not the ordinary password-change steps.

Change the password in Excel for Windows

Before you start, save the workbook. If it is shared or stored in a cloud location, make sure you are editing the intended copy and that your changes have finished syncing. Then follow these steps in the desktop version of Excel for Microsoft 365:

  1. Select the worksheet tab whose password you want to change.
  2. Open the Review tab and select Unprotect Sheet. Depending on the ribbon layout, the command may be visible in the Protect group.
  3. Enter the current password in the prompt and confirm. If the sheet was protected without a password, Excel may remove protection without asking for one.
  4. On the Review tab, select Protect Sheet.
  5. In the Protect Sheet dialog, enter the new password, choose which actions users may perform, and select OK.
  6. Enter the new password again when Excel asks you to confirm it, then select OK.

Test the result by selecting a cell that should be restricted and trying to edit it. If the protection is working, Excel should prevent the edit or display a message that the cell is protected. Save the workbook after confirming the new settings. If several worksheets need new passwords, repeat the process for each one; Excel does not apply a sheet password change to every tab at once.

Choose protection options before you finish

The Protect Sheet dialog controls more than the password. Its checkboxes specify which actions are allowed while the sheet is protected. For example, you might let users select locked and unlocked cells but prevent them from formatting cells, inserting rows, or deleting columns. The right choices depend on what people need to do with the workbook, not simply on how much restriction sounds safest.

Consider a simple expense-entry sheet. Users may need to type amounts into designated input cells and use an existing filter, but they may not need to alter formulas, change column widths, or insert new rows. You can allow the needed actions and leave other operations disabled. Test the permissions with a typical user task; a restriction that blocks legitimate work can create confusion even when the password is correct.

The password field is optional. If you protect a sheet without a password, a user can generally remove protection without entering one. A password is useful when you want to restrict casual changes to the sheet’s layout or formulas, but it should not be treated as a secure way to store confidential information.

Unlock input cells before protecting a sheet

A common source of frustration is protecting a sheet and then discovering that users cannot enter data anywhere. In Excel, cells are marked as locked by default, but that setting does not restrict editing until sheet protection is turned on. To create an input area, mark the intended entry cells as unlocked before you protect the worksheet.

  1. Select the cells users should be able to edit.
  2. Press Ctrl+1 to open Format Cells, then select the Protection tab.
  3. Clear the Locked checkbox and select OK.
  4. Protect the sheet and choose appropriate permissions in the Protect Sheet dialog.

For example, if a form uses cells B3:B12 for user-entered quantities and other cells contain formulas, unlock B3:B12 before protecting the sheet. The formula cells remain locked, while the designated entry cells can still be edited if the Protect Sheet options allow users to select unlocked cells. On a Mac, Command+1 opens Format Cells; the Protection tab and the general process are similar.

Changing a password on a sheet that is already protected does not require you to unlock and relock the input cells again. Those cell settings are separate from the password. However, if you are redesigning the sheet or find that all cells are blocked, review the Locked setting and the permissions rather than repeatedly changing the password.

What worksheet protection does—and does not do

Worksheet protection is mainly a way to control editing. It can help prevent accidental changes to formulas, labels, or a carefully arranged layout. It does not encrypt the workbook, prevent someone from opening the file, or provide strong confidentiality for its contents. A person who can open the workbook may still be able to see information on the sheet, even if ordinary editing is restricted.

If the goal is to require a password before anyone can open the file, that is a different feature: workbook encryption. In Excel for Windows, the file-level option is available through File > Info > Protect Workbook > Encrypt with Password. Treat that password separately from sheet protection, and keep a secure record of it. Losing an encryption password can prevent access to the file itself; a worksheet protection password has a different role.

Workbook structure protection is another distinct setting. It is intended to restrict changes such as adding, deleting, moving, hiding, or renaming worksheet tabs. It does not serve as a replacement for protecting the cells on an individual sheet. Check which kind of protection is active before assuming that changing one password has addressed every restriction in the workbook.

Excel for the web and Mac differences

Excel for the web can work with many protected workbooks, but it does not provide the full desktop controls for adding, changing, or removing worksheet protection passwords. If you need to change a sheet password, open the workbook in the Excel desktop app, make the change there, save it, and allow the updated file to sync if it is stored online.

In Excel for Mac, use the Review tab and the sheet protection commands to remove and reapply protection. The wording and ribbon arrangement can vary with the app version, but the same basic rule applies: remove the existing protection with its password, then protect the sheet again with the replacement. If you cannot find a command, check the Review tab or Excel’s help for your installed version rather than relying on a Windows-only screenshot.

On either desktop platform, take care when editing a shared workbook. Other users may have the file open or may be working from a separate copy. Coordinate the change, save it, and verify that the intended file—not an older download—contains the new protection settings.

If you forgot the current password

The normal Excel interface does not have a forgotten-password reset for a protected worksheet. You cannot use the change procedure above without first removing protection, and removing it normally requires the current password. A password for opening an encrypted workbook is also not the same as a sheet password, so one should not be expected to unlock the other.

If you are authorized to manage the workbook, practical options include asking its creator or administrator, checking a password manager or documented handover notes, or restoring a version from before the sheet was protected. If the file is stored in OneDrive or SharePoint, available version history may help you locate an earlier copy, subject to your organization’s settings and retention policies. Keep the original file unchanged while you investigate.

Be cautious with websites and utilities that promise instant recovery or ask you to upload a workbook. A workbook may contain private business or personal information, and handing it to an unknown service creates a separate data risk. Do not use a recovery method unless you are authorized to access the file and understand how it handles the data. For important records, involve the workbook owner or your organization’s IT team.

Common problems when changing protection

  • The password is rejected: Check for typing mistakes, keyboard layout differences, and unintended spaces. Passwords are case-sensitive. If it still fails, confirm that you are changing the intended sheet and using its current password, not the password for opening the workbook or protecting its structure.
  • Unprotect Sheet is unavailable or behaves differently: Check whether the workbook is open in the desktop app and whether you selected the intended tab. A command may also be unavailable because of the current workbook state or organizational controls.
  • Users still cannot edit the cells they need: Confirm that those cells were unlocked before protection and that the permission to select unlocked cells is enabled. Changing the password alone does not alter cell locking.
  • Users can edit more than expected: Review the cells’ Locked settings and the allowed actions in Protect Sheet. Also check whether protection was reapplied to the correct worksheet after it was removed.
  • The change appears to disappear: Save the workbook, check for sync or save errors, and reopen the same file to verify it. If there are multiple copies, make sure you are not reopening an older version.

Frequently Asked Questions

Can I change an Excel sheet password without removing protection first?
No. The standard process is to unprotect the worksheet with the current password, then protect it again with the new password. Excel does not provide a direct replacement-password field while the sheet remains protected.

Does changing the sheet password change the workbook password?
No. A worksheet password controls editing on that sheet. A password required to open an encrypted file and a password used to protect workbook structure are separate settings, so changing one does not automatically change the others.

Can I protect a sheet without a password?
Yes. You can select Protect Sheet and leave the password field blank. Protection can still limit actions while it is on, but anyone may be able to remove it without supplying a password, so this is not a meaningful barrier against deliberate changes.

Can I use Excel for the web to change a sheet password?
Use the desktop Excel app for the full worksheet protection controls. Open the workbook in the desktop version, change the protection there, save it, and then confirm the updated file has synced if it is stored online.

What if I do not know the old password?
Excel does not provide a standard reset for a forgotten worksheet protection password. Ask the workbook owner, look for a documented password or an authorized earlier copy, and avoid uploading sensitive files to services you do not trust.

Does protecting a sheet hide its contents?
No. Sheet protection is intended to restrict certain edits, not to conceal information or encrypt a workbook. If you need a password to open the file, use file encryption and keep that password distinct from worksheet protection.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.