Well, I'm not sure I understand the
exact details, TBD, but the impression I get is that you want to enter data with as few keystrokes as possible and to figure out how to make sure each value ends up in the proper....what? Column? That is, you want the end results to be this:
Code:
A B
1 Name 1
2 Detail 1
3 Detail 2
4 Detail 3
5 Name 2
6 Detail 1
7 Detail 2
...only without having to do a lot of laborious arrow-pushing to get each value into the right cell?
Pending your clarification ("no, I meant something else..."), there oughta be a couple of ways to do that. Depending on how much effort you want to go to up front:
a) There's a setting in Excel that tells it where to move the selection after you hit <Enter> on a cell. In Excel 2010 try <Alt-F>,t to open the Excel options, then select the Advanced section and, under "Editing Options", look for "After pressing Enter,
move selection", which lets you decide what direction it moves; you say yours is down, which I think is the default, but I always turn it off so the selection stays where it is. There doesn't seem to be a down-and-right option, but maybe this'll be a help.
b) You can enter the data all in one column and then use Excel functions to split it up and/or move it around.
c) The same from another angle: You can enter the data in an external text file, then import it into Excel.
d) You can write a VBA program to help you look at the value of each cell and decide what column it should be in.
But the question I keep coming back to is this: If you're asking this question, it's because you have a lot of data to enter. (If you had only three lines and four columns of data, you wouldn't be here looking for an easier way; the job would be done already.) And if you have a lot of data to enter, then where are you getting it from? Surely it's not on paper, is it? I mean, can't you just import it straight from the source, from the web or where you have it, and then do a few things to format it correctly?