Is there an "auto tab" option in excel?

S

Shar

I have a graph set up and would like the tab to automatically move to the
next cell after i type one number/letter in the cell. Is it possible to set
up this up in Excel?
 
R

Richard Buttrey

I have a graph set up and would like the tab to automatically move to the
next cell after i type one number/letter in the cell. Is it possible to set
up this up in Excel?
Click to expand...

Tools - Options - Edit tab - select the "Move selection after Enter"
option - choose the direction of travel to your next cell - OK

HTH

Richard Buttrey
__
 
G

Gord Dibben

Shar

You must tell Excel you are ready to move to the next cell.

Enter, Tab, mouse click......your choice.

No way to just enter a number/letter and have Excel move out of the cell.

SelectionChange or Change Event code runs only on completion of the cell edit.


Gord Dibben Excel MVP
 
Top