 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2006edit directly in cell in Excel 2007
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 ?  SignatureRegards Ron de Bruin http://www.rondebruin.nl > Hi, > [quoted text clipped - 9 lines] > Thanks a lot! > Andrea let's hope so! Thanks a lot! Andrea > Hi Andrea > [quoted text clipped - 14 lines] > > Thanks a lot! > > Andrea Found!! right click on the ribbon customize quick access toolbar advanced Double click allows editing directly in cell ciao! Andrea > Hi, > [quoted text clipped - 9 lines] > 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 SignatureHTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS > Found!! > [quoted text clipped - 20 lines] >> Thanks a lot! >> Andrea Yes you are right that it is working now Beta 1 not I believe SignatureRegards Ron de Bruin http://www.rondebruin.nl > Found!! > [quoted text clipped - 19 lines] >> Thanks a lot! >> Andrea |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.