docs / articles / How to Remove Key Lock in Excel

How to Remove Key Lock in Excel

Sara Jul 09, 2026 2026-07-09 04:40:45

Ever found yourself locked out of your Excel workbook due to a forgotten password? Don't worry, you're not alone. Excel's key lock feature is a great security measure, but it can sometimes be a hassle when you've forgotten the password. In this guide, we'll explore how to remove the key lock in Excel, ensuring you regain access to your vital data.

How to Fix Arrow Keys Scrolling in Excel
How to Fix Arrow Keys Scrolling in Excel

Before we dive into the process, it's essential to understand that Excel doesn't provide a built-in feature to remove the key lock without knowing the password. However, there are workarounds that can help you bypass this issue. Let's explore these methods.

How to lock some cell with password in excel | Excel Tips and Tricks #05
How to lock some cell with password in excel | Excel Tips and Tricks #05

Using the Open and Repair Feature

The Open and Repair feature is a built-in Excel tool that can help you remove the key lock in certain cases. It's worth trying this method first as it's the simplest and most straightforward.

How to lock, hide cells and protect worksheet in Excel
How to lock, hide cells and protect worksheet in Excel

Here's how to use it:

Step 1: Open the workbook in Safe Mode

How to Lock Cells in Excel: A Step-by-Step Guide | MyExcelOnline
How to Lock Cells in Excel: A Step-by-Step Guide | MyExcelOnline

Press and hold the Alt key while opening the workbook. This will open Excel in Safe Mode, which bypasses some security features.

If the workbook opens in Safe Mode, proceed to the next step. If not, move on to the next method.

Step 2: Repair the workbook

How to unlock Excel spreadsheets without a Password
How to unlock Excel spreadsheets without a Password

Once the workbook is open, click on File, then Info, and select 'Open and Repair'. Choose 'Repair' and click OK. This should remove the key lock from your workbook.

Using Third-Party Software

If the Open and Repair feature doesn't work, you'll need to use third-party software to remove the key lock. There are several tools available online, both free and paid, that can help you unlock your Excel workbook. Some popular options include Excel Password Recovery Master and PassFab for Excel.

Excel Keyboard Shortcuts Every Office User Should Know
Excel Keyboard Shortcuts Every Office User Should Know

Here's a general step-by-step guide on how to use these tools:

Step 1: Download and install the software

How to Fix Unknown Error Trying to Lock File in Excel - MiniTool
How to Fix Unknown Error Trying to Lock File in Excel - MiniTool
How to Remove Blank Rows in Excel the Easy Way
How to Remove Blank Rows in Excel the Easy Way
Excel shortcut keys
Excel shortcut keys
How To Lock Screen To Prevent Scrolling In Excel Worksheet
How To Lock Screen To Prevent Scrolling In Excel Worksheet
Computer tricks😉
Computer tricks😉
How to Remove Passwords from Microsoft Office Files Tutorial
How to Remove Passwords from Microsoft Office Files Tutorial
Raj Excel
Raj Excel
How to hide errors with a few keys. #cleancode #artificialintelligenceai #ccna #excelonline.
How to hide errors with a few keys. #cleancode #artificialintelligenceai #ccna #excelonline.
How to lock and protect formulas in Excel?
How to lock and protect formulas in Excel?
Microsoft Excel Shortcut key
Microsoft Excel Shortcut key
Replace Blanks in Excel‼️ #excel
Replace Blanks in Excel‼️ #excel
Delete Blank Cells
Delete Blank Cells
How to Instantly Remove Checkboxes in Excel - it’s Super Easy 😍
How to Instantly Remove Checkboxes in Excel - it’s Super Easy 😍
How to Remove Empty Rows in Excel - Excel tips and tricks for Beginners
How to Remove Empty Rows in Excel - Excel tips and tricks for Beginners
Create or Remove Hyperlinks in Excel
Create or Remove Hyperlinks in Excel
an image with the text excel lock specific cells protect cells from editing
an image with the text excel lock specific cells protect cells from editing
Remove formula but keep the values or numbers or results in #Excel
Remove formula but keep the values or numbers or results in #Excel
an excel shortcut key is shown in green and white
an excel shortcut key is shown in green and white
Work Smarter, not harder with Excel
Work Smarter, not harder with Excel
How to Lock Excel Sheets & Workbook (Protect Data Fast)
How to Lock Excel Sheets & Workbook (Protect Data Fast)

Choose a reputable third-party software and download it onto your computer. Follow the installation instructions to set it up.

Once installed, open the software and select the Excel file you want to unlock.

Step 2: Remove the key lock

Follow the on-screen instructions to remove the key lock. This usually involves selecting the type of protection (in this case, a key lock) and clicking 'Remove' or 'Unlock'.

The process may take some time, depending on the complexity of the password and the software's capabilities.

Remember, using third-party software comes with its own risks. Always download software from trusted sources and ensure you understand the terms and conditions before using it.

Regaining access to your Excel workbook can be a relief, but it's important to learn from this experience. Make sure to keep a record of your passwords and consider using more secure methods to protect your workbooks in the future.

Now that you know how to remove the key lock in Excel, you can confidently tackle this issue should it arise again. Happy Excel-ing!