Excel "Shortcut Keys"

  • Thread starter Thread starter Legend
  • Start date Start date
L

Legend

Is there a shortcut key(s) to return to last accessed cell?
Example: I start in cell a:10, then scroll to cell c:580.
Is there a way to quickly return to a:10 (other than GoTo)
I am looking for something similar to ctrl+home.

Thanks.
 
You could select the range A10:C580 and if you make
no mistakes after entering data into C580 you would
return to cell A10.

Another way you could unprotect cells A10:C580 then
protect the sheet. Cells are protected by default but not
effective until the sheet itself is protected.

You could use an event macro such that after entering
something into cell C580 you go back to cell A10.

You could use a hyperlink in cell A10 go get to cell C580
and then use use the BACK key to return to A10.
Enter the hyperlink as #C580
Use Alt+LtArrow or the turquoise web left arrow icon button (customize) to return.
 
When you say "scroll", I assume that you're using the mouse wheel or the
scroll bars on the side or bottom of the screen, and *not* changing the
focus of the sheet.

If that's the case, then A10 is still displayed in the name box.

Click in the name box and hit <Enter>.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Is there a shortcut key(s) to return to last accessed cell?
Example: I start in cell a:10, then scroll to cell c:580.
Is there a way to quickly return to a:10 (other than GoTo)
I am looking for something similar to ctrl+home.

Thanks.
 
Back
Top