How do I enable drill down to refernce cells?

M

MFINE

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
 
R

Ragdyer

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> < ] >
 
M

MFINE

Thanks, your answer is just what I needed for both options!!!!!!!

Ragdyer said:
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 said:
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
Click to expand...
Click to expand...
 
R

RagDyeR

Appreciate the feed-back.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

Thanks, your answer is just what I needed for both options!!!!!!!

Ragdyer said:
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 said:
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
Click to expand...
Click to expand...
 
M

Mindy

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 said:
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 said:
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
Click to expand...
Click to expand...
 
M

Mindy

Never mind. I found it.

It's under Excel Options > Advanced.
--
Thanks.
~ Mindy


Mindy said:
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 said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
S

Stu

The <Ctl> <]> did not take me back to the formula cell. I am using Office
2007. Thanks in advance for any help.
Stu



Mindy said:
Never mind. I found it.

It's under Excel Options > Advanced.
--
Thanks.
~ Mindy


Mindy said:
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 said:
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 !
---------------------------------------------------------------------------

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
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I enable the double-click drill down in Excel 4
Circular Refernce 1
Merging from an Excel file with graphics 1
Pivot Chart Drill-Down 1
Creating a Dropdown that is Related to the Value Given in Another Cell 6
Excel 2007 pivot table using analysis services cube as data source 0
How do I turn off annotating with ink in Excel 2016 2
Fixed/Locked cell referencing 6

Top