Use WPS Locate Referenced Cell with 1 how-to topic, including Locate Referenced Cell; choose a topic from the How-to Index and follow the entry path and steps to complete the task.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Locate Referenced Cell | Free |
How-to Guide
1. Locate Referenced Cell
Entry path: Formulas tab → Locate Referenced Cell
- Select the cell whose references you want to inspect.
- Click Locate Referenced Cell on the Formulas tab.
- Review the referenced cells shown in the pop-up window.
- Click Locate to jump to the related source data.
Success Criteria
- Interface result: The pop-up window shows the cells referenced by the current formula cell.
- Next action available: You can continue locating or reviewing the formula source.
Tips While Using
- Select a cell that contains a formula or references before you run the command.
- If the worksheet logic is complex, review the formula bar together with the reference result.