Excel Keyboard Locked? How to Unlock It

How-to basics · Updated November 19, 2026

If your keyboard seems locked in Excel, first press Esc, check whether Scroll Lock is on, and see whether the worksheet is protected. Excel does not have one universal keyboard-lock switch: the right fix depends on whether keys are being ignored, arrow keys are scrolling, or edits are blocked.

Identify what is actually locked

Notice what happens when you press a key. If arrow keys move the worksheet view instead of moving the selected cell, Scroll Lock is the likely cause. If you can move around but cannot change certain cells, sheet protection or cell-level restrictions are more likely. If typing does nothing anywhere in the workbook, check for a dialog box, a stuck key, or a problem outside Excel.

Try a harmless check before changing settings: click an ordinary cell, type a short test value, and press Esc to cancel if you do not want to keep it. If a message appears, read it; Excel may be explaining that the cell is protected or that an operation is unavailable. Also look for a dialog window hidden behind the workbook. Press Esc once to dismiss or cancel a current action, and use Alt+Tab on Windows to check whether another window is waiting for input.

These symptoms are different from a frozen workbook. If Excel does not respond to clicks, key presses, or window controls, wait briefly in case it is calculating or processing a large file. If the whole application remains unresponsive, the issue may be Excel or the computer rather than a keyboard lock.

Turn off Scroll Lock

Scroll Lock changes how the arrow keys behave in Excel. When it is on, pressing an arrow key scrolls the worksheet while the active cell stays selected. It does not normally prevent typing into cells, so it is a good match when navigation feels wrong but other keys still work.

  1. Look at Excel’s status bar along the bottom of the window for Scroll Lock.
  2. If the indicator is not shown, right-click the status bar and check whether Scroll Lock is selected in the list of status-bar options.
  3. Press the ScrLk or Scroll Lock key on your keyboard once, then test an arrow key.

Many laptop keyboards do not have a dedicated ScrLk key. The key combination depends on the computer maker and model, and may use Fn with another key; check the keyboard labels or the manufacturer’s instructions rather than assuming one combination works everywhere. On Windows, you can also open the On-Screen Keyboard from Settings > Accessibility > Keyboard. If ScrLk is shown there, click it to toggle Scroll Lock, then return to Excel and check the status bar.

Scroll Lock is not the same as freezing panes. View > Freeze Panes keeps selected rows or columns visible while you move through a sheet; it does not change how arrow keys select cells. Turning off Freeze Panes will not fix arrow keys that scroll because Scroll Lock is active.

Check worksheet protection and locked cells

If you can select cells but Excel refuses to change their contents, check worksheet protection. In Excel for Microsoft 365 on Windows, open the Review tab and select Unprotect Sheet. If the sheet was protected with a password, Excel asks for it. You need the password or help from the person who protected the sheet; the Unprotect Sheet command is not a way to bypass a forgotten password.

Protection is often used to keep formulas, headings, or layout from being changed while leaving designated input cells editable. As a result, a protected worksheet may still let you select cells, use some keyboard shortcuts, and enter data in unlocked cells. A message such as “The cell or chart you’re trying to change is on a protected sheet” points to protection rather than a failed keyboard.

Protection can apply to only some parts of a worksheet. If one cell accepts input but a neighboring one does not, that difference may be intentional. Ask the workbook owner which cells are meant for entry before removing protection; doing so may allow accidental changes to formulas or other important content. Workbook-structure protection is different: it restricts actions such as adding, deleting, moving, or renaming sheets, but does not by itself lock ordinary cell editing.

Exit a mode that changes key behavior

Excel can be waiting for a specific action rather than ignoring the keyboard. Press Esc to cancel a partially entered formula, close many menus, or leave a selection mode. If you see a moving dashed border around copied cells, Excel is still in copy mode; Esc ends that marching-ants outline. If you are editing inside a cell, the arrow keys may move the insertion point through the text instead of selecting another cell. Press Enter to finish editing or Esc to cancel it.

F2 switches the active cell into edit mode in many Windows Excel setups. A laptop may require Fn+F2, depending on its function-key settings. When Excel is in edit mode, the formula bar or cell text is being edited, so arrow keys behaving differently is expected. Press Esc if you do not want to keep the edit, or Enter to commit it. Be careful: Enter saves the current cell edit; it is not a general unlock command.

Also check whether a menu, search box, formula bar, or warning dialog has focus. Click the worksheet grid once before testing typing. If a cell is selected and you begin typing, Excel normally replaces that cell’s existing contents when you confirm the entry. If you mean to add text to the end of existing contents, enter edit mode first rather than treating the replacement behavior as a keyboard fault.

