8

Is there a way to see which cells reference a given cell in their formulas, in Google Sheets?

For example, if cell C1 contains =SUM(A1:A5), and cell D1 contains =SUM(A5:A8), I'd like to somehow be able to determine that cell A5 is used in two places: C1 and D1, without prior knowledge that A5 is referenced by C1 and D1. It would be similar to how clicking on a formula highlights which cells it references, but the reverse.

6

Short answer

Use find & replace

Explanation

  1. Press Ctrl + H to open the Advanced Find and Replace dialog
  2. Write A5 on the Find field
  3. Turn on the Also check within formulas option. This will turn on the View All formulas spreadsheet option.
  4. Click the Find button

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.