edit directly in cell in Excel 2007 Andrea 08.07.2006 14:15:01 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

Re: edit directly in cell in Excel 2007 "Ron de Bruin" <rondebruin[ at ]kabelfoon.nl> 08.07.2006 14:23:24 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" <Andrea[ at ]discussions.microsoft.com> wrote in message news:00CB0BD7-0C53-40F6-B467-C491444A4E78[ at ]microsoft.com... [Quoted Text] > 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

Re: edit directly in cell in Excel 2007 Andrea 08.07.2006 14:36:01 let's hope so! Thanks a lot! Andrea "Ron de Bruin" wrote: [Quoted Text] > 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" <Andrea[ at ]discussions.microsoft.com> wrote in message news:00CB0BD7-0C53-40F6-B467-C491444A4E78[ at ]microsoft.com... > > 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 > > >

RE: edit directly in cell in Excel 2007 Andrea 08.07.2006 14:42:01 Found!! right click on the ribbon customize quick access toolbar advanced Double click allows editing directly in cell ciao! Andrea "Andrea" wrote: [Quoted Text] > 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

Re: edit directly in cell in Excel 2007 "Nick Hodge" <nick_hodgeTAKETHISOUT[ at ]zen.co.uk.ANDTHIS> 08.07.2006 14:49:19 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 nick_hodgeTAKETHISOUT[ at ]zen.co.uk.ANDTHIS "Andrea" <Andrea[ at ]discussions.microsoft.com> wrote in message news:9BE31559-D7E8-4FA2-AE21-E7A6646F1DD6[ at ]microsoft.com... [Quoted Text] > 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

Re: edit directly in cell in Excel 2007 "Ron de Bruin" <rondebruin[ at ]kabelfoon.nl> 08.07.2006 14:50:03 Yes you are right that it is working now Beta 1 not I believe -- Regards Ron de Bruin http://www.rondebruin.nl "Andrea" <Andrea[ at ]discussions.microsoft.com> wrote in message news:9BE31559-D7E8-4FA2-AE21-E7A6646F1DD6[ at ]microsoft.com... [Quoted Text] > 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