Cell References

  • Thread starter Thread starter C.M.
  • Start date Start date
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"
 
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

Code to format cells on several worksheets 2
Confusing Problem 2
matching values between worksheets 8
Why does "cut and paste" cause #REF! errors? 4
Fill formula down for cells 74 rows apart 3
Removing Intermediary Connections 2
Correction 2
Blank Cell Reference, without if statement 4

Back
Top