Excel guide · 5 min read
Excel Tab key not working: why it happens and how to fix it
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.
| Row | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Date | Customer | Item | Qty | Price | Total |
| 2 | Nov 2, 2026 | Harbor Cafe | Oat milk 1L | 24 | 2.15 | 51.6 |
| 3 | Nov 2, 2026 | Lakeview Deli | Sourdough loaf | 18 | 3.4 | 61.2 |
| 4 | Nov 3, 2026 | Harbor Cafe | Espresso beans 1kg | 6 | 17.5 | 105 |
| 5 | Nov 4, 2026 | Northside Gym | Protein bar box | 10 | 21 | 210 |
| 6 | Nov 5, 2026 | Lakeview Deli | Oat milk 1L | 12 | 2.15 | 25.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.
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
- Excel keyboard shortcuts not working: causes and fixes
- Excel Enter key moves the wrong direction? How to fix it
- Excel arrow keys not working: 6 fixes
- How to lock cells with formulas in Excel
- How to find a circular reference in Excel (and fix it)
- COUNTIFS not working: why it returns 0 or #VALUE!
- Excel wrap text not working: 6 fixes
Updated