Use Locate Referenced Cell with 1 how-to topic, including 1 free item and 0 membership-related items; start from the How-to Index and follow the steps below.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Locate Referenced Cell | Free |
How-to Guide
1. Locate Referenced Cell
Entry: Formulas tab → Locate Referenced Cell
- Select the cell whose references you want to review.
- Click Locate Referenced Cell on the Formulas tab.
- Review the referenced cells shown in the pop-up window.
Success Criteria
- Interface result: the pop-up window shows the cells referenced by the current cell.
- Next action: you can continue checking the formula or return to spreadsheet editing.
Tips While Using
- Select a formula cell or a cell whose reference relationship needs to be checked first.
- If the selected cell has no relevant references, the result may be empty or show no traceable content.