Excel Cell Locked When Scrolling? Causes and Fixes

How-to basics · Updated November 18, 2026

If a cell or row stays visible while you scroll in Excel, the usual cause is Freeze Panes, not a locked-cell setting. Choose View > Freeze Panes > Unfreeze Panes to remove frozen rows or columns. If the entire worksheet moves in an unexpected way, check whether Scroll Lock is on; cell protection controls editing, not scrolling.

Why a cell can appear locked in place

Excel uses a few different features that can make scrolling feel unusual. The most common is Freeze Panes: it keeps selected rows or columns visible while the rest of the worksheet moves. For example, a heading row can stay at the top while you scroll through hundreds of records. A frozen area is meant to remain visible, so it can look as though a cell is stuck.

Other features can create a similar impression. Split divides the worksheet window into independently scrollable sections. Scroll Lock changes how the arrow keys move the worksheet and active cell. Sheet protection can prevent editing certain cells, but it does not ordinarily pin them on screen. These features are separate, so the right fix depends on what you see and what happens when you scroll.

  • One or more rows or columns remain visible: check Freeze Panes.
  • The worksheet has separate panes that move independently: check Split.
  • Arrow keys move the sheet rather than the selected cell: check Scroll Lock.
  • You can select a cell but cannot change its contents: check sheet protection and cell locking.

Check what is actually staying still

Before changing settings, look at the worksheet boundaries. A thin horizontal line below a row or a vertical line beside a column can mark a frozen area. If you scroll down and the top rows remain visible, or scroll right and the first columns stay put, that is typical Freeze Panes behavior. The boundary may be subtle, especially on a busy worksheet.

Try scrolling with the mouse wheel or trackpad, rather than using the arrow keys. If the worksheet moves normally with the wheel but pressing an arrow key moves the whole view while the active cell does not change, Scroll Lock is a likely explanation. If two areas of the same worksheet move separately, the window may be split. If nothing about the view seems unusual but a cell rejects typing, investigate protection instead.

You can also check the active cell reference in the Name Box, to the left of the formula bar. After pressing an arrow key, see whether that reference changes. If it stays the same while the visible grid shifts, that is another clue that Scroll Lock is affecting keyboard navigation.

Unfreeze rows or columns

In Excel for Microsoft 365 on Windows, select View > Freeze Panes > Unfreeze Panes. The frozen rows or columns should stop remaining fixed as you scroll. Unfreezing does not delete worksheet content, change formulas, or remove formatting; it changes only how the sheet is displayed.

  1. Click a cell in the worksheet if needed so Excel has the correct sheet active.
  2. Open the View tab on the ribbon.
  3. Open the Freeze Panes menu in the Window group.
  4. Select Unfreeze Panes.

If the menu offers Freeze Panes rather than Unfreeze Panes, there may not be a frozen area on that worksheet. Check for a split window or Scroll Lock instead. Freeze settings apply to the active worksheet, so repeat the check on another sheet if the workbook has multiple tabs and the behavior occurs there too.

In Excel for Mac, use the View tab and its Freeze Panes controls; the exact menu presentation can differ by Excel version. Excel for the web also includes Freeze Panes controls on the View tab, though available commands and ribbon layout can vary. If a workbook is open in a browser and a command is missing, opening it in the desktop app may expose the full set of window controls.

Freeze panes correctly when you do want them

Freeze Panes is useful when you need headings or identifiers to remain visible in a long worksheet. Excel freezes rows above and columns to the left of the selected cell. That means the selection matters: choose a cell immediately below the rows and immediately to the right of the columns you want to keep visible, then choose View > Freeze Panes > Freeze Panes.

For example, suppose row 1 contains column headings and columns A and B contain a customer ID and name. To keep row 1 and columns A:B visible, select cell C2, then apply Freeze Panes. The two columns to the left and the one row above the selected cell remain in place. If you select A2 instead, only the row above is frozen; if you select C1, only columns A:B are frozen.

Excel also provides shortcuts in the same menu for common layouts: Freeze Top Row and Freeze First Column. These options are convenient when you need only one heading row or one identifier column. If you need a different combination, use the selected-cell method. To change an existing arrangement, unfreeze it first, select the appropriate cell, and apply the new setting.

Distinguish Freeze Panes from Split

Split divides the worksheet window into separate panes, each with its own scroll position. Unlike a typical frozen heading, a split can create multiple sections that you can scroll independently. This may be helpful when comparing distant parts of a worksheet, but it can be confusing if it was enabled accidentally.

On Windows, go to View > Split to toggle the split off. If the worksheet has visible pane dividers and different sections respond separately to scrolling, this is a strong clue that Split is active. Freeze Panes and Split are related window-view tools, but they do different jobs: Freeze Panes keeps designated rows or columns visible while scrolling the rest; Split creates independently movable viewing areas.