When Excel ignores every key

First determine whether the problem is limited to one workbook. Open a blank workbook and try typing in a cell. You can also test typing in another application, such as Notepad. If typing fails in other applications too, focus on the keyboard or Windows settings rather than Excel.

  • Check that the keyboard is connected, switched on, and charged if it is wireless. Reconnect it or try another USB port where appropriate.
  • Press keys such as Ctrl, Shift, Alt, and Fn once each in case one is physically stuck. A held modifier can make ordinary keys behave unexpectedly.
  • On Windows, open Settings > Accessibility > Keyboard and check whether Filter Keys or Sticky Keys is enabled. These accessibility features change how repeated or combined key presses are handled; turn them off only if you do not need them.
  • Close any open dialog and click the worksheet grid. A dialog can make the workbook appear to have stopped accepting input until it is dismissed.

If the issue occurs only in Excel, save your work if possible and restart the application. To check whether an add-in is involved, close Excel, press Windows key+R, enter excel /safe, and press Enter. If the keyboard works in Safe Mode, an add-in or startup customization may be contributing; review installed Excel add-ins through File > Options > Add-ins. Safe Mode is a diagnostic step, not a permanent repair, and it does not prove which add-in is responsible.

A careful order for troubleshooting

Work from simple, reversible checks toward less common causes. This keeps a navigation setting from being mistaken for protection and reduces the chance of changing a workbook unnecessarily.

  1. Click a regular worksheet cell and press Esc once.
  2. Test whether typing works in that cell, then test an arrow key and observe whether the active cell moves.
  3. Check the status bar for Scroll Lock and toggle it off if necessary.
  4. If edits are blocked, look for a protection message and use Review > Unprotect Sheet only when you have permission and, if required, the password.
  5. Try a blank workbook and another application to determine whether the fault is workbook-specific, Excel-specific, or system-wide.
  6. For a system-wide problem, inspect the keyboard connection and accessibility settings. For an Excel-only problem, restart Excel and investigate add-ins if needed.

Before changing a shared or important workbook, make a copy or confirm that it is saved in a recoverable location. Avoid repeatedly pressing keys at random: if Excel is in cell-edit mode, for example, additional typing can alter the contents rather than unlock anything.

Differences on Mac and Excel for the web

On a Mac, the same basic diagnosis applies: distinguish Scroll Lock behavior from protected cells and from a keyboard that is not responding elsewhere. Many Mac keyboards do not include a dedicated Scroll Lock key, and key availability or function-key behavior varies by keyboard. Check Excel’s status bar and the keyboard documentation for the appropriate way to toggle it. The Review tab contains sheet-protection controls in desktop Excel for Mac, although the exact layout can vary by release.

Excel for the web runs in a browser, so browser focus matters: click the worksheet grid and check that a browser dialog or another tab is not intercepting keys. Its ribbon and protection controls can differ from desktop Excel. If the workbook owner has restricted editing or the sheet is protected, ask them to grant the needed access rather than trying to work around it. For a keyboard problem that also affects other websites or apps, troubleshoot the device or operating system instead of the workbook.

Frequently Asked Questions

Why do my arrow keys scroll the Excel sheet instead of moving between cells?
Scroll Lock is probably on. Toggle the ScrLk key, or use the Windows On-Screen Keyboard if your physical keyboard has no Scroll Lock key. Confirm that the Scroll Lock indicator is off in Excel’s status bar.

How do I unlock a protected Excel sheet?
In desktop Excel for Microsoft 365 on Windows, select Review > Unprotect Sheet. Enter the password if Excel asks for it. If you do not know the password, contact the workbook owner; Excel does not provide a normal command to remove protection without the required credentials.

Why can I type in some cells but not others?
The sheet may be protected, with only selected cells unlocked for entry. Check whether Excel displays a protection message and ask the workbook owner which cells are intended for editing. Do not assume that the keyboard is broken just because one cell rejects input.

What should I do if no keys work anywhere in Excel?
Dismiss any dialog, click a cell, and test the keyboard in a blank workbook and another application. If it fails elsewhere too, check the connection, battery, stuck modifier keys, and Windows accessibility settings. If it fails only in Excel, restart Excel and consider checking add-ins.

Does Freeze Panes lock the keyboard?
No. Freeze Panes keeps chosen rows or columns visible as you scroll; it does not lock typing or make arrow keys scroll the sheet. Scroll Lock, not Freeze Panes, is the setting to check when arrow-key navigation behaves that way.

Related

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.