Thanks for the feedback.

A1 to AG1 is a long way to run.

Gord

On Thu, 20 Jan 2005 10:27:04 -0800, "QAguy"
wrote:

THAT'S IT ! Thank you all. As soon as I switched 'Move selection after
Enter" back to Down, the TAB method worked perfectly. I knew it was a simple
skill I had forgotten.

Gord, thanks again. BTW, it is A1 to AG1, which is why I was desparate to
remember your solution. :-)

"Gord Dibben" wrote:

Assuming you start entering data in column A and want to go across to
F1.........

Use the TAB key when leaving A1 to go to B1 then C1, D1, E1, F1 as you enter
the data.

When leaving F1, hit the <ENTER key to drop to A2.

The <ENTER key will drop down 1 row and go back to the column in which you
started.


Gord Dibben Excel MVP


On Thu, 20 Jan 2005 07:51:15 -0800, "QAguy"
wrote:

I knnow there is a way to "teach" my spreadsheet the range I am entering data
into. But I don't remember how. The actice cell is supposed to go from the
last data entry column in the current row, to the first column in the next
row. All I had to do was hit "Enter" and I was ready to enter the next
record. Does anybody remember how?