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

Bob,

Thanks for your response. I tried your suggestion but the result was that
the cell was opened up for editing - it didn't take me to the referenced
cell. Do I need to click the cell in a specific place?

Thanks,
Dennis

"Bob Phillips" wrote:

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!