tab direction

[Nikusha]

How do I change the direction that the cells are selected when I hit the tab
key. They currently go from left to right, but I would like them to go from
top to bottom. The worksheet is protected, has open cells and is being used
as a form. Thanks for any help.

 

[Niek Otten]

If it's for data entry, Tools>Options>Edit, change the "Direction" after
"Move selection after Enter"

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Bob Phillips]

For a custom order, see http://www.xldynamic.com/source/xld.xlFAQ0008.html