Cellwise Start free

Excel guide · 5 min read

Excel Tab key not working: why it happens and how to fix it

Quick answerTab normally moves one cell right (Shift+Tab moves left). If it seems stuck, the usual cause is a selected range: Tab then cycles only through the selected cells, so click a single cell and try again. Other causes are Formula AutoComplete (Tab inserts the highlighted function), a protected sheet (Tab jumps only to unlocked cells), an Excel table (Tab wraps to the next row and adds a new one at the end), hidden columns, and a stuck Ctrl or Alt key turning Tab into Ctrl+Tab or Alt+Tab.

Still not working on your sheet? Paste your cells and the formula into Cellwise Fix. The engine shows which cause it is on your data, then you get the fix, checked. Open Cellwise Fix

Sample data

Every result on this page was calculated from this sheet by the same spreadsheet engine the Cellwise app uses.

RowABCDEF
1DateCustomerItemQtyPriceTotal
2Nov 2, 2026Harbor CafeOat milk 1L242.1551.6
3Nov 2, 2026Lakeview DeliSourdough loaf183.461.2
4Nov 3, 2026Harbor CafeEspresso beans 1kg617.5105
5Nov 4, 2026Northside GymProtein bar box1021210
6Nov 5, 2026Lakeview DeliOat milk 1L122.1525.8

Download this sheet as an Excel practice file (.xlsx)

Quick checks first

Work through these in order. Most "Tab is broken" reports are one of the first three, and none of them is a fault: it's Excel doing something on purpose that looks wrong when you don't expect it.

  • More than one cell selected? Tab stays inside the selection. Click one cell.
  • Typing a formula with a list of function names showing? Tab picks the function.
  • Is the sheet protected (Review > Unprotect Sheet is available)? Tab visits only unlocked cells.
  • Is the data an Excel table (a Table Design tab appears when you click it)? Tab wraps inside the table.
  • Does Tab work in Notepad or a browser box? If not, it's the keyboard or the remote session, not Excel.

1. A selected range keeps Tab inside it

When more than one cell is selected, Tab moves the active cell through the selection instead of across the sheet: left to right along the first row, then to the start of the next row of the selection, and back to the top after the last cell. The selection stays highlighted, so it looks as if Tab is jumping back or refusing to leave a block of cells.

It often happens after you selected a range to format it, or after Ctrl+A. Click any single cell (or press an arrow key) to drop the selection, and Tab goes back to moving one cell right.

This is also a feature. Select A7:E9 before typing three new orders and Tab walks you through exactly those cells, wrapping to the next row on its own.

2. Formula AutoComplete takes the Tab

While you type a formula, Excel shows a list of matching functions. With that list open, Tab doesn't move to the next cell: it inserts the highlighted function name and an opening bracket. Type =SU and press Tab, and you get =SUM( instead of moving right.

That's the quickest way to enter function names, so keep it. When the formula is finished and the list has gone, Tab confirms it and moves right as usual. To stop the list appearing, untick File > Options > Formulas > Formula AutoComplete.

=SUM(F2:F6)

Result: 453.6

453.60 of orders. Typing =SU, pressing Tab to insert SUM( and then selecting F2:F6 enters this formula without typing the function name in full.

3. Protected sheets, tables and hidden columns

On a protected sheet, Tab jumps from one unlocked cell to the next and skips everything else. If a form has only three input cells unlocked, Tab cycles between those three. That's the point of a well-built input form; to move freely, use Review > Unprotect Sheet (you may need the password). Lock cells with formulas shows how to set it up on purpose.

In an Excel table, Tab in the last column jumps to the first column of the next row of the table, not to the cell outside it. In the very last cell of the table, Tab adds a new row. If you didn't want the extra row, press Ctrl+Z.

Tab also skips hidden columns. If it seems to jump from C to F, columns D and E are hidden: select C:F, right-click a column letter and choose Unhide.

4. Tab and then Enter goes back to the first column

Type across a row with Tab, press Enter, and Excel moves down a row and back to the column where you started tabbing. It's designed for entering one record per row and isn't a Tab problem. If Enter itself goes the wrong way, see Excel Enter key moves the wrong direction.

5. Ctrl+Tab, Alt+Tab and keys that are stuck

In Excel for Windows, Ctrl+Tab switches between open Excel windows (and between tabs in a dialog box), and Alt+Tab switches between programs. If Ctrl or Alt is physically stuck, or a remote desktop session thinks it's still held down, every Tab press does one of those instead. Press and release Ctrl, Alt and Shift on both sides of the keyboard, then try again.

If Tab doesn't work in Notepad or a browser either, the problem is outside Excel: try another keyboard, check keyboard remapping software, or disconnect and reconnect the remote session. To move between sheets rather than cells, the shortcut is Ctrl+Page Down and Ctrl+Page Up, not Tab. If the arrow keys misbehave too, see Excel arrow keys not working.

6. You can't type a tab character into a cell

In a cell, Tab always confirms the entry and moves on; there's no way to type a tab character inside the text. For a line break in a cell use Alt+Enter (Ctrl+Option+Return on a Mac), and to line text up use indent (Home > Increase Indent) or separate columns.

Tab characters can still arrive in pasted data. =SUBSTITUTE(C2,CHAR(9)," ") replaces each one with a space.

7. Text boxes, controls and forms

Tab moves between cells, not between shapes, text boxes or controls you've drawn on the sheet. In a VBA UserForm, the order Tab follows is set in the VBA editor with View > Tab Order, and an ActiveX text box inserts a tab character instead of leaving when its TabKeyBehavior property is True. If your data entry form uses controls, check those settings; for most forms, unlocked cells on a protected sheet are simpler and Tab works out of the box.

Common mistakes

Reinstalling Office for a selection problem

Click a single cell first. A selected range is the most common reason Tab seems stuck.

Turning off Formula AutoComplete

Tab inserting a function name saves typing. Finish the formula, and Tab moves right again once the list closes.

Unprotecting a form to make Tab move freely

Tab jumping between input cells is what makes a protected form fast to fill. Unprotect only when you need to edit the rest.

FAQ

Why does Tab not move to the next cell in Excel?

Usually because a range is selected, so Tab stays inside it, or because the formula function list is open and Tab is inserting a function. Click one cell, or finish the formula, and try again.

Why does Tab jump to a different row in Excel?

You're at the last column of a selected range or of an Excel table, so Tab wraps to the first column of the next row. On a protected sheet it jumps to the next unlocked cell, which may be on another row.

How do I move left in Excel with the keyboard?

Shift+Tab moves one cell left, the left arrow key does the same, and Home goes to column A of the current row.

How do I put a tab inside an Excel cell?

You can't type one: Tab always moves to the next cell. Use indent or another column to line text up, or Alt+Enter for a new line inside the cell.

Functions used

Related guides

Updated