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?
I don't know if this is what you mean but if you check quot;enter directly in
cellquot; under toolsgt;optionsgt;edit you get into edit modeRegards,Peo Sjoblom
quot;MFINEquot; wrote:
gt; I've seen others double-click in a cell in excel and be able to drill down to
gt; the reference in the cell. How do I enable this?
Unfortunately this is not what I am after. I think this is a quot;compatibilityquot;
setting with Lotus as I recall being able to click in the cell and being
taken to the reference source.
quot;Peo Sjoblomquot; wrote:
gt; I don't know if this is what you mean but if you check quot;enter directly in
gt; cellquot; under toolsgt;optionsgt;edit you get into edit mode
gt;
gt;
gt; Regards,
gt;
gt;
gt; Peo Sjoblom
gt;
gt; quot;MFINEquot; wrote:
gt;
gt; gt; I've seen others double-click in a cell in excel and be able to drill down to
gt; gt; the reference in the cell. How do I enable this?
Did you bother to try it ? Uncheck quot;edit directly in cellquot; and doubleclick a
cell with a formula in it.
HTH. Best wishes Harald
quot;MFINEquot; gt; skrev i melding
...
gt; Unfortunately this is not what I am after. I think this is a
quot;compatibilityquot;
gt; setting with Lotus as I recall being able to click in the cell and being
gt; taken to the reference source.
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt; gt; I don't know if this is what you mean but if you check quot;enter directly
in
gt; gt; cellquot; under toolsgt;optionsgt;edit you get into edit mode
gt; gt;
gt; gt;
gt; gt; Regards,
gt; gt;
gt; gt;
gt; gt; Peo Sjoblom
gt; gt;
gt; gt; quot;MFINEquot; wrote:
gt; gt;
gt; gt; gt; I've seen others double-click in a cell in excel and be able to drill
down to
gt; gt; gt; the reference in the cell. How do I enable this?
This is what I wanted. Sorry about not understanding the answer.
Marc
quot;Peo Sjoblomquot; wrote:
gt; I don't know if this is what you mean but if you check quot;enter directly in
gt; cellquot; under toolsgt;optionsgt;edit you get into edit mode
gt;
gt;
gt; Regards,
gt;
gt;
gt; Peo Sjoblom
gt;
gt; quot;MFINEquot; wrote:
gt;
gt; gt; I've seen others double-click in a cell in excel and be able to drill down to
gt; gt; the reference in the cell. How do I enable this?
- Jun 04 Wed 2008 20:44
How do I enable the double-click drill down in Excel
close
全站熱搜
留言列表
發表留言
留言列表

