Feature Summary

The Locate Referenced Cells feature is used to view which cells a particular cell references, helping collaborative teams troubleshoot formula errors and understand data relationships.

Feature Description

Feature Dimension Description
Membership Restriction No membership restriction
Version Restriction No version restriction

Steps

Locate Referenced Cells

Feature Entry
"Formulas" tab → "Locate Referenced Cells" button

  1. Select the cell for which you want to view reference relationships
  2. Click the "Locate Referenced Cells" button in the Formulas tab
  3. The pop-up window will display the cells referenced by the selected cell
  4. Click "Locate" to automatically trace this data source

image