Can the tab order be changed in Excell?

[rpanderson]

I am trying to make the tab order vertical, but by default it's horizontal.

Is there a way to change the tab order in Excell?

 

[Gord Dibben]

No, the default TAB order cannot be changed to Vertical, but there are
work-arounds.

See the info here at Bob Phillips' site.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

There is another method which involves VBA Worksheet event code. If
interested in that, post back.


Gord Dibben Excel MVP

 

[Pam Coleman]

No, the default tab order cannot. You can use the down arrow to move down,
or on the Tools, Options, Edit, change the direction to down and then when
you press the Enter Key the cursor will move down.