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.

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 then click OK.

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

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

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 Write privileges …

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 revoke a trusted …

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 unlock them after …