View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default Go to cell referenced in a formula

If you double click the cell with the formula, it goes to the first cell
referenced on another sheet.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Dennis" wrote in message
...
How do I easily go to a cell referenced in a formula? The
precedents/dependents is useful when the reference is on the same
spreadsheet, but not so easy when the referenced cell is on another
spreadsheet - even if in the same file.

Thanks much for your help!