Excel Screen Lock: How to Unlock a Sheet or Unfreeze Panes

How-to basics · Updated November 20, 2026

To remove a protected-sheet lock in Excel for Microsoft 365 on Windows, open the sheet and choose Review > Unprotect Sheet; enter the password if prompted. If by “screen lock” you mean rows or columns that stay fixed while you scroll, choose View > Freeze Panes > Unfreeze Panes instead. Excel does not have one feature officially named screen lock, so first identify which behavior you want to stop.

These fixes do different things: unprotecting a sheet restores the actions restricted by its protection settings, while unfreezing panes changes how the worksheet scrolls. Neither one removes a password that encrypts the whole workbook. The steps below help you choose the right fix and handle common variations.

What You’ll Need

  • The workbook open in Excel, ideally in the desktop app if you are unsure which kind of lock is active.
  • Permission to edit the workbook. A protected sheet or workbook may require its password to remove protection.
  • If the file is stored in OneDrive or SharePoint, access to the account or folder that grants editing rights.

Step-by-Step

  1. Check what is locked. Try to identify the symptom before changing settings. If you can select cells but cannot type in certain cells, or Excel reports that the cell or chart is on a protected sheet, worksheet protection is likely on. If the first row or columns remain visible while you scroll down or sideways, frozen panes are the likely cause. If the whole file opens as read-only, shows a Protected View banner, or asks for a password before it opens, you are dealing with a different file-level restriction. Make a note of any exact message Excel displays; it can point to the right fix.
  2. Save a working copy if needed. If you have permission to edit, save a copy before changing protection or other workbook settings. In Windows Excel, use File > Save As and choose a new name or location. A copy is especially useful when a workbook is shared, contains important formulas, or has a carefully arranged view. If Save As is unavailable because you only have read access, ask the file owner for edit permission rather than trying to work around it.
  3. Remove worksheet protection in Windows Excel. Select the tab of the sheet you want to unlock. Open the Review tab and choose Unprotect Sheet. If Excel requests a password, enter the password set by the workbook owner and confirm. If it does not ask for one, the sheet should become editable immediately. Protection applies separately to each worksheet, so repeat these steps on any other protected tabs. Unprotecting a sheet does not delete its contents or formulas; it removes the restrictions set for that sheet.
  4. Use the Mac or web version if that is where you are working. In Excel for Mac, select the sheet, open Review, and choose Unprotect Sheet; provide the password if requested. In Excel for the web, look under Review for the sheet-protection controls, which can appear as Manage Protection or a similar option depending on the current interface. If you cannot find a control or the web version cannot complete the change, open the workbook in the desktop app and use Review > Unprotect Sheet. The password requirement still applies.
  5. Unfreeze rows or columns when scrolling is the issue. In Windows Excel, open View > Freeze Panes > Unfreeze Panes. In Excel for Mac, open View > Freeze Panes > Unfreeze Panes. The frozen rows and columns should stop remaining in place as you scroll. In Excel for the web, use the View tab and its Freeze Panes menu, then choose Unfreeze Panes if it is available. Unfreezing changes the display only; it does not unlock protected cells or alter worksheet data.
  6. Check workbook structure protection separately. If you cannot add, delete, move, rename, hide, or unhide sheet tabs, the workbook structure may be protected rather than an individual sheet. In Windows Excel, go to Review and select Protect Workbook to remove the structure protection, then enter its password if prompted. The control may look selected or highlighted while protection is active. Excel for Mac also has workbook-protection controls on Review, though placement can vary by release. If the command is unavailable, check whether the workbook is read-only or ask its owner for access.
  7. Confirm the change and save. Try the action that previously failed: edit a cell that should be editable, scroll to see whether frozen headers move, or rename a sheet if structure protection was the issue. Then save with Ctrl+S on Windows or Command+S on Mac. If you want protection removed for everyone who uses the file, save the workbook after unprotecting it and confirm that the saved copy is in the shared location. Otherwise, you may have changed only a local copy.

If the workbook asks for a password before it opens, do not confuse that with sheet protection. A password required to open a file is workbook encryption, which is separate from Review > Unprotect Sheet. If you know the opening password and are authorized to remove it, use File > Info > Protect Workbook > Encrypt with Password in Windows Excel, clear the password field, confirm, and save. Menu availability can vary by platform; if the encryption controls are not present in your version, use Excel for Windows or ask the file owner. Do not share a password-protected workbook through an insecure channel.

Common Mistakes

Choosing the wrong fix. Unprotect Sheet will not make frozen headings scroll, and Unfreeze Panes will not let you edit cells restricted by sheet protection. Match the remedy to what you see: blocked editing suggests protection, while fixed headings during scrolling suggest frozen panes. A file that opens read-only needs an access or file-status fix instead.

Expecting one command to unlock every sheet. Each worksheet can have its own protection setting. Removing protection from one tab does not automatically remove it from the rest. Check each relevant sheet individually, and avoid assuming the entire workbook is unlocked just because one cell is now editable.

Mixing up sheet protection and workbook structure protection. Sheet protection controls actions such as editing locked cells. Workbook structure protection controls changes to sheet tabs, such as renaming or deleting them. If you can edit cells but cannot change tabs, look at Review > Protect Workbook instead of repeatedly selecting Unprotect Sheet.

