How to skip cells or columns when tabbing in Excel?

By default, pressing the Tab key in Excel will move from a cell to the next one horizontally. For some Excel users, they tend to skip cells when tabbing in Excel. For example, cell A1 is selecting now, after pressing the Tab key, it will jump to cell C1 directly with skipping the cell B1, and pressing the Tab key again will skip the cell D1 and move to E1 as below screenshot shown. How to achieve it? The method in this article can help you.

Skip cells or columns when tabbing with VBA code

Skip cells or columns when tabbing with VBA code

Please do as follows to skip cells or columns when tabbing in Excel by using VBA code.

1. In the worksheet you need to skip cells when tabbing, please right click the sheet tab, and click View Code from the context menu.

2. In the opening Microsoft Visual Basic for Applications window, please copy and paste the below VBA code into the Code window.

VBA code: Skip cells or columns when tabbing in Excel

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Static sRg As Range
    Dim ColumnOffset As Integer
    If Target.Count > 1 Then Exit Sub
    If Not Intersect(Target, Union([B:B], [D:D], [F:F])) Is Nothing Then
        With Target
        Application.EnableEvents = False
        If Not sRg Is Nothing Then
            If sRg.Column < .Column Then
                ColumnOffset = 1
            ElseIf .Column <> 1 Then
                ColumnOffset = -1
            End If
        Else
            ColumnOffset = 1
        End If
        .Offset(, ColumnOffset).Select
        Application.EnableEvents = True
        End With
    End If
    Set sRg = ActiveCell
End Sub

Note: In the code, [B:B], [D:D], [F:F] are columns you will skip when pressing the Tab key. You can change them as you need, and you can add new column you need to skip into the code.

3. Press the Alt + Q keys to exit the Microsoft Visual Basic for Applications window.

From now on, when tabbing in Excel, the specified column cells will be skipped automatically. At the same time, you can only click these specified columns, the skipped columns will not be selected or edited.