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.

To prevent other users from accidentally or deliberately changing, moving, or deleting data in a worksheet, you can lock the cells on your Excel worksheet and then protect the sheet with a …

On the Home tab, in the Alignment group, select the Alignment Settings arrow to open the Format Cells popup window. On the Protection tab, select the Locked check box, and then select OK …

To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can …

You can use formatting and editing restrictions to prevent content reviewers from accidentally changing an Excel spreadsheet.

Once sheet protection is enabled, you can protect other elements such as cells, ranges, formulas, and ActiveX or Form controls. For more information on protecting worksheets, see Protect a …

To prevent a user from accidentally or deliberately changing, moving, or deleting important data, you can lock cells and protect them. Locking cells takes two steps: adding the Lock formatting …

To prevent other users from accidentally or deliberately changing, moving, or deleting data in a worksheet, you can lock the cells on your Excel worksheet and then protect the sheet with a …

To prevent users from changing the protections on the cells and controls that you have set, protect both the worksheet and the workbook. For more information, see Protect a workbook.

To lock your file so that other users can't open it, see Protect an Excel file. To protect certain areas of the data in your worksheet from other users, you have to protect your worksheet.