edit directly in cell in Excel 2007

[Andrea]

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

[Ron de Bruin]

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

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

[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

[Nick Hodge]

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
[email protected]HIS


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

[Ron de Bruin]

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


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



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