docs / articles / How to Remove Lock in Excel

How to Remove Lock in Excel

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

Ever found yourself locked out of an Excel workbook or worksheet, unable to make changes or access certain features? You're not alone. Excel's protection features can sometimes cause unintended lockouts. But fear not, unlocking your Excel file is a straightforward process. Let's delve into how to remove a lock in Excel, ensuring you regain full control over your workbooks and worksheets.

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

Before we dive into the steps, it's crucial to understand that Excel locks are primarily used to protect specific cells, ranges, or entire worksheets from being modified. This is often done to maintain data integrity or prevent accidental edits. However, these locks can sometimes be applied unintentionally or by another user, leading to access issues.

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

Unlocking an Entire Workbook or Worksheet

If you're locked out of an entire workbook or worksheet, you can use the Unprotect option to remove the lock. This method works best when you know the password (if one was set).

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

Here's how to do it:

Using the Unprotect Option

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

1. Open the protected workbook or worksheet. Excel will prompt you to enter the password if one is set.

2. If you know the password, enter it and click 'OK'. If you don't know the password, proceed to the next sub-topic.

Removing the Lock Without the Password

How to remove scroll lock in excel | unlock scroll lock in excel | windows 10 | Universal Thamizhan
How to remove scroll lock in excel | unlock scroll lock in excel | windows 10 | Universal Thamizhan

If you've forgotten the password or it was never set, you can still remove the lock using a simple trick. This method involves removing the protection by saving the file in a different format.

1. Open the protected workbook or worksheet.

2. Click on 'File' in the top-left corner, then select 'Save As'.

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

3. In the 'Save As' dialog box, choose a different file format, such as 'Excel Macro-Enabled Workbook (*.xlsm)' or 'Excel Binary Workbook (*.xlsb)'.

4. Click 'Save'. Excel will remove the protection, and you'll be able to access and modify the workbook or worksheet.

How to LOCK (Protect) Cells in Excel - An Easy Step-by-Step Guide
How to LOCK (Protect) Cells in Excel - An Easy Step-by-Step Guide
How to lock and protect formulas in Excel?
How to lock and protect formulas in Excel?
How to Remove Blank Rows in Excel the Easy Way
How to Remove Blank Rows in Excel the Easy Way
How To Lock Screen To Prevent Scrolling In Excel Worksheet
How To Lock Screen To Prevent Scrolling In Excel Worksheet
How to Remove Password from Excel
How to Remove Password from Excel
How to Remove Space in Excel
How to Remove Space in Excel
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 Lock a Cell in Excel
How to Lock a Cell in Excel
Free add-in "Excel Password Remover 2008" to release password protected Excel sheet
Free add-in "Excel Password Remover 2008" to release password protected Excel sheet
How to lock and protect formulas in Excel?
How to lock and protect formulas in Excel?
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
How to lock or protect certain cells in Excel
How to lock or protect certain cells in Excel
How to LOCK (Protect) Cells in Excel - An Easy Step-by-Step Guide
How to LOCK (Protect) Cells in Excel - An Easy Step-by-Step Guide
Lock Cells that have Formulas in Excel (Easy Steps)
Lock Cells that have Formulas in Excel (Easy Steps)
Advance Excel! How To Remove Surname in Excel Data #exceltutorial #shortvideo #yutubeshorts #tech
Advance Excel! How To Remove Surname in Excel Data #exceltutorial #shortvideo #yutubeshorts #tech
the excel tip shows how to remove borders in microsoft's office window, and then select
the excel tip shows how to remove borders in microsoft's office window, and then select
How to Instantly Remove Checkboxes in Excel - itโ€™s Super Easy ๐Ÿ˜
How to Instantly Remove Checkboxes in Excel - itโ€™s Super Easy ๐Ÿ˜
Delete Blank Cells
Delete Blank Cells
How to Properly Delete Blank Rows in Excel - AbsentData
How to Properly Delete Blank Rows in Excel - AbsentData
Create or Remove Hyperlinks in Excel
Create or Remove Hyperlinks in Excel

Unlocking Specific Cells or Ranges

If only certain cells or ranges are locked, you can unlock them individually. This is useful when you want to maintain protection for other parts of the workbook or worksheet.

Here's how to unlock specific cells or ranges:

Using the Format Cells Dialog Box

1. Select the locked cells or ranges you want to unlock.

2. Right-click on the selection and choose 'Format Cells' from the context menu.

3. In the 'Format Cells' dialog box, go to the 'Protection' tab.

4. Uncheck the 'Locked' box and click 'OK'. The selected cells or ranges will now be unlocked.

Using the Unprotect Sheet Option

If you want to unlock an entire worksheet but keep some cells locked, you can use the 'Unprotect Sheet' option. Here's how:

1. Right-click on the worksheet tab at the bottom of the screen and choose 'View Code' from the context menu.

2. In the Visual Basic for Applications (VBA) window that appears, click on 'Insert' in the menu, then select 'Module'.

3. In the module, type the following code and press 'Enter':

Sheets("YourSheetName").Unprotect

Replace "YourSheetName" with the name of your worksheet.

4. Close the VBA window and save the workbook. The entire worksheet will now be unlocked, but any cells you previously unlocked using the 'Format Cells' dialog box will remain unlocked.

Remember, unlocking your Excel file can make it more susceptible to accidental edits or malicious changes. Always ensure you have a backup of your data before making changes, and consider reapplying protection once you've made the necessary edits.

Now that you know how to remove a lock in Excel, you can regain control of your workbooks and worksheets with ease. Happy unlocking!