How to Change Tabbing Order in Excel (4 Easy Methods)


Download the Practice Workbook

You can download the practice workbook from here.

4 Easy Methods to Change Tabbing Order in Excel

We have created a simple and concise user form. It has 4 text boxes namely Customer ID, First Name, Last Name, and Email. We will see show how to navigate between these text boxes by setting a custom tab order.

excel tabbing order

Method 1 – Changing the Tabbing Order from View Tab in VBA Window


  • In the VBA window, click on View.
  • Select Tab Order.

view tab to change tabbing order in excel

  • This will open the Tab Order window where you will see all the text boxes.
  • Click on the Move Up or Move Down buttons to set the tabbing order.
  • Click OK once you are done.

Method 2 – Set the Tabbing Order from the UserForm


  • Right-click on the UserForm that you are currently working with.
  • Select Tab Order.
  • You should see the Tab Order window as previously and can change the order from there.

right click on user form to change tabbing order in excel

Read More: How to Create Excel VBA UserForm (with Detailed Steps)

Method 3 – Manually Inserting a TabIndex


  • Click on any of the text boxes.
  • Navigate to the Properties window and click on TabIndex.
  • Enter the TabIndex of the first text box as 0.
  • Enter 1 for the next text box in the sequence, 2 for the next one, and so on.
  • This will set the tab order for the text boxes.

Similar Readings

Method 4 – Using Ctrl and Left Mouse Button


  • Press and hold Ctrl, then click on the text boxes in the order that you want to tab.

shortcut to change tabbing order in excel

  • Go to the Properties window and type 0 in TabIndex.
  • This should set the tab order that you selected.

How to Set a Tab Order in Protected Excel Sheet


  • Right-click on the tab of the protected sheet and click on View Code.

change tabbing order in protected sheet in excel

  • Insert the following code in the new VBA window with the name of the sheet.
  • When you insert data in the selected cells and press the tab key, this will follow the cell sequence that you set in the code.
Private Sub Set_Order_Protected_Sheet(ByVal trgt As Range)
    Dim tabArr As Variant
    Dim n As Long
    tabArr = Array("B5", "C6", "D7", "E8")
    Application.ScreenUpdating = False
    For n = LBound(tabArr) To UBound(tabArr)
        If tabArr(n) = trgt.Address(0, 0) Then
            If n = UBound(tabArr) Then
                Me.Range(tabArr(n + 1)).Select
            End If
        End If
    Next n
    Application.ScreenUpdating = True
End Sub

Related Articles

Get FREE Advanced Excel Exercises with Solutions!


Kawser Ahmed
Kawser Ahmed

Kawser Ahmed is a Microsoft Excel Expert, Udemy Course Instructor, Data Analyst, Finance professional, and Chief Editor of ExcelDemy. He is the founder and CEO of SOFTEKO (a software and content marketing company). He has a B.Sc in Electrical and Electronics Engineering. As a Udemy instructor, he offers 8 acclaimed Excel courses, one selected for Udemy Business. A devoted MS Excel enthusiast, Kawser has contributed over 200 articles and reviewed thousands more. His expertise extends to Data Analysis,... Read Full Bio

1 Comment

Leave a reply

Advanced Excel Exercises with Solutions PDF