
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.
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 …
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.
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 …
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. …
Enable or disable macros in Microsoft 365 files
This example is on an Excel workbook. Select Enable Content. In the Security Warning dialog, select Yes to make the document trusted. Macros are now enabled on this document. To …
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.
Unhide the first column or row in a worksheet - Microsoft Support
If the first row (row 1) or column (column A) is not displayed in the worksheet, it is a little tricky to unhide it because there is no easy way to select that row or column.