Is there an "auto tab" option in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
__
 
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
 

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

Is it possible to have an image as a background? 0
Auto-tab 1
Excel automatic tab 1
Auto Fill function in Excel 2007 not working properly 3
Excel-tab, spacebar etc seemed to be locked-can't repeat key stro 1
Drop down tabs that can auto fill certain information? 3
Pick List + Alphabetical Skip To or Auto Complete 2
How to auto tab 1

Back
Top