Go Back
Jeb
back to the cell I just moved from? If I am typing in
cell L980 and move to home, how can I quickly get back to
L980??
Gina Lolabridgida
"Jeb" <jeb...@attbi.com> wrote in message
news:03f701c30b97$1c8a9fc0$a101...@phx.gbl...
Rudy
left, same toolbar as the formula bar), type in the
address and press enter.
Rudy
>.
>
Dana DeLouis
want to go back to.
Excel has a built in feature that remembers it's last 4 locations. It is
usually used in Macros, but you can access this feature manually.
With your cell selected, (say z100), select the name box....and just hit
enter.
This adds the current selection to Excel's memory.
Now move your selection back to A1.
Hit F5 to bring up the "GoTo" feature, and just hit enter to return to z100.
If you hit F5 at a later time, and z100 is not the "Previous" location, you
still might be able to select it from the list.
HTH. :>)
--
Dana DeLouis
Windows XP & Office XP
= = = = = = = = = = = = = = = = =
"Jeb" <jeb...@attbi.com> wrote in message
news:03f701c30b97$1c8a9fc0$a101...@phx.gbl...
Biff
Here's one way without having to take your hand off of the
mouse to use the keyboard ( I'm sooo lazy )
edit>goto>special>last cell
Biff
>.
>
Hank Scorpio
wrote:
>Hi Jeb,
>
>Here's one way without having to take your hand off of the
>mouse to use the keyboard ( I'm sooo lazy )
>
>edit>goto>special>last cell
>
>Biff
Unfortunately not. "Last Cell" refers to the last cell used in the
current worksheet. Say that you have contents in cell D10 and nothing
to the right or below that. Using Edit -> Goto -> Special -> Last Cell
will always take you to D10, regardless of where the cursor was prior
to that.
>>-----Original Message-----
>>I'm a new user of Excel 2000. How can I easily navigate
>>back to the cell I just moved from? If I am typing in
>>cell L980 and move to home, how can I quickly get back to
>>L980??
---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *
David McRitchie
and the lastused row. It is not defined as the last cell visited.
Jeb didn't indicate returning to the lastcell but to get to the
last cell the shortcut is Ctrl+End which is normally used
to see if you have more rows or columns in your used range than
you thought you had or more than you wanted.
---
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
"Biff" <biffi...@comcast.net> wrote ...
Biff
Biff
>.
>
Biff
Biff
>.
>