How To Remove A Password From Excel | Keep Access Simple

Excel can be “locked” in a few different ways, and that’s why people get tripped up. One workbook may demand a password just to open. Another opens fine but blocks edits unless you enter a “modify” password. Another lets you type in some cells, yet blocks sorting, inserting rows, or editing formulas because a sheet is protected.

Below, you’ll get a clear path for each lock type on Windows, Mac, and Excel for the web. You’ll also see what to do when it isn’t a password at all, like view-only sharing permissions or a file that’s locked for editing.

Know What Kind Of Password You’re Removing

Take a quick look at what Excel is doing when you open the file. The removal steps depend on where the protection lives.

Password To Open (Workbook Encryption)

This is the “hard stop” prompt before you can see anything. Excel encrypts the workbook contents, so you must enter the correct password to open it. If you do know it, removal is a few clicks once you’re inside the file.

Password To Modify (Read-Only Until You Enter It)

This one lets you open the workbook, then asks for a password when you try to edit. People often set it on shared templates so most folks can view, while only a few can change the source file.

Worksheet Protection (Limits Actions On A Tab)

A protected worksheet can still allow typing in unlocked cells, yet block edits to locked cells, formatting, sorting, filtering changes, and structural actions. Removing it restores normal editing behavior on that sheet.

Workbook Structure Protection (Locks Sheet Tabs)

This stops actions like adding, deleting, moving, renaming, or hiding sheet tabs. It can feel like the whole workbook is locked even though the file itself opens normally.

Locks That Aren’t Passwords

• Protected View: A downloaded file may open with editing disabled until you enable it.
• Sharing permissions: OneDrive/SharePoint may give you view-only access even if you know the password.
• File lock for editing: Another session may have the workbook open.
• Restricted access (IRM): Access can be controlled by account permissions, not a simple password prompt.

How To Remove A Password From Excel On Windows And Mac

If you already know the password, this is the clean path. Start by making a backup copy, then remove the protection from the correct menu, then save.

Step 1: Save A Backup Copy Before You Change Anything

Work on a duplicate first. It keeps you out of trouble if you clear the wrong setting or overwrite a shared file that others still rely on.

1. Open the workbook in Excel.
2. Go to File > Save As (Windows) or File > Save a Copy (Mac).
3. Save it with “-backup” in the name.

Step 2: Remove A Password To Open (Encrypted Workbook)

If the file required a password before it opened, you’re removing workbook encryption. You must open the file first, then clear the encryption password field.

1. Open the workbook and enter the current password.
2. Go to File > Info.
3. Select Protect Workbook, then choose Encrypt With Password.
4. Delete the password so the box is blank, then click OK.
5. Press Ctrl+S (Windows) or Cmd+S (Mac) to save.

Step 3: Remove A Password To Modify

A “modify” password is stored in save options. Clearing it stops the “enter password to write” prompt and removes the read-only gate.

1. Open the workbook. If it opens read-only, choose Edit Anyway and enter the password if prompted.
2. Go to File > Save As (Windows) or File > Save As/Save a Copy (Mac).
3. Open Tools (Windows) or Options (Mac) in the save dialog.
4. Find Password to modify and clear the field.
5. Save the file, then close and reopen it to confirm the prompt is gone.

Step 4: Remove Worksheet Protection

If you can open the workbook but can’t edit locked cells, remove protection on that sheet tab.

1. Click the protected sheet tab at the bottom.
2. Open the Review tab.
3. Select Unprotect Sheet.
4. Enter the password and click OK.
5. Save the workbook.

Do this for each protected sheet. Sheet protection is per tab, so one unlock doesn’t automatically clear the rest.

Step 5: Remove Workbook Structure Protection

If you can’t rename, move, add, or delete sheet tabs, workbook structure protection is likely turned on.

1. Go to the Review tab.
2. Select Protect Workbook. If protection is active, clicking it will switch it off.
3. Enter the password if prompted.
4. Save the workbook.

Step 6: Check For “Marked As Final” And Other Editing Blocks

Some workbooks look locked when they’re simply set to discourage edits. If you don’t see password prompts, check these common blockers:

• Protected View: click Enable Editing on the yellow bar.
• Read-only file attribute: on Windows, right-click the file, open Properties, and clear Read-only.
• Sharing mode: in OneDrive/SharePoint, confirm you’re not in view-only mode.

