If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|