Excel, Moving Cursor after hitting Enter 1

[Sopman]

Is there a way after entering data in column "J" to hit 'enter' and have the cursor move down one row and to column "B" for multiple entries?

Sopman

 

[SkipVought]

Hi,

Not without VBA code.

Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}

 

[Sopman]

When I work on the spreadsheet on my computer it does move the cursor after I hit 'enter', but when I emailed the file to another person, it doesn't move the cursor. Any idea why this is?

Sopman

 

[SkipVought]

"it does move the cursor after I hit 'enter'"

Well it should! Tools/Options/Edit controls where the cursor will go on [Enter] -- [Up],[Down],

,

Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!} ​

 

[Sopman]

No, I mean it moves it from Column J down one row and to column C.

Sopman

 

[SkipVought]

You have some VBA code doing that.

Right click the sheet tab and select View Code.

Copy n' paste the code please.

Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}

 

[pbrodsky]

Actually, there is an Excel feature (added about Excel 2000) that causes that behavior. I vaguely remember it mentioned when it was introduced. I can't find anything about it in the Excel Help and I don't think there is any way of controlling it, but if you start entering data in (say) column A and tab across to enter more data, when you press Enter the cursor will move down and back to your starting column.

 

[KenWright]

Could always hide columns D:I, then select the range C2:J100 for example, and asuming you have set the cursor to 'move right' then it will do this every time you hit Enter.

Regards
Ken.................

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[SkipVought]

Ken Wright!

You are smarter than you look!

Brilliant! ==>*

Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}

 

[Sopman]

Good idea, but we enter data into columns D,H and I.

Sopman

 

[SkipVought]

All you have to do is change the columns you hide and select.


Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}

 

[KenWright]

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[BenRowe]

If you select the cells before entering data, tab takes you to the next cell, even if it's on next row.