Timeout on data entry

D

Dan Wilson

Good day. I am using Excel 2002. I just noticed an
interesting phenomenon about data entry.

When entering data into a cell, I have a second or less
between keystrokes to correct any errors.

For example, if I enter

This is a tst sentence

If I notice that the word test is misspelled and want to
fix it, I have to do it immediately. If I wait more than
one second at the end of the text and then try to use the
back-arrow key to move the cursor, I end up moving the
cursor into the cells to the left of the entry.

Is there an option that I have not found to correct this?

Thanks, Danno...
 
C

Charlie

The backspace key will let you edit typing errors while
still in the enter mode of a cell. The right, left, up
and down arrows are the same a using the enter key. The
best place to correct an error is in the formular bar.
Just place the cursor where the error is and correct it.
 
D

Dan Wilson

Good day Charlie,

Thanks for the quick response. Not quite the answer I was
hoping for, but I think you're telling me that there is no
way to cure this problem.

The interesting part of this is that if I detect the error
quick enough, the back-arrow key does allow me to move the
cursor left and fix the error. Yes, I agree that the
error can be fixed in the formula bar. And, if I detect
the error after moving out of the cell, placing the cursor
in the cell allows full use of the arrow keys. There must
be a timer setup on the initial data entry into a cell.
If you don't type any keys within one second, the timer
shuts off and the arrow keys take on a new function.

Thanks, Danno...
 
G

Gord Dibben

Danno

Haven't got the original thread in front of me but when you start entering
something in a cell you will see "Enter" on the Status Bar.

Hit F2 and it will change to "Edit".

You can now use the arrow keys forth and back to edit entries without leaving
the cell.

Has nothing to do with a "timer" on data entry.

Gord Dibben Excel MVP
 
Top