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 ?

 

[Andrea]

let's hope so!

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 ?

 

[Andrea]

Found!!

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

ciao!
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
(e-mail address removed)

 

[Ron de Bruin]

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