Immediately jump to next cell?

  • Thread starter Thread starter ivankamastelic
  • Start date Start date
I

ivankamastelic

I have a chart with 5 rows and in each cell will be only one number.
How to create that immediately after I insert a single number it jumps
to next cell below without even pressing enter?
Thanks in advance!
 
You cannot do this.

When you are entering data in a cell, Excel needs some type of signal that you
have finished with that cell.

ENTER or Tab or mouse-click or arrow out of the cell.

Code will not work while in editing mode so VBA will not get you there either.


Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Excel JUMP FROM SEARCH BAR TO RESULT 3
Immediately jump to next cell? 4
Using Tab key to jump to specific cell 2
Jumping to the next cell automaticly 3
On exit from edit, Excel jumps to remote undesired cell. 2
Jump when copying a list of cells 3
Excel opening cell 2

Back
Top