Adjust tab key function and enter key function in Excel

[Daryl Bachalo]

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?

 

[Kassie]

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

 

[Gord Dibben]

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