How to Protect Excel Formulas and Use a Digital Signature in WPS Office Spreadsheets
Question details
The user wants to lock and hide Excel formula cells so they cannot be viewed or edited, then apply a digital signature to verify the workbook's integrity after all edits are complete.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- Preparing an Excel-compatible workbook with sensitive formulas for protected sharing and signed distribution.
- Observed behavior
- Formula cells are currently visible or editable, and the workbook lacks a valid digital signature because the signing workflow is planned after edits.
Make sure all workbook edits are complete before applying the digital signature, because changes after signing can invalidate it. Identify the formula cells you want to protect so you can select them before opening the Format Cells dialog.
Hide and Lock Formula Cells Before Protecting the Worksheet
Use this when you want to prevent users from viewing or editing formulas in a WPS Office spreadsheet while allowing other cells to be used normally.
Worksheet protection only takes effect after the sheet is protected. Cells marked as Locked and Hidden will not show their formulas in the formula bar while protection is active.
Open the workbook in WPS Office Spreadsheets, then select all formula cells. Press Ctrl+G, click Special, choose Formulas, and click OK to select every formula at once.
Right-click the selected cells and choose Format Cells, or press Ctrl+1. In the Format Cells dialog, open the Protection tab, check Locked and Hidden, and click OK.
Go to the Review tab and click Protect Sheet. Enter a password, confirm it, choose the actions you want to allow for other users, and click OK.
Click a protected formula cell and check the formula bar. The formula should stay hidden, and editing should be blocked until the sheet is unprotected.
Apply a Digital Signature After Completing All Edits
Use this after the workbook is finalized and the formulas are protected, so the signature remains valid and verifies the file has not been changed.
Protect Formulas and Sign Workbooks in WPS Office Spreadsheets
You can hide and lock formula cells, protect the worksheet with a password, and add a digital signature to the completed workbook directly in WPS Office Spreadsheets.
- 1. Open your Excel workbook: Launch WPS Office, click Spreadsheets, and open the .xlsx file that contains the formulas you want to protect.
- 2. Lock and hide formula cells: Select the formula cells, right-click, choose Format Cells > Protection, and enable Locked and Hidden.
- 3. Protect the worksheet: Go to the Review tab, click Protect Sheet, set a password, and click OK.
- 4. Finalize and sign the workbook: After all edits, go to File > Info > Protect Workbook and choose Add a Digital Signature to sign the completed file.
- 5. Save and share the signed workbook: Save the workbook in WPS Office Spreadsheets format or Excel .xlsx format and share it with confidence.
Frequently Asked Questions
Will worksheet protection hide my formulas completely?
Yes, if you enable both Locked and Hidden on the formula cells and then protect the worksheet. The formula bar will not show the formula, and users cannot edit the cell without unprotecting the sheet.
Why does my digital signature become invalid after I change the workbook?
A digital signature verifies that the file has not changed since signing. After you edit or save the signed workbook, WPS Office or Excel may remove or invalidate the signature. Apply the signature after all edits are complete.
Can I apply a digital signature before protecting formulas?
It is better to protect formulas and complete every edit first. If you sign first and then make changes, the signature can become invalid, so sign only after the worksheet protection is finalized.
What is the difference between worksheet protection and a digital signature?
Worksheet protection controls which cells can be edited and whether formulas are visible. A digital signature confirms the file's authenticity and integrity but does not hide formulas or restrict editing by itself.
Do I need a digital certificate to sign a WPS Office spreadsheet?
Yes, you normally need a digital certificate from a certificate authority or your organization. If the Add a Digital Signature command is unavailable, check that a valid certificate is installed in your system.
