Protect a worksheet - Microsoft Support
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 …
Lock or unlock specific areas of a protected worksheet
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.
Protect a workbook - Microsoft Support
To protect certain areas of the data in your worksheet from other users, you have to protect your worksheet. For more information, see Protect a worksheet. To know the difference between …
Require a password to open or modify a workbook - Microsoft …
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 …
Protection and security in Excel - Microsoft Support
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 …
Restrict changes to files in Excel - Microsoft Support
If you don't want content reviewers to accidentally change a Word document or an Excel spreadsheet, you can use formatting and editing restrictions. Note: To further restrict reviewers …
Lock cells to protect them in Excel - Microsoft Support
This means that the cells are ready to be locked when you protect the workbook or worksheet. On the Review tab in the ribbon, in the Changes group, select either Protect Sheet or Protect …
Freeze panes to lock rows and columns - Microsoft Support
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 …
Change or remove workbook passwords - Microsoft Support
To add a new password, click Protect Sheet or Protect Workbook, type and confirm the new password, and then click OK. To remove a password from the workbook, click Protect …
Split panes to lock rows or columns in separate worksheet areas
Splitting a worksheet lets you see two regions at the same time in different panes by scrolling in each pane. It freezes panes while you scroll in one of the panes.