Tab key moves down instead of right in Excel

When I use the Tab key while in Excel, the cell moves down instead of to the right.
How can I get the active cell to move to the right when the tab key is pressed?

2 Answers

Like I mentioned in the comment above, generally the focus should move to the right. The only instance when it moves down is when the columns on the right are locked and the worksheet protected.

If you worksheet is not protected and you are still facing that problem then here is a VBA Code which can help you achieve what you want.

Option Explicit
Sub SettabKey() Application.OnKey "{TAB}", "MoveDown"
End Sub
Sub MoveDown() If TypeOf Selection Is Range Then _ ActiveCell.Offset(, 1).Select
End Sub

To reset it use Application.OnKey "{TAB}"

Please note this is not for the latest versions of office. You didnt specify.

Go to Tool | Option | Edit |
Move selection after enter
Change the direction to Down

Source

The office website has information on this as well, although it states there is no way to change the direction of tab within the program Source.

I expect it is possible to use VBA to do this however although I do not have the skills required to build the function.