By default, protecting a worksheet locks all cells so none of them are editable. To enable some cell editing, while leaving other cells locked, it's possible to unlock all the cells.

Find out how you can unlock an Excel spreadsheet when you are locked out of an Excel file by yourself or by another user.

Clicking Unprotect Sheet automatically removes the password from the sheet. To add a new password, click Protect Sheet or Protect Workbook, type and confirm the new password, and …

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 …

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.

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.

If you suspect that Scroll Lock is turned on, but Scroll Lock does not appear in the Excel status bar, it may be because the status bar is customized to hide the Scroll Lock status.

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 …

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 can hide any worksheet to remove it from view. The data in hidden worksheets is not visible, but it can still be referenced from other worksheets and workbooks, and you can easily unhide …