ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Is there an "auto tab" option in excel? (https://www.excelbanter.com/excel-worksheet-functions/56794-there-auto-tab-option-excel.html)

Shar November 22nd 05 05:08 PM

Is there an "auto tab" option 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?

Richard Buttrey November 22nd 05 05:53 PM

Is there an "auto tab" option in excel?
 
On Tue, 22 Nov 2005 09:08:08 -0800, "Shar" <Shar
@discussions.microsoft.com wrote:

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?


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

HTH

Richard Buttrey
__

Gord Dibben November 22nd 05 09:38 PM

Is there an "auto tab" option in excel?
 
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

On Tue, 22 Nov 2005 17:53:11 +0000, Richard Buttrey
wrote:

On Tue, 22 Nov 2005 09:08:08 -0800, "Shar" <Shar
wrote:

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?


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

HTH

Richard Buttrey
__




All times are GMT +1. The time now is 03:07 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
ExcelBanter.com