Use WPS Locate Referenced Cell through 1 how-to topic in the index below; 1 item is available without membership and 0 items are membership-related.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Locate Referenced Cell | Free |
How-to Guide
1. Locate Referenced Cell
Entry: Formulas → Locate Referenced Cell
- Select the cell whose reference relationship you want to inspect.
- Click Locate Referenced Cell on the Formulas tab.
- In the dialog box, review the cells referenced by the current cell.
- Click Locate to continue tracing the data source.
Success Criteria
- Interface result: The dialog box shows the cells referenced by the current cell.
- Next action available: You can click Locate to jump to the related data source.
- No side effects: Viewing the reference relationship does not change spreadsheet content.
Tips While Using
- Common mistake: If the selected cell does not contain the expected reference relationship, the result may not match what you want to inspect.
- Environment note: This feature is intended for formula reference checks inside spreadsheet files.