Go to cell referenced in a formula

[Dennis]

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!

[Bob Phillips]

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" <[email protected]> wrote in message
news:[email protected]...
> 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!

[Dennis]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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!
>
>
>

[Bob Phillips]

No, if you double click a formula that reference the same sheet it should
highlight all areas on that sheet, if it references another sheet, it should
go to the first range referenced.

Make sure that you double-click the cell, not the formula bar.

--
HTH

Bob Phillips

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

"Dennis" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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!
> >
> >
> >

[Dominic LeVasseur]

Dennis,

I think you should go to Tools:Options:Edit and uncheck "Edit directly in
cell". Then I believe Bob's suggestion should work perfectly.

HTH

"Dennis" wrote:

> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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!
> >
> >
> >

[Dennis]

Dominic,

That worked! Thank you very much.

Dennis

"Dominic LeVasseur" wrote:

> Dennis,
>
> I think you should go to Tools:Options:Edit and uncheck "Edit directly in
> cell". Then I believe Bob's suggestion should work perfectly.
>
> HTH
>
> "Dennis" wrote:
>
> > 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" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > 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!
> > >
> > >
> > >

[Dominic LeVasseur]

You're welcome Dennis.

Thanks for writing back.

"Dennis" wrote:

> Dominic,
>
> That worked! Thank you very much.
>
> Dennis
>
> "Dominic LeVasseur" wrote:
>
> > Dennis,
> >
> > I think you should go to Tools:Options:Edit and uncheck "Edit directly in
> > cell". Then I believe Bob's suggestion should work perfectly.
> >
> > HTH
> >
> > "Dennis" wrote:
> >
> > > 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" <[email protected]> wrote in message
> > > > news:[email protected]...
> > > > > 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!
> > > >
> > > >
> > > >