
Lock or unlock specific areas of a protected worksheet
To enable some cell editing, while leaving other cells locked, it's possible to unlock all the cells. You can lock only specific cells and ranges before you protect the worksheet and, optionally, …
Excel file is locked for editing - Microsoft Support
Find out how you can unlock an Excel spreadsheet when you are locked out of an Excel file by yourself or by another user.
Change or remove workbook passwords - Microsoft Support
You cannot open a workbook or document that has been password protected in the Windows-based version of Excel or Word if the password is longer than fifteen characters.
Protect a worksheet - Microsoft Support
Worksheet protection is a two-step process: the first step is to unlock cells that others can edit, and then you can protect the worksheet with or without a password.
Unlock a file that has been locked for editing - Microsoft Support
When you try to open a Excel workbook, PowerPoint presentation, or Word document on your mobile device, you might receive a message stating that the file is locked for editing by …
Unfreeze locked panes - Microsoft Support
If you scroll down your worksheet but always see the same top rows, they're locked in place (frozen). Use the Unfreeze Panes command to unlock those rows.
Set or clear read-only status - Microsoft Support
You can lock a file to make it read-only and prevent it from being accidentally deleted. Lock or unlock a workbook to make it read-only Note: If your workbook is shared, anyone who has …
You are unable to select unprotected cells in Excel
Describe an issue that you are unable to select unprotected cells in Excel. A workaround is provided.
Lock cells to protect them in Excel - Microsoft Support
See Protect a worksheet or Protect a workbook. Tip: It's a best practice to unlock any cells that you may want to change before you protect a worksheet or a workbook, but you can also …
Turn off Scroll Lock - Microsoft Support
To determine if this is the case, right-click the Excel status bar. Look for the check box to the left of the Scroll Lock. If a check is not visible, Scroll Lock does not appear in the Excel status bar. …