Moving to next row

[Brian.]

I know there's probably an easy answer to this, but in my
Excel, if I enter data in several consecutive cells in a
row, the enter key will then take me back to the first
cell in the next row (which is what I want).

On one of my client's machines, however, the enter key
only moves the cursor down one (or up, right, left,
depending on how I set the option). Is there some
setting in the formatting that's different?

 

[L. Howard Kittle]

Hi Brian,

Just a guess, but you may have an event macro that fires when you get to a
certain column and the activecell is reset to the next row and column A, or
whatever column. Is the number of entries the same on each row? If not
then the macro is probably not it.

Also, you may not know you can use the TAB to move to the next right cell
after data entry and when you are ready to go to the next row hit ENTER
instead of TAB and your cursor will reset like a typewriter carriage return.
Tab, tab, tab, enter... presto! Next line. So if you have three entries on
a row and the next has seven entries, still works.

HTH
Regards
Howard

 

[brian \(Mojave1atdslextremedotcom\)]

Howard,

Thanks for your response. I guess I wasn't clear in my
first question. I've always been able to use the enter
key to go back to the first column on the next row (I
long as I enter data in each cell using the tab key
rather than the arrow).

On my client's machine, however, the enter key only moves
the cursor to the cell below the last cell entered. I
don't know if there's a setting I missed... The files in
question were originally imported from Paradox, so that
may be a factor. Thanks again for your help.

 

[Jason Morin]

Check out "Transition formula entry" under Tools > Options

Transition Tab.

HTH
Jason
Atlanta, GA