How do I set the Enter key to go to a specific cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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

Set the ENTER key in Tools>Options>Edit 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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ENTER skips unlocked cells 3
"Move selection after Enter" 3
Cursor to go to Specific cell 4
HOw do I use enter to return to the first cell in the next row? 5
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
hit enter in any column and go to next row in first column 3
Making a specific row number active from a cell entry 15
When a cell is selected, move to a different cell 1

Back
Top