Automatically checking cell references

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
 
G

Gary''s Student

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.
 
Top