How to lock cells in Excel to protect your data. You can also unlock a range of cells and grant permissions to others to edit.

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

Use your mobile device to unlock or edit a file that another user has locked for editing.

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 …

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.

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. …

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 …

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.

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 …

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.