Cell References

C

C.M.

eg: If iam using "Sheet1A1" as my reference in sheet2 & some other sheets in
other files, can I know which cells are using "Sheet1A1" as its reference by
clicking on cell "A1" in "Sheet1"
 
D

Duke Carey

Not simply by 'clicking' on it. However, if you select that cell and then
use the Trace Dependents option on the Tools->Formula Auditing menu, you'll
get a window that shows the cells that reference it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Confusing Problem 2
Code to format cells on several worksheets 2
matching values between worksheets 8
Removing Intermediary Connections 2
Cell References/Names 1
keeping format of a referenced cell 4
Why does "cut and paste" cause #REF! errors? 4
Fill formula down for cells 74 rows apart 3

Top