Have switched over from Lotus 123. In that program I could adjust the
functionality of the tab and enter keys on my keyboard. For example, when I
hit enter key i could direct which direction the cursor would go to next ie
to the right one cell, down one cell, etc Also when I hit the tab key the
cursor would move one page to the right. A really handy feature in large
spreadsheets. But in Excel the tab key only moves one position to the
right....that's a useless function. How do I change these?

In 2007 click the round icon top left, select Excel Options bottom right of
pop up, choose Advanced, and change direction.

To move one screen at a time, click in the horizontal or vertical scrool bar

--
HTH

Kassie

Replace xxx with hotmail


"Daryl Bachalo" wrote:

> Have switched over from Lotus 123. In that program I could adjust the
> functionality of the tab and enter keys on my keyboard. For example, when I
> hit enter key i could direct which direction the cursor would go to next ie
> to the right one cell, down one cell, etc Also when I hit the tab key the
> cursor would move one page to the right. A really handy feature in large
> spreadsheets. But in Excel the tab key only moves one position to the
> right....that's a useless function. How do I change these?

Both these functions can be found in Options.

2003...........Tools>Options>Edit for enter key direction and
Tools>Options>Transition>Transition Navigation keys for the Tab one sheet
function.

2007.........Button>Excel Options>Advanced>Editing Options and Lotus
Compatibility


Gord Dibben MS Excel MVP

On Sat, 20 Mar 2010 04:52:01 -0700, Daryl Bachalo <Daryl
(E-Mail Removed)> wrote:

>Have switched over from Lotus 123. In that program I could adjust the
>functionality of the tab and enter keys on my keyboard. For example, when I
>hit enter key i could direct which direction the cursor would go to next ie
>to the right one cell, down one cell, etc Also when I hit the tab key the
>cursor would move one page to the right. A really handy feature in large
>spreadsheets. But in Excel the tab key only moves one position to the
>right....that's a useless function. How do I change these?