changing cell sequence
 

How do I set the order for advancing cells using the Tab key?

changing cell sequence
 

Versions prior to Excel 2007:
ToolsOptionsEdit tab advance cursor on ENTER-- make selection here

Version 2007:
Office button(top left corner)Excel Options buttonAdvanced --advance
cursor on ENTER-- make selection here

"darinm_68" wrote:

How do I set the order for advancing cells using the Tab key?

changing cell sequence
 

Darin

If you unlock some cells and protect the sheet, the tab key will toggle only
the unlocked cells. Other than that there is no setting to change the tab
key direction, just the enter key under ToolsOptions...General

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk

UK Excel User Conference In Cambridge
November 28th - December 1st 2007
Register Now @ http://www.exceluserconference.com/UKEUC.html



"darinm_68" wrote in message
...
How do I set the order for advancing cells using the Tab key?

changing cell sequence
 

Depends upon the order.

See Bob Phillips' site for more info and a couple of methods.


Gord Dibben MS Excel MVP

On Tue, 13 Nov 2007 13:31:00 -0800, darinm_68
wrote:

How do I set the order for advancing cells using the Tab key?