
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 …
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 …
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.
Protection and security in Excel - Microsoft Support
To control how users should work within an individual worksheet, use worksheet-level protection. Let’s say each worksheet in your status report workbook contains data that is common to all …
Protect an Excel file - Microsoft Support
How to protect an Excel file using a password to prevent unwanted access to your data.
Require a password to open or modify a workbook
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 …
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
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.
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 …
Protect controls and linked cells on a worksheet
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.