How to Use WPS Formula Check on macOS

Use Formula Check through 3 how-to topics, including running error checking, customizing checking rules, and detecting circular references; 3 items are available without membership and 0 items are membership-related.

How-to Index

How-to Guide

1. Run Error Checking

Entry: Formulas tab → Error Checking

1. Open the spreadsheet file that you want to review.
2. Click the Formulas tab at the top of the window.
3. Click Error Checking.
4. Wait while WPS scans formulas across the worksheet.
5. Review the reported error reason and correct the related formula as needed.

Success Criteria

• Interface result: After the scan finishes, you see an error prompt or a checking result.
• Next action available: You can revise the formula and run another check if needed.

Tips While Using

• Common mistake: If the current worksheet does not contain formulas, the check may not return useful results.
• Environment note: Large spreadsheets may take longer to scan.

2. Customize Checking Rules

Entry: File menu → Spreadsheet Preferences → Error Checking

1. Click the File menu in the upper-left corner.
2. Select Spreadsheet Preferences.
3. Open the Error Checking tab.
4. Set the display color for error prompts.
5. Select or clear the rules that you want WPS to check.
6. Click OK to save the settings.

Success Criteria

• Interface result: The settings on the Error Checking tab are updated.
• Next action available: The next formula check follows the updated rules.

Tips While Using

• Common mistake: If you close the window without clicking OK, the new settings are not saved.
• Environment note: The checking preferences apply to the current app environment.

3. Detect Circular References

Entry: Formulas tab → arrow next to Error Checking → Circular References

1. When you enter a formula and a circular reference exists, review the warning message first.
2. Close the warning and click the Formulas tab.
3. Click the arrow next to Error Checking.
4. Check whether Circular References is available.
5. If it is available, click it to jump to the related cell.
6. Edit the formula and check again to confirm that the circular reference is removed.

Success Criteria

• Interface result: When a circular reference exists, the menu entry is available and can jump to the related cell.
• Next action available: After locating the cell, you can edit the formula and verify the result again.

Tips While Using

• Common mistake: Closing the warning without locating the related cell leaves the issue unresolved.
• Environment note: Complex reference chains may require several rounds of edits and checks.