Automatically checking cell references

[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

 

[Guest]

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.