Method: First open the protected excel sheet; then click "Review", then click "Unprotect Worksheet"; then enter the password when setting the "Protect Worksheet" and click "OK" .
Method:
When you want to edit the document, just unprotect the worksheet. Similar to the operation when setting a protected worksheet, open the excel document to be edited, select Review, and you can see that the original "Protect Worksheet" tool has changed to the "Unprotect Worksheet" tool
Click the "Unprotect Worksheet" button, the "Unprotect Worksheet" dialog box will pop up, enter the password when setting the "Protect Worksheet" in the edit box, and then click "OK" "Button
Return to the excel worksheet editing area and find that you can edit the document
Recommended tutorial: "excel tutorial》
The above is the detailed content of How to modify the protected excel table?. For more information, please follow other related articles on the PHP Chinese website!