Thinking a frozen pane is a password lock. Frozen rows and columns are a viewing aid. They do not stop edits and do not mean the file is password-protected. Use Unfreeze Panes only if you want the worksheet to scroll without fixed headers.

Trying to remove protection without authorization. If you do not know the password, repeated guesses or unofficial password-removal tools can risk your data and may violate the workbook owner’s rules. Ask the creator or your organization’s administrator for the password or an authorized unlocked copy. Excel does not provide a supported way to recover a forgotten worksheet-protection password.

Tips

Before changing anything, click a cell and test a harmless action, such as typing in a blank area only if you can safely undo it. Better still, note the exact warning without editing. That helps distinguish locked cells from a read-only file or a selection restriction. A sheet can be protected while some cells remain editable, so being able to type in one place does not prove protection is off.

If you own the workbook and want to keep some cells protected while allowing edits elsewhere, do not simply remove protection permanently. First unprotect the sheet, select the cells users should be able to change, open the Format Cells dialog with Ctrl+1 on Windows or Command+1 on Mac, and use the Protection tab to clear Locked. Then protect the sheet again from Review. The Locked setting takes effect when sheet protection is turned on; by itself, it does not prevent editing. Check the protection options carefully so collaborators can still use the features they need.

For shared files, confirm whether you are editing the original or a downloaded copy. A change made to a local download will not necessarily update the OneDrive or SharePoint version. Look at the title bar or save status, make sure you have edit permission, and wait for synchronization to finish before closing the workbook. If a colleague still sees a lock, ask them to close and reopen the shared file or check whether they are viewing another copy.

On a worksheet with frozen panes, the location of the split can make the view feel unusual. Unfreeze Panes removes the current freeze arrangement; it does not delete rows or columns. You can later freeze a different area using View > Freeze Panes, but select the cell below the rows and to the right of the columns you want to keep visible before applying the setting. If you only want the top row or first column fixed, use the corresponding option in the Freeze Panes menu.

Troubleshooting

Unprotect Sheet is missing or unavailable: Confirm that a worksheet tab is selected and that you are in the desktop Excel app rather than a preview window. If the workbook is read-only, in Protected View, or opened without edit permission, some commands may not be usable. If needed, ask the owner for an editable copy. In Excel for the web, open the Review tab and look for the protection controls; using the desktop app is a practical fallback when the web interface does not expose the option.

Excel asks for a password you do not have: Stop and contact the person or team that created or manages the workbook. Check approved password records or an earlier authorized copy. If it is an organization file, your IT or document administrator may be able to locate the owner. Do not assume the password is the same as the password used to open the file; sheet, workbook-structure, and file-encryption passwords are distinct.

You still cannot type after unprotecting: Check that you unprotected the correct tab and selected the intended cell. The workbook may be in read-only mode, another user may have restricted access, or the file may be marked as final. Look at the title bar and any banners for read-only or Protected View notices. If the cell is part of a table, merged range, or another controlled area, test a different cell and ask the owner whether additional restrictions apply.

Headers remain fixed after unfreezing: Make sure you selected Unfreeze Panes from the View menu in the workbook window that is actually open. Some workbooks have multiple windows or sheets, so check the active window and repeat on the affected sheet if needed. If the display still seems split, look for a split bar under View and turn off Split; a split window is separate from frozen panes.

The workbook will not save your change: Check your edit permission, internet connection, and synchronization status. For a file on a network drive, confirm that the file is not open in a way that makes your copy read-only. Use Save As to create an authorized editable copy if appropriate, then inform collaborators which version is current. If a security policy prevents saving changes, contact the file owner or administrator rather than changing the file’s location to evade the policy.

Frequently Asked Questions

Is “screen lock” an official Excel setting?

No. People may use that phrase to mean worksheet protection, frozen panes, a read-only file, or a password prompt. Identify the symptom first, then use the corresponding control: Review for protection or View for frozen panes.

Can I unlock a protected Excel sheet without its password?

Excel does not offer a supported password-recovery method for removing worksheet protection. Ask the workbook owner for the password or an authorized unlocked copy. If you only need to view the data, ask for a version with appropriate access.

Will unprotecting a sheet delete formulas or formatting?

No. Removing sheet protection changes editing restrictions, not the sheet’s contents or formatting. Still, save a copy first if the workbook is important, and avoid editing formulas or cells you do not intend to change.

Does Unfreeze Panes unlock cells?

No. It only changes which rows or columns stay visible during scrolling. To edit restricted cells, use Review > Unprotect Sheet and provide the password if Excel requests it.

Why can I edit cells but not rename or delete a worksheet?

The workbook structure may be protected. In Windows Excel, check Review > Protect Workbook and remove that protection with the required password. Sheet protection and workbook structure protection are separate settings.

How do I remove a password required to open the workbook?

If you know the password and have permission, use File > Info > Protect Workbook > Encrypt with Password in Windows Excel, clear the password, confirm, and save. This is different from unprotecting a sheet, and the option may vary on Mac or the web.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.