Office Settings & Configuration

Fix Excel Tab Key Selecting the Name Box Instead of Cells

Aamir Naveed AkramAamir Naveed Akram Nov 18, 2026 869 views

Question details

The user needs Excel's Tab key to move between worksheet cells rather than through interface controls.

Fix Excel Tab Key Selecting the Name Box Instead of Cells
Product
Microsoft Excel
Device & OS
not provided
Scenario
Navigating a worksheet with the Tab key.
Observed behavior
Pressing Tab moves focus through interface controls, including the Name Box, instead of advancing to the next worksheet cell.
Before you start

Click a worksheet cell and press Tab to confirm the behavior, then test Tab in another application. Note whether the problem occurs in all Excel workbooks or only one.

Solution 1

Check Worksheet Focus and Protection in Excel

Use these checks when Tab is moving through controls or the issue occurs in a particular workbook.

1
Return focus to the sheet

Press Esc to close any active menu or dialog, click a worksheet cell, and press Tab again.

2
Check protection

Open the Review tab and look for Unprotect Sheet. If the sheet is protected, ask its owner whether you can unprotect it or select the cells you need.

3
Compare another workbook

Use File > New to open a blank workbook, click a cell, and press Tab. If it works there, review the original workbook's protection and settings.

4
Check Scroll Lock

If Scroll Lock is enabled, turn it off using the ScrLk key or your device's on-screen keyboard. Scroll Lock mainly affects arrow-key navigation, so it may not explain the Tab behavior.

Free Microsoft Office alternative

Navigate Spreadsheets with WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files in WPS Spreadsheets for an easy transition, though switching apps does not fix an Excel-specific or system-wide keyboard conflict.

Navigate worksheet cells with familiar keyboard controlsOpen and edit Microsoft Excel formats, including XLSX and XLSUse a familiar spreadsheet interface for an easier transitionWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does Tab select the Name Box instead of the next cell?

Focus may be on an interface control, or an add-in or external utility may be interfering with the key. Press Esc, click a worksheet cell, and test Tab; then check add-ins and monitor or keyboard software.

Can a protected worksheet affect Tab navigation?

Yes. Protection can restrict which cells you can select. Open the Review tab and look for Unprotect Sheet, or ask the workbook owner about the permitted cells.

How do I test Excel without add-ins?

On Windows, close Excel, press Windows+R, enter excel /safe, and select OK. Test Tab in a worksheet; if it works, review add-ins under File > Options > Add-ins.

Can LG monitor software interfere with Excel's Tab key?

It did in the reported case. If LG OnScreen Control is installed, quit or disable it temporarily and test Tab in Excel. If navigation returns, consider leaving it disabled or uninstalling it.