close

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?

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()