Excel Not Tabbing to Next Cell? Fixes That Work

In Excel for Microsoft 365 on Windows, pressing Tab while a worksheet cell is selected normally commits any entry and moves the selection one cell to the right. If it does not, first press Enter or Esc to leave cell editing, click a worksheet cell, and try Tab again; if movement skips cells or stays inside a block, check whether the sheet is protected or a range is selected.

What Tab normally does in Excel

Tab is a navigation key when the worksheet grid has focus. With one ordinary cell selected, it moves the active cell to the next column on the right. For example, from C4 it normally moves to D4. It does not move down a column: Enter usually moves down after confirming an entry, according to Excel’s current Enter setting.

Tab also confirms an entry you have just typed. If you enter a value in C4 and press Tab, Excel keeps the value and selects D4. This makes the key useful for filling in rows of a form or entering records across columns. A worksheet’s current selection, protection, and editing state can change what you see, even though the key itself has not necessarily stopped working.

Keep the difference between Tab and Enter in mind when diagnosing the problem. If Excel moves down when you expect it to move right, you may be pressing Enter, or you may be seeing a setting that controls Enter’s direction. That setting does not control Tab’s normal left-to-right movement.

Run a quick check before changing settings

Try these checks in order. They help distinguish a navigation problem from a key that is being used for another task:

Click a blank cell in the worksheet grid, then press Tab once. If the selection moves right, the key works and the original focus or editing state was the issue.
Type a short test value in a blank cell and press Tab. Excel should keep the value and select the cell to its right. Press Ctrl+Z on Windows to undo the test entry if appropriate; on Mac, use Command+Z.
Look at the selected cells. If a rectangular group is highlighted, Tab may be cycling through that selection instead of moving beyond it.
Check the Review tab for worksheet protection. A protected sheet can restrict which cells Excel can select.
Try Tab in another workbook or a simple new worksheet. If it works there, the cause is more likely a feature or setting in the original workbook than a failed key.

If Tab fails in other applications too, inspect the keyboard or operating system rather than changing workbook settings. A quick test in a text editor can help establish whether the key is producing input outside Excel.

Exit cell editing and formula suggestions

Excel behaves differently when you are editing a cell than when you are navigating the grid. Editing can start when you type into a selected cell, double-click it, press F2, or click in the formula bar. A visible insertion caret, or a formula being edited above the grid, is a clue that Excel is still handling the contents of a cell.

Press Enter to accept the edit and finish, or press Esc to cancel it. Then press Tab to move to the next cell. If you are entering a formula and Excel displays an autocomplete suggestion, Tab can accept the highlighted suggestion instead of acting as ordinary worksheet navigation. This is expected: Excel is interpreting Tab in the context of formula entry. Press Esc to dismiss a suggestion, or finish the formula and commit it before testing cell movement.

There is another possible focus issue: a click in the formula bar or a ribbon control puts the cursor outside the worksheet grid. In that state, Tab may move among interface controls rather than cells. Clicking the intended cell is usually the fastest way to return focus to the grid. On Windows, Esc can also close or back out of some active interface states, but clicking a cell is the most reliable check.

Check whether the worksheet is protected

Protection is a common explanation when Tab moves past some cells but not others, or appears to jump to a distant cell. A protected worksheet can be configured so users select only unlocked cells. Excel then uses Tab to move among cells that are available for selection, skipping locked cells rather than visiting every cell in sequence.

To check, open the Review tab. If the command shown is Unprotect Sheet, protection is active. If you are authorized to edit the workbook, choose Unprotect Sheet; Excel may ask for a password. Do not try to bypass a password you do not have. If protection is required, ask the workbook owner to adjust the allowed selections instead.

When setting up protection, the sheet owner can choose which selection actions are allowed in the Protect Sheet dialog, including selecting locked or unlocked cells. Cells are marked as locked or unlocked through Format Cells > Protection, but the Locked property takes effect only when the worksheet is protected. This is useful for forms: users can Tab through the intended input cells without landing in formula cells. It can look like a navigation fault when that behavior was deliberately configured.