When the view still seems divided after you change a setting, look carefully for both horizontal and vertical dividers and try the relevant View commands one at a time. Avoid repeatedly clicking controls without checking the result, because toggling a view feature can re-enable it.

Fix arrow-key scrolling with Scroll Lock

Scroll Lock is a keyboard mode, not a worksheet cell setting. When it is on, the arrow keys can scroll the worksheet instead of moving the active-cell selection. This often leads people to think that the selected cell is locked or that Excel has frozen, even though the sheet is responding to a different navigation mode.

On a Windows keyboard with a ScrLk or Scroll Lock key, press it once and test the arrow keys again. Some laptops omit that key or require an Fn combination; the correct combination depends on the computer manufacturer and keyboard model. Do not assume that one universal Fn shortcut works on every laptop.

If your keyboard has no Scroll Lock key, open the Windows On-Screen Keyboard from Settings > Accessibility > Keyboard and turn on the On-Screen Keyboard. If its ScrLk key is visible, click it to change the mode. Excel may show Scroll Lock on the status bar; if it is not displayed, right-click the status bar and see whether Scroll Lock is available to show. The status indicator is useful, but its availability can depend on the Excel interface and settings.

Excel for Mac does not use the Windows ScrLk key in the same way on many Mac keyboards. If arrow-key navigation behaves unexpectedly, test the mouse or trackpad and check for a split or frozen view. Keyboard layouts and external keyboards differ, so consult the keyboard’s documentation rather than relying on a Windows shortcut.

Understand locked cells and sheet protection

The word Locked in Excel refers to a cell-protection property. Cells are generally marked as locked by default, but that property does not restrict editing until the worksheet is protected. When protection is applied, Excel can prevent changes to locked cells while still allowing permitted actions, such as selecting cells or using certain filters. This protection does not make a cell stay in place while scrolling.

If you cannot edit a cell, select it and open Home > Format > Format Cells, then inspect the Protection tab to see whether Locked is selected. That checkbox alone does not tell you whether protection is active: check the Review tab for Unprotect Sheet. If the sheet is protected, you may need permission or a password from the workbook owner to unprotect it. Do not confuse editing restrictions with a frozen view.

Protection is useful for preserving formulas or fixed layouts while allowing input in designated cells. It is not a way to keep headings visible during scrolling; use Freeze Panes for that. Likewise, changing a cell’s Locked checkbox will not solve a scrolling problem, and unprotecting a sheet is unnecessary if the only issue is a row that stays at the top.

Common problems and sensible checks

If unfreezing does not solve the behavior, use a short diagnosis rather than changing unrelated worksheet settings. Confirm that the affected sheet is active, test both mouse scrolling and arrow keys, and look for pane dividers. A workbook can have different view settings on different worksheets, so a fix on one tab may not affect another.

  • The top row remains visible: check whether Freeze Top Row or another freeze arrangement is active.
  • A row or column is visible but the rest of the sheet scrolls: unfreeze panes on that worksheet.
  • Only arrow keys move the grid: check Scroll Lock and test the Name Box reference.
  • Two worksheet areas scroll separately: turn off Split from the View tab.
  • You cannot type into a cell: check sheet protection and whether the cell is locked.

Also consider whether the visible item is actually a worksheet cell. A chart, shape, or other object can appear to remain in place because of its positioning properties, while the cells underneath scroll. If the object rather than the grid is the item that seems stuck, inspect the object’s size and properties instead of changing Freeze Panes. This is less common, but it explains cases where unfreezing has no effect on the apparent problem.

Frequently Asked Questions

Why does one cell stay on the screen when I scroll in Excel?
If the cell is part of a row or column that remains visible while the rest of the worksheet moves, Freeze Panes is the likely cause. Use View > Freeze Panes > Unfreeze Panes on the affected worksheet.

Does locking a cell stop Excel from scrolling?
No. The Locked property restricts editing only when sheet protection is active. It does not pin a cell to the screen or change normal scrolling. Use Freeze Panes or check Scroll Lock depending on what the worksheet is doing.

How do I unlock a cell that I cannot edit?
Check whether the worksheet is protected using the Review tab. If it is, select Unprotect Sheet; a password may be required. If protection is off, inspect the cell’s Locked property under Format Cells > Protection, then apply protection settings only if appropriate for the workbook.

Why do the arrow keys scroll the worksheet instead of selecting another cell?
Scroll Lock may be on. Turn it off with the ScrLk key if your keyboard has one, or use the Windows On-Screen Keyboard. If the issue remains, check for a split view and test scrolling with a mouse or trackpad.

Can I keep headings visible without freezing the whole worksheet?
Yes. Freeze only the rows or columns you need. Select the cell below the rows and to the right of the columns to keep visible, then choose View > Freeze Panes > Freeze Panes. For just the first row or first column, use the corresponding dedicated command.

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.