Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I enable drill down to refernce cells?
Looking for the feature that will allow double-clicking on a cell and then
being transferred to the reference cell - think it it a Lotus compatibility feature. thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I enable drill down to refernce cells?
You can go to:
<Tools <Options <Edit tab, And *UNCHECK* "Edit Directly In Cell". Also ... you can retain the functionality of editing in the cell and still jump to reference cells by selecting the cell with the formula, and then: <Ctrl < [ You can then return to the formula cell with: <Ctrl < ] -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "MFINE" wrote in message ... Looking for the feature that will allow double-clicking on a cell and then being transferred to the reference cell - think it it a Lotus compatibility feature. thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I enable drill down to refernce cells?
Thanks, your answer is just what I needed for both options!!!!!!!
"Ragdyer" wrote: You can go to: <Tools <Options <Edit tab, And *UNCHECK* "Edit Directly In Cell". Also ... you can retain the functionality of editing in the cell and still jump to reference cells by selecting the cell with the formula, and then: <Ctrl < [ You can then return to the formula cell with: <Ctrl < ] -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "MFINE" wrote in message ... Looking for the feature that will allow double-clicking on a cell and then being transferred to the reference cell - think it it a Lotus compatibility feature. thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I enable drill down to refernce cells?
Appreciate the feed-back.
-- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "MFINE" wrote in message ... Thanks, your answer is just what I needed for both options!!!!!!! "Ragdyer" wrote: You can go to: <Tools <Options <Edit tab, And *UNCHECK* "Edit Directly In Cell". Also ... you can retain the functionality of editing in the cell and still jump to reference cells by selecting the cell with the formula, and then: <Ctrl < [ You can then return to the formula cell with: <Ctrl < ] -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "MFINE" wrote in message ... Looking for the feature that will allow double-clicking on a cell and then being transferred to the reference cell - think it it a Lotus compatibility feature. thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I enable drill down to refernce cells?
What about the same option in Excel 2007? I haven't been able to locate the
"Edit Directly in Cell" option there. Help! -- Thanks. ~ Mindy "Ragdyer" wrote: You can go to: <Tools <Options <Edit tab, And *UNCHECK* "Edit Directly In Cell". Also ... you can retain the functionality of editing in the cell and still jump to reference cells by selecting the cell with the formula, and then: <Ctrl < [ You can then return to the formula cell with: <Ctrl < ] -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "MFINE" wrote in message ... Looking for the feature that will allow double-clicking on a cell and then being transferred to the reference cell - think it it a Lotus compatibility feature. thanks |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I enable drill down to refernce cells?
Never mind. I found it.
It's under Excel Options Advanced. -- Thanks. ~ Mindy "Mindy" wrote: What about the same option in Excel 2007? I haven't been able to locate the "Edit Directly in Cell" option there. Help! -- Thanks. ~ Mindy "Ragdyer" wrote: You can go to: <Tools <Options <Edit tab, And *UNCHECK* "Edit Directly In Cell". Also ... you can retain the functionality of editing in the cell and still jump to reference cells by selecting the cell with the formula, and then: <Ctrl < [ You can then return to the formula cell with: <Ctrl < ] -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "MFINE" wrote in message ... Looking for the feature that will allow double-clicking on a cell and then being transferred to the reference cell - think it it a Lotus compatibility feature. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Circular Refernce | Excel Discussion (Misc queries) | |||
Circular Refernce error | Excel Discussion (Misc queries) | |||
How do I enable the double-click drill down in Excel | Excel Discussion (Misc queries) | |||
Enable a new dimention: sub-level of split cells | Excel Discussion (Misc queries) | |||
Named SUM Formula with relative refernce(s) | Excel Worksheet Functions |