How do I enable the double-click drill down in Excel

M

MFINE

I've seen others double-click in a cell in excel and be able to drill down to
the reference in the cell. How do I enable this?
 
P

Peo Sjoblom

I don't know if this is what you mean but if you check "enter directly in
cell" under tools>options>edit you get into edit mode


Regards,


Peo Sjoblom
 
M

MFINE

Unfortunately this is not what I am after. I think this is a "compatibility"
setting with Lotus as I recall being able to click in the cell and being
taken to the reference source.
 
H

Harald Staff

Did you bother to try it ? Uncheck "edit directly in cell" and doubleclick a
cell with a formula in it.

HTH. Best wishes Harald
 

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

Need Help with Macro Security 1
Pivot table drill down data 2
Pivot Chart Drill-Down 1
AutoFill double click does not work in Excel 2007 2
Excel 2007 pivot table using analysis services cube as data source 0
Pivot table drill down sort 0
Please Help! Can't solve excel problem 4
sort order of pivot table drill down 0

Top