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.

If you want to lock cells or protect specific areas in Excel for the web, select Open in Excel and lock cells to protect them or lock or unlock specific areas of a protected worksheet.

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.

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 the cells, …

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 …

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

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 …

Make cells display the formulas they contain, instead of the formula results. Protect cells so that formulas cannot be displayed or changed.

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.

Lock specific rows or columns in place by freezing panes, so you can scroll through an Excel spreadsheet and still see the top row or left column. You can freeze just the top row and first column …