Adjust tab key function and enter key function in Excel
 

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?

Adjust tab key function and enter key function in Excel
 

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?

Adjust tab key function and enter key function in Excel
 

Both these functions can be found in Options.

2003...........ToolsOptionsEdit for enter key direction and
ToolsOptionsTransitionTransition Navigation keys for the Tab one sheet
function.

2007.........ButtonExcel OptionsAdvancedEditing Options and Lotus
Compatibility


Gord Dibben MS Excel MVP

On Sat, 20 Mar 2010 04:52:01 -0700, Daryl Bachalo <Daryl
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?