Forum Discussion
Enter Number in cell and automaticaly tab to next cell
I want to enter a number in one cell and then automatically tab to next cell and continue for at least nine cells.
6 Replies
- It can be done but what exactly you want. like if yoiu want that if yoiu type one digit it should move to next cell or two digits then to next cell. You have to be very specific.
I am trying to enter one digit in a cell and then having Excel tab over to next cell. I am trying to avoid using the tab key after each entry.
I am trying to enter one digit in a cell and then having Excel tab over to next cell. I am trying to avoid using the tab key after each entry.
"enter" means what?
If you mean touch the "Enter" or "Return" key, then that preference setting I gave you will work.
If you literally mean only that you want to type a single digit and have it entered and the active selection moved, then as @gyankosh has said, maybe you could come up with a VBA routine or some such. But of course, that has to be activated too, and yes, something could no doubt be written that would keep looping until you hit "Esc" or some such....
How many thousand digits are you planning on entering in this way? Will you not want sometimes to go right, others down? Is there quality control along the way? If the digits are random, you could use the random number function.... if they're not, then a little more time might reward the slowness.
Go to Excel Preferences and open the window for setting Edit preferences. The 7th main item on the list allows you to tell Excel where to move your selection to, down, right....whatever
