docs / articles / Disable Excel Screen Lock: Step-by-Step Guide

Disable Excel Screen Lock: Step-by-Step Guide

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

Ever found yourself locked out of your Excel spreadsheet, unable to access your data due to an active screen lock? It's a common issue, but it's also an easily resolvable one. In this guide, we'll walk you through the process of turning off the screen lock in Excel, ensuring you regain full control of your spreadsheets.

How To Lock Screen To Prevent Scrolling In Excel Worksheet
How To Lock Screen To Prevent Scrolling In Excel Worksheet

Before we dive into the steps, let's briefly understand what the screen lock feature in Excel does. It's a security measure that prevents unauthorized access to your workbook. However, it can sometimes be a hindrance when you need to make changes quickly or forgot the password. So, let's learn how to disable it.

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

Understanding Screen Lock in Excel

Excel's screen lock feature is part of its protection settings. It's designed to prevent others from opening, modifying, or copying your workbook without your permission. When enabled, a password prompt appears whenever someone tries to open the file, and certain actions like copying or modifying data are restricted.

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

Now that we understand the purpose of screen lock let's explore how to turn it off.

Turning Off Screen Lock for Opening the Workbook

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

If you've set a password to open your workbook, you can remove it to disable the screen lock. Here's how:

1. Right-click on the workbook and select "Info" (or press 'Alt + Enter').

2. Under "Protection", click on "Encrypt with Password".

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

3. In the 'Password' field, delete the existing password and leave the 'Confirm password' field empty.

4. Click 'OK'. The workbook will now open without a password prompt.

Removing Protection from Worksheet

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

If you've protected your worksheet to prevent modifications, you can remove this protection to disable the screen lock. Here's how:

1. Click on the "Review" tab in the Excel ribbon.

🔐 How to Lock Cells in Excel
🔐 How to Lock 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
How to lock or protect certain cells in Excel
How to lock or protect certain cells in Excel
How to turn off the lock screen on your PC
How to turn off the lock screen on your PC
Lock Image with a Cell in Excel
Lock Image with a Cell in Excel
How to Change The Lock Screen Picture - Windows 10
How to Change The Lock Screen Picture - Windows 10
Unleashing Potential Locked cells in Excel | Vocab Computer Education
Unleashing Potential Locked cells in Excel | Vocab Computer Education
an image of a computer screen with the text x lookup in excel
an image of a computer screen with the text x lookup in excel
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 remove an image background in Excel. 🤯
How to remove an image background in Excel. 🤯
How to Lock Excel Sheets & Workbook (Protect Data Fast)
How to Lock Excel Sheets & Workbook (Protect Data Fast)
Delete Blank Cells
Delete Blank Cells
the instructions for how to use excel arrow keys
the instructions for how to use excel arrow keys
Must Know
Must Know
🧮 Quick Excel Wizardry
🧮 Quick Excel Wizardry
a woman in glasses is looking at her computer screen while she looks at the data
a woman in glasses is looking at her computer screen while she looks at the data
a computer screen with the words don't remove blank rows manual
a computer screen with the words don't remove blank rows manual
a computer screen with the text ctrl + g on it
a computer screen with the text ctrl + g on it
How to lock and protect formulas in Excel?
How to lock and protect formulas in Excel?
How to VLOOKUP to the Left in Excel
How to VLOOKUP to the Left in Excel

2. In the "Changes" group, click on "Unprotect Sheet".

3. If prompted, enter the password you used to protect the sheet and click 'OK'.

4. The worksheet is now unprotected, and the screen lock is disabled.

Turning Off Screen Lock for Shared Workbooks

If you're working with shared workbooks, the screen lock might be causing issues. Here's how to turn it off:

1. Open the shared workbook.

2. Click on the "Review" tab in the Excel ribbon.

3. In the "Changes" group, click on "Unprotect Shared Workbook".

4. Enter the password (if any) and click 'OK'. The screen lock is now disabled for the shared workbook.

Preventing Automatic Screen Lock

By default, Excel automatically locks sheets when you close and reopen a workbook. You can prevent this by following these steps:

1. Click on the "File" tab and select "Options".

2. In the "Excel Options" dialog box, click on "Save".

3. Under "Save workbooks", uncheck the box next to "Save external reference and list objects with the workbook".

4. Click 'OK'. Excel will no longer automatically lock sheets when you close and reopen a workbook.

And there you have it! You've now learned how to turn off screen lock in Excel, ensuring you can access and modify your spreadsheets without any hindrance. Happy spreadsheeting!