If you want Microsoft’s step-by-step menu path for clearing workbook passwords, their support page mirrors the same “open file, clear password, save” flow.
Change or remove workbook passwords

Removing Excel Password Protection Without Breaking Your File

Before you start clicking, match what you’re seeing to the right protection type. This keeps you from removing sheet protection when the real issue is encryption, or clearing a modify password when the file is locked by permissions.

Steps For Excel For The Web And Microsoft 365 Sharing

Excel for the web supports many protection features, yet sharing permissions often decide what you can do. If you can view the workbook but can’t see editing controls, you may be signed in with an account that lacks edit rights.

Turn Off Sheet Or Workbook Protection In The Browser

1. Open the workbook in your browser.
2. Click the protected sheet tab, or try a sheet-tab action like rename to test workbook structure lock.
3. Use the Review tab to select Unprotect Sheet or turn off workbook protection.
4. Enter the password if prompted, then let the workbook save changes.

Confirm You Have Edit Rights

If you don’t see editing options, it often isn’t a password problem. Try these checks:

• Look for a mode indicator like Viewing and switch to Editing if it’s offered.
• Confirm you’re signed into the account that owns the file or has edit rights.
• If it’s shared from a team site, ask the owner to change your permission from view to edit.

Use Version History As Your Undo Button

On OneDrive and SharePoint, version history can save you if you remove protection and then spot missing formulas, broken links, or a template that got altered. Restore an earlier version, then repeat the removal steps on a copy so the original stays intact.

If You Forgot The Password, Start With Legit Options

If you don’t know the password to open an encrypted workbook, Excel can’t read the file contents. At that point, your realistic paths are recovery and finding an earlier copy. If the workbook belongs to someone else, ask the owner for an unlocked copy or the password.

Try The Places Passwords Usually End Up

• A password manager entry labeled by file name, project name, or folder path.
• An email or chat message where the password was shared when the workbook was created.
• A notes app entry on your phone or desktop.
• A printed label on a binder, a cover sheet, or a shared internal doc.

Search For An Older Unprotected Version

Lots of files get password-protected late. Earlier drafts may still be open.

• Check OneDrive/SharePoint version history on the file.
• Check Excel’s AutoRecover location and recent-file folders.
• Check backup tools like File History (Windows) or Time Machine (Mac).
• Ask teammates for an earlier copy they saved locally.

Know The Difference Between “Sheet Protection” And “Open Password”

A forgotten sheet-protection password may still allow you to open the workbook and copy data out. A forgotten open password blocks access to the workbook content itself. That difference changes what recovery can look like in real life.

If you’re setting, changing, or removing open/modify passwords (not bypassing them), Microsoft documents where those controls live.
Require a password to open or modify a workbook

Troubleshooting When Removal Doesn’t Stick

Sometimes you clear a password, save, and the next open still asks for it. That usually means you removed the wrong protection type, saved a copy that didn’t overwrite the protected file, or reopened an older protected version from email or a shared folder.

Clean-Up Checklist After You Remove Protection

Once you’ve removed the password, do a quick reality check. It’s easy to miss a protected sheet tab or accidentally keep working in a view-only copy.

• Close the workbook, then reopen it to confirm there’s no prompt.
• Try the action that used to fail: edit a locked cell, rename a sheet, or insert a column.
• Save in XLSX unless you have a reason to change formats.
• If the file is shared, tell teammates so they don’t keep using an old password.

Set A Better Replacement If You Still Need Control

Removing a password doesn’t mean leaving the workbook wide open. You can switch to protection that matches what you’re trying to prevent.

Use A Modify Password When Viewing Is Fine

If people can view the data but only a few should edit the master file, a modify password reduces friction. Viewers can open the workbook without hitting a wall, while editors still have a gate.

Protect Only Formula Areas And Headers

Worksheet protection works well for templates and trackers. Lock formulas and labels, leave input cells unlocked, and your sheet stays tidy without blocking day-to-day data entry.

Store Passwords In A Place You’ll Actually Find Later

Use a password manager and include the workbook name and file location in the note. In a team, store it in the team’s secure vault so it doesn’t vanish into a chat thread.

Send us your feedbackTell us what you thought about this post

Name * Email *

Your comment *

Quick check — what is …? *

Send feedback