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.

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 close the …

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 close the …

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

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

In Excel, you can select cell contents of one or more cells, rows and columns. Note: If a worksheet has been protected, you might not be able to select cells or their contents on a worksheet.

When you prevent a user from selecting locked cells in a protected Microsoft Excel worksheet, the user may now be unable to select any cells within ranges that you set up to allow users to edit.