get the curser to automatically return

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

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

On Tue, 20 Sep 2005 13:40:03 -0700, "Charles"
<Charles@discussions.microsoft.com> wrote:

>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

My tab key takes me to P1
--
Charles


"Charles" wrote:

> 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

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


Gord

On Tue, 20 Sep 2005 15:02:02 -0700, "Charles"
<Charles@discussions.microsoft.com> wrote:

>My tab key takes me to P1

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

Charles wrote:
>
> My tab key takes me to P1
> --
> Charles
>
> "Charles" wrote:
>
> > 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

--

Dave Peterson

Thanks guys it works.
--
Charles


"Dave Peterson" wrote:

> If you select columns A:C, then hit the tab key (or enter key), what's the
> pattern that it follows?
>
> Charles wrote:
> >
> > My tab key takes me to P1
> > --
> > Charles
> >
> > "Charles" wrote:
> >
> > > 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
>
> --
>
> Dave Peterson
>