After entering data into a cell I press the enter key and the selection box
moves one cell to the right. How do I make it drop down one line and to the
beginning cell after reaching the last column in the work area?
After entering data into a cell I press the enter key and the selection box
moves one cell to the right. How do I make it drop down one line and to the
beginning cell after reaching the last column in the work area?
Ken
Set your ENTER key to move down.......Tools>Options>Edit "move after entry"
Then when entering data across a row, use the Tab key to move right.
When you reach the last data entry cell in that row, hit the ENTER key to move
back to start column and down one row.
i.e. Start in A1 and Tab across to H1. Hit ENTER and go back to A2
Gord Dibben MS Excel MVP
On Mon, 26 Jun 2006 20:34:01 -0700, Ken Dean <Ken
[email protected]> wrote:
>After entering data into a cell I press the enter key and the selection box
>moves one cell to the right. How do I make it drop down one line and to the
>beginning cell after reaching the last column in the work area?
Thank You Gord! Works Great
"Gord Dibben" wrote:
> Ken
>
> Set your ENTER key to move down.......Tools>Options>Edit "move after entry"
>
> Then when entering data across a row, use the Tab key to move right.
>
> When you reach the last data entry cell in that row, hit the ENTER key to move
> back to start column and down one row.
>
> i.e. Start in A1 and Tab across to H1. Hit ENTER and go back to A2
>
>
> Gord Dibben MS Excel MVP
>
>
> On Mon, 26 Jun 2006 20:34:01 -0700, Ken Dean <Ken
> [email protected]> wrote:
>
> >After entering data into a cell I press the enter key and the selection box
> >moves one cell to the right. How do I make it drop down one line and to the
> >beginning cell after reaching the last column in the work area?
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks