How to protect Excel documents

Method One, set permissions password for workbook

Set the permissions password for the workbook to be manipulated by restricting other users from opening or modifying the workbook as follows:

Step one, select the workbook that you want to set permissions on, and on the File tab, click Save (for the new workbook) or Save As button. Open the Save As dialog box, where you click the Tools button and select General Options from the Drop-down menu that pops up. As shown in the figure:

Computer Tutorials

In step two, open the General Options dialog box, enter the password to open and modify the workbook separately in the password to open and password to modify text boxes in the File Sharing column, and click OK, as shown in the figure.

In step three, enter the password for open permission again in the Open Confirm Password dialog box, click OK, and then in the Open Confirm Password dialog box, enter a password to modify the permission, and then click OK, as shown in the figure. Return to the Save As dialog box and click the Save button to complete the operation.

In addition, if you only need to set open permissions, you can also click the Protect Workbook button in the info interface of the File tab, select the Encrypt with password command in the pop-up Drop-down menu, and set the open password for the workbook in the Open dialog box as shown in the picture.

Method Two, use the signature line to protect work thin

If you don't want others to modify the data in the workbook, but do not want to protect the workbook and worksheet methods to achieve the goal. You can protect an Excel workbook by adding and signing a document signature line, which is done as follows:

Step one, open the workbook that you want to set protection for, and click the Insert tab, click the Drop-down button under the Signature line button in the Text group, select the Microsoft office Signature Line command from the pop-up Drop-down menu, and then click OK in the prompt dialog box that opens.

Step two, enter the information in the appropriate text box in the Signature Settings dialog box, as shown in the figure, and click OK to add the document signature line to the appropriate location on the worksheet.

Step three, double-click the signature line, and click the OK button in the Open dialog box. Open the Signature dialog box, enter a name in its text box, or insert a picture as a signature, click the signature button when you are done, and then in the Open Signature Confirmation dialog box, prompt for the signature to be successfully added, and click OK, as shown in the figure.

Step four, the status bar in the lower-left corner of the Excel window, displays the "This document contains signatures" flag, indicating that the document is signed, and the workbook is displayed as read-only with "Mark as final", as shown in the figure. Most buttons in the Ribbon and Quick Access Toolbar will be grayed out to protect the document.

Method Three, use the signature to protect work thin

The signature line is displayed in the workbook, and if you do not want the signature line to appear in the workbook but still want to ensure authenticity, integrity, and the source of the workbook, you can add an invisible digital signature to the workbook with the following actions:

Step one, on the File tab, click the Info tab, click the Protect Workbook button in its interface, select the Add digital Signature command in the pop-up Drop-down menu, and as shown, the prompt dialog box appears, and the OK button is clicked.

Skill: operation of unsaved workbooks

If the current workbook is not saved, after you click OK in the prompt dialog box, the prompt dialog box prompts you to save the workbook in a format that supports digital signatures before you add the signature, click Yes, enter the file name in the Save As dialog box that opens, and click Save button to save the workbook as a Microsoft Office Excel workbook.

Step two, open the Signature dialog box, as shown in the illustration, if you want to describe the purpose of signing the document, enter the appropriate information in the "Purpose of signing this document" text box, click the Signature button, and click OK in the Open Signature Confirmation dialog box. The button completes the addition of the digital signature that is not visible.