| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
edit 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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
edit directly in cell in Excel 2007
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" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
edit directly in cell in Excel 2007
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" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
edit directly in cell in Excel 2007
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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
edit directly in cell in Excel 2007
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 ButtonExcel OptionsAdvancedDouble 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 HIS "Andrea" wrote in message ... 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 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
edit directly in cell in Excel 2007
Yes you are right that it is working now
Beta 1 not I believe -- Regards Ron de Bruin http://www.rondebruin.nl "Andrea" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 Worksheet | Excel Discussion (Misc queries) | |||
| Excel 2007 B2 - Selecting every cell that starts with a certain word | Excel Discussion (Misc queries) | |||
| Using F2 to edit a cell | Excel Discussion (Misc queries) | |||
| I have opened an Excel file and I can't edit any cell | New Users to Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
