Protect | search
Click here to view Protect news from 60+ newspapers.
Bookmark or Share- Protect a worksheet - Microsoft SupportWorksheet protection is a two-step process: the first step is to unlock cells that others can edit, and then you can protect the worksheet with or without a password. Step 1: Unlock any cells that needs to be editable. In your Excel file, select the worksheet tab that you want to protect.
- Display or hide formulas - Microsoft SupportOn the Protection tab, clear the Hidden check box. Make cells display the formulas they contain, instead of the formula results. Protect cells so that formulas cannot be displayed or changed.
- Lock or unlock specific areas of a protected worksheetFollow these steps: If the worksheet is protected, do the following: On the Review tab, select Unprotect Sheet (in the Protect group). Select Protect Sheet to change to Unprotect Sheet when a worksheet is protected. If prompted, enter the password to unprotect the worksheet.
- Protect a workbook - Microsoft SupportProtect a worksheet. Collaborate on Excel workbooks at the same time with co-authoring. Add a password to protect your entire workbook and control whether others can open or make changes to it. Protect your file by setting passwords for Open and Modify.
- Video: Restrict changes to files - Microsoft SupportEncrypt documents with a password. Open the document that you want to password protect. Select File > Info. Select Protect Document > Encrypt with Password. Note: In Excel, select Protect Workbook. In PowerPoint, select Protect Presentation. Enter a password, and select OK. Re-enter the password, and select OK.
More
