How to Remove Excel Sheet Password Without Any Software

Overview

This tutorial teaches how to remove a forgotten worksheet protection password from a Microsoft Excel file without purchasing third-party software. The process relies on the OpenXML architecture used by modern Excel workbooks (.xlsx and .xlsm), which are compressed archive packages containing XML definitions of workbook sheets and structure. The procedure begins by backing up the original file, enabling Windows File Explorer file name extensions, and changing the workbook's file extension to .zip. Once extracted, the individual worksheet XML file corresponding to the locked sheet is opened in a basic text editor such as Notepad. By locating and deleting the XML tag associated with sheet protection, the worksheet restrictions are eliminated. Finally, the archive contents are recompressed into a standard zip folder and renamed back to the original Excel extension (.xlsm or .xlsx). Opening the modified file confirms that sheet protection has been removed, restoring full cell editing capabilities.

Understanding Sheet Protection and Preparing a Backup

00:00

When an Excel worksheet is protected with an unknown password, attempts to modify cells trigger a notification that the sheet is read-only. Unprotecting through the Review tab requires entering the exact password. To safely resolve this issue, always create a duplicate copy of the target Excel workbook (.xlsx or .xlsm) on your desktop before modifying any internal files.

• Sheet protection prevents cell edits until unprotected.
• Third-party paid tools are unnecessary due to Excel's native zip/XML structure.
• Always create a backup copy to prevent data loss in case of syntax mistakes.

Ctrl + C
Ctrl + V

Enabling File Extensions and Converting to ZIP Archive

00:46

Windows hides file extensions by default. Open File Explorer, select the 'View' tab, and check the 'File name extensions' box. Next, rename the target Excel file extension from .xlsm (or .xlsx) to .zip. Accept the Windows confirmation warning prompt regarding changing file extensions. Right-click the newly renamed .zip file and extract its contents to a folder on your desktop.

• Windows File Explorer > View > File name extensions must be checked.
• Change the extension from .xlsm/.xlsx to .zip.
• Extract the compressed archive to reveal internal package folders.

Rename .xlsm -> .zip
Extract All...

Editing the Worksheet XML File in Notepad

02:16

Navigate into the extracted folder, enter the 'xl' subdirectory, and open the 'worksheets' folder. Identify which sheet corresponds to the locked tab (for example, sheet1.xml). Right-click sheet1.xml and select 'Open with' > 'Notepad'. Press Ctrl + F to open the Find dialog, enter 'protection', and adjust direction (Up/Down) if necessary. Locate the entire <sheetProtection ... /> XML node, select it completely from opening bracket '<' to closing bracket '>', delete it, and save the document (Ctrl + S).

• Target sheet definitions reside under xl/worksheets/sheetN.xml.
• Use Notepad or any plain text editor to search for 'protection'.
• Delete the entire <sheetProtection ... /> tag without altering surrounding XML tags.
• Save and close the XML file.

Ctrl + F
Ctrl + S

Recompressing the Archive and Restoring the Excel Extension

05:04

Return to the root extracted folder containing '_rels', 'docProps', 'xl', and '[Content_Types].xml'. Select all four items, right-click, and choose 'Send to' > 'Compressed (zipped) folder'. Name the new zip file. Once created, rename its extension from .zip back to .xlsm (or .xlsx) and confirm the Windows file extension prompt. Open the file in Excel to verify that the sheet is fully editable and unprotected under the Review tab.

• Select the root internal contents (_rels, docProps, xl, [Content_Types].xml), not the outer folder.
• Compress the selected items into a new .zip file.
• Rename the .zip extension back to .xlsm or .xlsx.
• Verify in Excel under the Review tab that the sheet is unlocked.

Send to > Compressed (zipped) folder
Rename .zip -> .xlsm