close

Hello,

I have a spreadsheet that has grown from lt;500 rows to more than 3500. What
I'd like to know is if there is a way to have it so that Excel can remember
from where you were earlier in the session. Alot of times, I have to bounce
around so many different areas on the spreadsheet, and sometimes it would be
nice if I could just click quot;backquot; or quot;forwardquot;, similarly to when browsing on
the web, because I can't remember where I just was during the editing/input
session.

Is this possible?

Thanks.

Phil.

Phil

There is no built in functionality, it could be done with code and the
worksheet_selectionChange event but it would need to be restricted to the
number of levels, the addresses could be stored on a hidden sheet, but may
be a bit ugly in implementation.

Certainly possible, but not simply

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HISquot;Philquot; gt; wrote in message
news
gt; Hello,
gt;
gt; I have a spreadsheet that has grown from lt;500 rows to more than 3500.
gt; What
gt; I'd like to know is if there is a way to have it so that Excel can
gt; remember
gt; from where you were earlier in the session. Alot of times, I have to
gt; bounce
gt; around so many different areas on the spreadsheet, and sometimes it would
gt; be
gt; nice if I could just click quot;backquot; or quot;forwardquot;, similarly to when browsing
gt; on
gt; the web, because I can't remember where I just was during the
gt; editing/input
gt; session.
gt;
gt; Is this possible?
gt;
gt; Thanks.
gt;
gt; Phil.
Nick,

That figures. Oh well, you'd think by now Microsoft could've seen some
benefit to addressing this problem, as I'd bet I'm not the only one who'd
want something like this.

Thanks for your reply anyway.

quot;Nick Hodgequot; wrote:

gt; Phil
gt;
gt; There is no built in functionality, it could be done with code and the
gt; worksheet_selectionChange event but it would need to be restricted to the
gt; number of levels, the addresses could be stored on a hidden sheet, but may
gt; be a bit ugly in implementation.
gt;
gt; Certainly possible, but not simply
gt;
gt; --
gt; HTH
gt; Nick Hodge
gt; Microsoft MVP - Excel
gt; Southampton, England
gt; www.nickhodge.co.uk
gt; HIS
gt;
gt;
gt; quot;Philquot; gt; wrote in message
gt; news
gt; gt; Hello,
gt; gt;
gt; gt; I have a spreadsheet that has grown from lt;500 rows to more than 3500.
gt; gt; What
gt; gt; I'd like to know is if there is a way to have it so that Excel can
gt; gt; remember
gt; gt; from where you were earlier in the session. Alot of times, I have to
gt; gt; bounce
gt; gt; around so many different areas on the spreadsheet, and sometimes it would
gt; gt; be
gt; gt; nice if I could just click quot;backquot; or quot;forwardquot;, similarly to when browsing
gt; gt; on
gt; gt; the web, because I can't remember where I just was during the
gt; gt; editing/input
gt; gt; session.
gt; gt;
gt; gt; Is this possible?
gt; gt;
gt; gt; Thanks.
gt; gt;
gt; gt; Phil.
gt;
gt;
gt;

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

    software

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