Type 3 digits in one cell then automatically move to next cell.
No. You have to hit some key to let Excel know you're done typing in a cell.
Those keys a Enter, Tab, one of the directional arrow keys or ESC.. Until
you hit one of those keys Excel is in Edit mode and nothing else can happen
until you are out of Edit mode.
Biff
"mulligbo" wrote in message
...
I am working in a spreadsheet where I am transfering numbers from paper.
Each
cell has a set amount of digits. For example the first cell is a 3 digit
number. The next a 4 digit number, then a 2 digit number.
Is there anyway I can set it up just like some web pages that have phone
numbers, so that when I input the 3 digit number the cursor jumps to the
next
cell, then input the 4 digits, jumps to the next cell and I put in the 2
digit number.
Thanks for the help.
|