Automatically checking cell references

  • Thread starter Thread starter ModelerGirl
  • Start date Start date
M

ModelerGirl

I have two questions about cell references:

1. How do I check that all references within a cell refer to the same
cell?

2. How do I check that two adjacent cells refer to adjacent cells?

Please note that, in both cases, the cells being referred to are in a
different worksheet than the cells I want to check.

Thanks,
Katie
 
For internal references, use:
Edit > Goto... > Special...> Precedents

For external reference, use:
Tools > Formula Auditing and select Trace Precedents

If you have an external reference, you will see a dotted arrow pointing to a
worksheet icon. Double-click this arrow.
 
Back
Top