automatic right

Orangeanorak

Board Regular
Joined
Nov 22, 2002
Messages
248
After typing a two digit number in an excel spreadsheet can the cursor be made to move automatically to the next cell on the right without pressing tab or any other key


Thanks for your help
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

HalfAce

MrExcel MVP
Joined
Apr 6, 2003
Messages
9,453
I don't believe this is possible.
You can have it automatically select the cell to the right when you hit Enter, but not (as far as I know) while you're entering the characters because excel at that time is in edit mode and waiting for input from the user.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,116
Messages
5,570,273
Members
412,316
Latest member
JabirS
Top