edit directly in cell in Excel 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 ?
 
Found!!

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

ciao!
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 address removed)
 
Back
Top