Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I set the Enter key to go to a specific cell?
I am entering data on a worksheet from left to right, using the tab. At the
end when I hit Enter, I want the very first cell on the next row to be where I start. I have looked at Options-General, but it only will determine "Up, Down, Left, Right". I would like to set it to where the Home begins on the first cell of the next row. |
#2
|
|||
|
|||
If you select your input range first (say A12:D99), and change
tools|options|Edit Tab|Move selection after Enter to Right (or turn it off) Then tabbing/entering will follow your desired path. John wrote: I am entering data on a worksheet from left to right, using the tab. At the end when I hit Enter, I want the very first cell on the next row to be where I start. I have looked at Options-General, but it only will determine "Up, Down, Left, Right". I would like to set it to where the Home begins on the first cell of the next row. -- Dave Peterson |
#3
|
|||
|
|||
John
Set the ENTER key in ToolsOptionsEdit to "down". Then use the TAB key to move across a row. When you leave the last data entry cell in that row, hit the ENTER key to move down one row and back to original column. Gord Dibben Excel MVP On Fri, 18 Mar 2005 09:17:05 -0800, "John" <John @discussions.microsoft.com wrote: I am entering data on a worksheet from left to right, using the tab. At the end when I hit Enter, I want the very first cell on the next row to be where I start. I have looked at Options-General, but it only will determine "Up, Down, Left, Right". I would like to set it to where the Home begins on the first cell of the next row. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highlight a row if a specific cell is specific numbers/words | Excel Worksheet Functions | |||
How do I format a cell so that only specific numbers can be enter. | Excel Discussion (Misc queries) | |||
How do I make a cell date specific to input a value on a specific. | Excel Discussion (Misc queries) | |||
How do I insert an image into a specific cell within a protected . | Excel Discussion (Misc queries) | |||
Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel |