get the curser to automatically return

[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

 

[Gord Dibben]

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

 

[Guest]

My tab key takes me to P1

 

[Gord Dibben]

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


Gord

 

[Dave Peterson]

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

 

[Guest]

Thanks guys it works.
--
Charles

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