Tab key moves down instead of right in Excel

Question

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?

Solution

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}"

Comments

[Admin]

Cool. Do you have a question or were you just sharing?

[Siddharth Rout]

In my excel, it moves to the right. By any chance the columns on the right are locked?

[K.A.Monica]

That only affects what happens after hitting enter, not tab.

[Adsy2010]

thanks. I just used a quick search to find that info. Have updated answer with info from MS Office site.