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

You can lock only specific cells and ranges before you protect the worksheet and, optionally, enable specific users to edit only in specific ranges of a protected sheet.

How to protect an Excel file using a password to prevent unwanted access to your data.

Open the sheet or workbook that you want to protect. On the Review tab, click Protect Sheet or Protect Workbook. In the Password box, type a password, and in the Verify box, type the password again. …

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.

You can protect the Excel file by specifying two passwords: one to open, and the other to modify. You can later share the appropriate passwords with the team depending on the access they should be …

On the Review tab in the ribbon, in the Changes group, select either Protect Sheet or Protect Workbook, and then reapply protection. See Protect a worksheet or Protect a workbook.

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

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. Need more help? …

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 Split panes …