Hi,

in Excel 2003 I disable the "Edit directly in cell" option so that when I
double-click on a cell that has a formula link

='Sheet1'A23

the cursor goes to cell A23 of Sheet1. It is very useful for me to nabvigate
among my formula.
I'm searching the same option in Excel 2007 but I really cannot find it..

Thanks a lot!
Andrea

Hi Andrea

This is a big as far as I know in 2007
Hope they fixed it in the beta refresh ?


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Andrea" <(E-Mail Removed)> wrote in message news:00CB0BD7-0C53-40F6-B467-(E-Mail Removed)...
> Hi,
>
> in Excel 2003 I disable the "Edit directly in cell" option so that when I
> double-click on a cell that has a formula link
>
> ='Sheet1'A23
>
> the cursor goes to cell A23 of Sheet1. It is very useful for me to nabvigate
> among my formula.
> I'm searching the same option in Excel 2007 but I really cannot find it..
>
> Thanks a lot!
> Andrea

let's hope so!

Thanks a lot!
Andrea

"Ron de Bruin" wrote:

> Hi Andrea
>
> This is a big as far as I know in 2007
> Hope they fixed it in the beta refresh ?
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "Andrea" <(E-Mail Removed)> wrote in message news:00CB0BD7-0C53-40F6-B467-(E-Mail Removed)...
> > Hi,
> >
> > in Excel 2003 I disable the "Edit directly in cell" option so that when I
> > double-click on a cell that has a formula link
> >
> > ='Sheet1'A23
> >
> > the cursor goes to cell A23 of Sheet1. It is very useful for me to nabvigate
> > among my formula.
> > I'm searching the same option in Excel 2007 but I really cannot find it..
> >
> > Thanks a lot!
> > Andrea
>
>
>

Found!!

right click on the ribbon
customize quick access toolbar
advanced
Double click allows editing directly in cell

ciao!
Andrea

"Andrea" wrote:

> Hi,
>
> in Excel 2003 I disable the "Edit directly in cell" option so that when I
> double-click on a cell that has a formula link
>
> ='Sheet1'A23
>
> the cursor goes to cell A23 of Sheet1. It is very useful for me to nabvigate
> among my formula.
> I'm searching the same option in Excel 2007 but I really cannot find it..
>
> Thanks a lot!
> Andrea

Andea

That's the correct option and both these ways take four clicks, but the
route you took to the 'options' area is more normally

Office Button>Excel Options>Advanced>Double click allows editing directly in
cell.

I appreciate there is always more than 'one way to skin a cat', but the
reference to the QAT takes you to the customisation tab to customise the QAT
and could confuse

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(E-Mail Removed)HIS


"Andrea" <(E-Mail Removed)> wrote in message
news:9BE31559-D7E8-4FA2-AE21-(E-Mail Removed)...
> Found!!
>
> right click on the ribbon
> customize quick access toolbar
> advanced
> Double click allows editing directly in cell
>
> ciao!
> Andrea
>
> "Andrea" wrote:
>
>> Hi,
>>
>> in Excel 2003 I disable the "Edit directly in cell" option so that when I
>> double-click on a cell that has a formula link
>>
>> ='Sheet1'A23
>>
>> the cursor goes to cell A23 of Sheet1. It is very useful for me to
>> nabvigate
>> among my formula.
>> I'm searching the same option in Excel 2007 but I really cannot find it..
>>
>> Thanks a lot!
>> Andrea

Yes you are right that it is working now
Beta 1 not I believe


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Andrea" <(E-Mail Removed)> wrote in message news:9BE31559-D7E8-4FA2-AE21-(E-Mail Removed)...
> Found!!
>
> right click on the ribbon
> customize quick access toolbar
> advanced
> Double click allows editing directly in cell
>
> ciao!
> Andrea
>
> "Andrea" wrote:
>
>> Hi,
>>
>> in Excel 2003 I disable the "Edit directly in cell" option so that when I
>> double-click on a cell that has a formula link
>>
>> ='Sheet1'A23
>>
>> the cursor goes to cell A23 of Sheet1. It is very useful for me to nabvigate
>> among my formula.
>> I'm searching the same option in Excel 2007 but I really cannot find it..
>>
>> Thanks a lot!
>> Andrea