Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 22nd 05, 05:08 PM posted to microsoft.public.excel.worksheet.functions
Shar
 
Posts: n/a
Default 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?

  #2   Report Post  
Old November 22nd 05, 05:53 PM posted to microsoft.public.excel.worksheet.functions
Richard Buttrey
 
Posts: n/a
Default 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
__
  #3   Report Post  
Old November 22nd 05, 09:38 PM posted to microsoft.public.excel.worksheet.functions
Gord Dibben
 
Posts: n/a
Default 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
__




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
autosend for excel worksheets for distribution list option Nicole Excel Worksheet Functions 0 August 26th 05 05:37 PM
Excel startup option GeraldM Excel Discussion (Misc queries) 2 July 26th 05 01:13 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
Excel - option to extend function in cell to column kjoshua777 Excel Worksheet Functions 2 November 18th 04 01:08 AM
Excel Key Field option? Nicki Nixon Excel Worksheet Functions 2 November 14th 04 06:56 PM


All times are GMT +1. The time now is 03:21 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017