get the curser to automatically return

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I get the curser to automatically return to my starting column
(example I’m in A1 and move to C1 enter and the curser will not go back to A2
only up, down, left, right ). Is there a way to set this up so it will return
to your starting point?

Charles
 
Charles

Start in A1 then TAB across to C1. When leaving C1 hit ENTER key to drop down
to A2.

Using this method you will always return to original column and down one row.

Another method is to unprotect columns A to C then protect the worksheet.

TAB will move you across to C then back to A down one row.


Gord Dibben Excel MVP
 
In that case, go to Tools>Options>Transition and uncheck "Transition
Navigation Keys".


Gord
 
If you select columns A:C, then hit the tab key (or enter key), what's the
pattern that it follows?
 
Back
Top