Audit cell reference on another sheet

  • Thread starter Thread starter scooper
  • Start date Start date
S

scooper

Would it be possible to audit a reference to a cell in another sheet with
the Tools Audit and get the exact cell location ie: Sheet2!C23.

scooper
 
Try double-clicking on the dotted line which points to a tiny ws icon.
This will surface the "Go To" dialog which shows you the cell location.
 
You must log in or register to reply here.

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

Building closed workbook file path within an Index Function 6
Formula Audit mode active in one column only; cannot kill. 2
Unable to activate Trace Precedents or Dependents in Excel 2003 5
Trace Dependents 2
Trace Precedents /dependents in another sheet 5
balnk is no text or formula exist in reffering cell 3
hlookup with the sheet name is a reference from another cell 2
How to Enlarge Box to See Complete Sheet Name 1

Back
Top