See whether Tab is cycling inside a selected range

When you select a block of cells, Excel can keep Tab navigation within that block. For instance, if A1:D1 is selected, pressing Tab advances through the selected cells rather than immediately moving into E1. That behavior is useful when entering a row of data while keeping the working area limited. It is not the same as a key failing to move.

To return to ordinary navigation, click a single cell outside the highlighted block and press Tab. If you need to fill a rectangular range, select it first and use Tab to advance through its cells. The direction through a selected block can be affected by how the range was selected, so watch the active-cell outline rather than assuming Excel will leave the block at its right edge.

Also distinguish a selected range from a multi-cell copy outline. If a dashed border remains around copied cells, Excel is in copy mode; that outline alone does not mean the Tab key is broken. Press Esc to cancel the copy operation, click a single cell, and try again.

Consider tables, merged cells, and worksheet layout

Excel tables have a useful special case: when you reach the last cell in the last row of a table and press Tab, Excel can create a new table row. If you expected to move into a cell outside the table, the new row may seem surprising. Check whether the active cell is at the bottom-right of a table before treating that result as an error.

Merged cells can make navigation less predictable because several grid cells are presented as one larger cell. A worksheet with merged headings or form fields may not follow the simple one-cell-at-a-time pattern users expect. If Tab behaves oddly in one area, try the same key in an unmerged section. For a sheet used as a data-entry form, avoiding unnecessary merged cells can make keyboard navigation clearer.

Hidden columns do not necessarily mean Tab is broken. The next visible cell may appear to be several columns away because one or more columns between the cells are hidden. Unhide the columns temporarily if you need to confirm the underlying sequence.

Check Excel settings and version differences

Excel does not provide a general setting that changes Tab’s basic job of moving to the next available cell to the right. A setting that often causes confusion is the Enter direction. On Windows, open File > Options > Advanced and look under Editing options for After pressing Enter, move selection. That option applies to Enter, not Tab. Changing it will not repair Tab navigation.

On Mac, Excel’s application settings and ribbon layout differ from Windows, but Tab still normally advances to the next worksheet cell when the grid has focus. The Mac equivalent for undoing a test entry is Command+Z rather than Ctrl+Z. In Excel for the web, Tab also works in the worksheet grid, but focus can be on browser or Excel interface controls; click a cell before testing. Browser shortcuts and accessibility tools may also affect keyboard focus, so compare behavior in the desktop app if available.

There is no need to reinstall Excel just because Tab behaves differently in one sheet. First compare a protected and an unprotected sheet, a selected range and a single cell, and cell editing versus normal selection. These simple comparisons usually identify whether the behavior comes from workbook design, Excel’s current focus, or the keyboard itself.

Frequently Asked Questions

Why does Tab move to the next row instead of the next column?
Tab normally moves right. If the active cell appears to move down, check whether the selected area or a table is affecting navigation, and confirm that you pressed Tab rather than Enter. The After pressing Enter setting changes Enter’s behavior only.

Why does Tab skip cells in a protected worksheet?
The sheet may be set to allow selection of unlocked cells only. Excel moves among those cells and skips locked ones. Check Review > Unprotect Sheet if you are permitted to do so, or ask the workbook owner to change the protection options.

How do I make Tab move through only the cells I want?
A workbook owner can unlock intended input cells and protect the worksheet with selection limited to unlocked cells. This creates a controlled path through a form while keeping formula cells protected. Make a copy before changing a workbook’s protection or cell settings.

Why does Tab stay within the highlighted cells?
You may have selected a multi-cell range. Excel can cycle through the selected block so you can fill it without leaving the area. Click one cell to resume normal worksheet navigation.

Does Scroll Lock stop Tab from working?
Scroll Lock is mainly associated with how arrow keys move around a worksheet; it is not the usual cause of Tab failing to advance to the next cell. Check focus, editing mode, selected ranges, and protection first.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.