How to Remove Password Protection in Excel - Practical Guide

Learn how to remove password protection from Excel worksheets and workbooks to regain full editing access. This essential skill helps you unlock protected sheets when you've forgotten passwords, inherited locked files, or need to modify restricted content. You'll discover multiple methods to disable protection quickly and efficiently.

Why This Matters

Removing password protection is critical for productivity when working with inherited files or forgotten credentials. It ensures you maintain control over your spreadsheet assets without being blocked by restrictive security settings.

Prerequisites

•Access to the password-protected Excel file
•Basic Excel navigation and menu familiarity
•Administrator or file ownership status

Step-by-Step Instructions

Open the Protected Workbook

Launch Excel and open the password-protected file using File > Open. The file will open normally; protection only restricts specific editing actions.

Access the Review Tab

Click the Review tab in the ribbon menu at the top of the screen to locate protection-related options.

Click Unprotect Sheet

In the Review tab, click 'Unprotect Sheet' (for worksheet protection) or 'Unprotect Workbook' (for workbook protection) in the Protect group.

Enter Password if Prompted

If a password dialog appears, enter the password and click OK. If you don't know the password, proceed to alternative methods.

Verify Protection Removal

Confirm the sheet is unprotected by attempting to edit restricted cells; the button should now show 'Protect Sheet' instead of 'Unprotect Sheet'.

Alternative Methods

Save as XML and Edit Protection Tags

Save the workbook as .xlsx, extract it as a ZIP file, locate the sheet protection tags in the XML files, remove them, and repackage the file. This bypasses password requirements entirely.

Use VBA Macro to Remove Protection

Create a macro with VBA code that automatically removes sheet or workbook protection without prompting for a password. This works when you have macro execution enabled.

Copy Data to New Workbook

Select all unprotected data and copy it to a new Excel workbook, avoiding protection entirely while preserving your content.

Tips & Tricks

✓Always keep backups of important files before attempting to remove protection.
✓Document password information in a secure password manager to prevent future lockouts.
✓Test unprotection on a copy first to avoid accidentally modifying the original file.
✓Check with file owners before removing protection from shared or organizational files.

Pro Tips

★Sheet protection in Excel (without open password) is relatively weak; the XML method bypasses it in seconds for unencrypted workbooks.
★Use Workbook Protection (Review > Protect Workbook) to prevent users from unprotecting sheets, which is stronger than sheet-level protection.
★Combine protection removal with setting new passwords immediately to maintain security without losing access.

Troubleshooting

Password is unknown or forgotten

Use the XML extraction method: save as .xlsx, extract with WinRAR or 7-Zip, delete protection tags from xl/worksheets/sheet1.xml, repackage and rename back to .xlsx. This only works for sheet protection, not encrypted workbooks.

Unprotect option is grayed out

The file may have workbook-level protection instead of sheet protection. Try Review > Unprotect Workbook, or the sheet may be read-only—check file properties (right-click > Properties > uncheck Read-only).

Protection reappears after saving

Ensure you're saving to a new file with File > Save As to prevent automatic protection reapplication. If using Office 365, cloud sync may restore protection; save locally instead.

Frequently Asked Questions

Can I remove password protection without knowing the password?

Yes, using the XML extraction method. Extract the .xlsx file as a ZIP, locate and delete protection tags from the XML files, then repackage. This works for sheet protection but not for encrypted workbooks with open passwords.

What's the difference between sheet protection and workbook protection?

Sheet protection prevents editing within a specific worksheet (cells, formulas, formatting). Workbook protection prevents structural changes (adding/deleting sheets, unhiding sheets). You must use the corresponding unprotect option for each.

Is removing protection legal?

Yes, if you own the file or have permission from the owner. Removing protection from files you don't own without authorization may violate copyright or organizational policies. Always verify ownership and permissions first.

Will removing protection affect my data?

No, removing protection only affects access restrictions, not the actual data. Your formulas, values, and formatting remain unchanged and safe.

Can I see who protected the sheet?

Excel doesn't record who created the protection. You can only see that protection exists in the Review tab; the originator must be confirmed through file metadata or communication.