Adjust tab key function and enter key function in Excel

Adjust tab key function and enter key function in Excel

Post by RGFyeWwgQm » Sun, 21 Mar 2010 20:52:01


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

Post by S2Fzc2l » Sun, 21 Mar 2010 21:30:01

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

 
 
 

Adjust tab key function and enter key function in Excel

Post by Gord Dibbe » Sun, 21 Mar 2010 23:30:11

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