If an Excel workbook will not scroll, first go to View > Freeze Panes > Unfreeze Panes, then check whether Scroll Lock is on and whether the sheet’s scroll bars are hidden. The cause depends on what is stuck: the mouse wheel, arrow keys, one part of the sheet, or the entire worksheet.
Start by identifying what will not move
Try scrolling with the mouse wheel or trackpad, then test the arrow keys and the vertical scroll bar. The results help narrow down the cause. If only the arrow keys move the selected cell instead of the sheet, Scroll Lock is a likely explanation. If one section stays visible while another moves, the sheet may have frozen panes or a split window. If the scroll bars are absent, a workbook display setting may be hiding them.
Also check whether Excel is responding at all. If the pointer shows a busy indicator, a large calculation or an unresponsive add-in may temporarily prevent input. Give Excel a moment, and avoid repeatedly clicking or pressing keys while it is busy. If other worksheets in the same workbook scroll normally, focus on settings for the affected sheet; if every workbook is affected, look at Excel or input-device settings.
Unfreeze panes that hold part of the sheet in place
Freeze Panes keeps selected rows or columns visible while you move through the rest of a worksheet. For example, a table with a frozen header row can scroll downward while its headings remain at the top. That is normal behavior, not a failure to scroll. But a freeze line placed farther down or across the sheet than intended can make it seem as if the worksheet is stuck.
In Excel for Microsoft 365 on Windows, select View > Freeze Panes > Unfreeze Panes. Then test scrolling again. If you want to freeze panes again, select the cell below the rows and to the right of the columns you want to keep visible, then choose View > Freeze Panes > Freeze Panes. For instance, selecting B2 before freezing keeps row 1 and column A visible.
The Freeze Top Row and Freeze First Column commands are shortcuts for common layouts. If either is active, Unfreeze Panes removes it. On Excel for Mac, use the View tab’s Freeze Panes controls; labels and placement can vary slightly by release. In Excel for the web, open the View tab and use its Freeze Panes options. If the commands are unavailable or behave differently, check that the workbook is open in edit mode rather than a restricted viewing state.
Check Scroll Lock when arrow keys behave strangely
Scroll Lock changes what the arrow keys do in Excel for Windows. When it is on, the arrow keys scroll the worksheet view rather than moving the active cell. This can look like the selection is stuck, especially if you expect the cell outline to move. Scroll Lock does not normally disable the mouse wheel, so test both methods before changing settings.
Look for Scroll Lock on Excel’s status bar. If it is enabled, press the Scroll Lock key on your keyboard to turn it off. Some laptops do not have a dedicated key; the required Fn combination depends on the keyboard model. Another Windows option is to open the On-Screen Keyboard from the Start menu and select ScrLk if it is shown. You can also right-click Excel’s status bar and check whether Scroll Lock is available as a status indicator.
On a Mac, many keyboards do not provide a Scroll Lock key, and Excel’s keyboard behavior differs from Windows. If arrow-key movement is the issue, test the trackpad or scroll bar and check for a keyboard utility or external keyboard setting before assuming the workbook is damaged. Scroll Lock is a keyboard state, not a property saved in a worksheet’s data.
Restore missing vertical or horizontal scroll bars
A worksheet can still scroll even when its scroll bars are hidden, but their absence makes movement less obvious and removes a convenient way to jump through a long sheet. In Excel for Microsoft 365 on Windows, choose File > Options > Advanced. Under Display options for this workbook, select the affected workbook if necessary, then enable Show horizontal scroll bar and Show vertical scroll bar. Select OK to apply the change.
On a Mac, scroll-bar visibility can depend on both Excel’s view preferences and macOS system settings. Check Excel > Settings (or Preferences in some releases) > View for workbook window options, and check macOS System Settings for its scroll-bar appearance preference. The exact setting names can differ by macOS release. In Excel for the web, the browser and page layout affect how scrolling controls appear; use the browser’s scroll wheel, trackpad, or scroll bar if a workbook control is not visible.
There is a separate issue if the scroll bar is present but its thumb barely moves or jumps to an unexpected position. A worksheet contains a large grid, and Excel sizes the thumb in relation to the sheet’s available range. A used cell far below or to the right can make the scrollable area appear much larger than the data you can see. Press Ctrl+End on Windows to inspect Excel’s last used cell; this is a diagnostic shortcut, not a command to delete data. On Mac, the equivalent shortcut can vary by keyboard, so use Go To or the name box if needed.
Remove a split window or adjust the panes
Split divides a worksheet window into separately scrollable panes. It is useful for comparing distant parts of a sheet, but an accidental split can make the window seem to contain several sections that do not move together. In Excel for Windows, choose View > Split to turn the split off. If the command is active, selecting it again removes the split. You can also drag a split bar back to the edge of the window in some layouts.
Frozen panes and split panes are related but not identical. Freeze Panes keeps designated rows or columns visible as you scroll; Split creates independent viewing areas. A sheet can also have a pane boundary that is easy to mistake for a frozen section. If scrolling works in one area but not another, click inside each pane and test it, then remove an unwanted split or unfreeze panes. Check the View tab before changing data or resizing rows.
Look for a worksheet scroll limit
In some desktop workbooks, VBA can set a worksheet’s ScrollArea property to restrict navigation to a specified range. If the sheet stops at the same row or column every time, even though there is more worksheet space, a scroll-area limit is one possible cause. This is different from freezing panes: a frozen sheet still lets you scroll the unfrozen area, while a scroll-area limit prevents navigation outside its allowed range.
If you trust the workbook and are comfortable using macros, a workbook author can clear the limit on the active sheet with VBA. Save a separate copy first. On Windows, open the Visual Basic Editor with Alt+F11, insert a standard module, paste the code, and run the macro from Excel. On Mac, the editor can be opened with Option+F11 on many keyboards, though a function-key setting may affect the shortcut.
Sub ClearActiveSheetScrollArea()
Dim ws As Worksheet
' Clear the navigation limit on the active worksheet.
Set ws = ActiveSheet
ws.ScrollArea = vbNullString
End Sub
Macros cannot be undone with Ctrl+Z, so keep the backup. Only run code in workbooks you trust, and follow your organization’s macro-security rules. If you are not the workbook owner, ask its author or administrator whether a navigation limit was intentional. This setting is most relevant to desktop Excel; Excel for the web does not run VBA macros.
Rule out lag, protection, and input-device problems
When the whole workbook seems frozen, distinguish a scroll setting from an Excel performance problem. A formula-heavy workbook, external data refresh, or add-in can make the application slow to respond. Wait for any visible calculation or refresh to finish. If Excel remains unresponsive, save if possible, close and reopen the workbook, and check whether the problem returns. Avoid force-closing Excel before giving it time to recover if unsaved work matters.
Sheet protection is often blamed for scrolling problems, but protection usually controls which cells can be selected or edited; it does not automatically stop ordinary worksheet scrolling. If a protected sheet will not let you select certain cells, that may be an intentional protection setting rather than a scroll fault. Do not remove protection unless you have authorization and understand what the workbook is designed to protect.
If scrolling fails in multiple workbooks, test another mouse or trackpad, disconnect and reconnect an external device, and check whether the issue occurs outside Excel. A touchpad gesture may be configured differently from a mouse wheel. If only one workbook is affected, compare its view and window settings with a new blank workbook before changing application-wide preferences.
Frequently Asked Questions
Why does Excel scroll instead of moving the selected cell?
Scroll Lock is likely on. In Excel for Windows, turn it off with the Scroll Lock key or use the Windows On-Screen Keyboard’s ScrLk key if your keyboard lacks one. With Scroll Lock off, arrow keys normally move the active-cell selection.
Why can I scroll down, but the top rows stay visible?
The sheet probably has Freeze Panes or Freeze Top Row enabled. If you want the entire sheet to move, choose View > Freeze Panes > Unfreeze Panes. If you only want the headings to remain visible, that behavior is intentional.
Why did my Excel scroll bars disappear?
On Windows, check File > Options > Advanced and enable the horizontal and vertical scroll-bar options under Display options for this workbook. On Mac, also check Excel’s view preferences and macOS scroll-bar settings.
Why will Excel not scroll past a particular row or column?
A VBA ScrollArea limit is one possibility, especially if the boundary is consistent. A split pane, unusual window layout, or a lagging workbook can also cause confusing behavior. If it is a managed workbook, ask its owner before changing macro-related settings.
Does protecting a worksheet stop scrolling?
Not normally. Protection primarily restricts editing and, depending on its settings, cell selection. If scrolling itself stops at a fixed boundary, investigate pane settings or a scroll-area restriction instead.
How do I jump to a distant cell without dragging the scroll bar?
Use the Name Box to the left of the formula bar: type a reference such as A500 and press Enter. On Windows, Ctrl+G also opens Go To, where you can enter a cell reference. This moves the view to a location without changing the worksheet’s scroll settings.
Related
- Markdown Table Merge Cells? What You Can Do
- PHP Backend Data Validation: A Practical Guide
- Protect Sheet in Excel: Allow Editing in Certain Cells
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel MATCH Greater Than Not Working? Fixes That WorkExcel’s MATCH function does not treat a greater-than sign in its lookup value as a condition. For the…
- Excel Not Incrementing Cells When Dragged? How to FixIf Excel is not incrementing cells when you drag, it may be copying the selected value instead of…
- VLOOKUP Excel Troubleshooting: Fix Common Formula ErrorsTo troubleshoot VLOOKUP in Excel, check that the lookup value is in the first column of the selected…
- Why Is My SUMPRODUCT Formula Not Working? Checks and FixesA SUMPRODUCT formula usually fails because its ranges do not have matching dimensions, its data contains errors or…
- Excel Flash Fill Not Working? Fix the Most Common CausesIf Flash Fill is not working in Excel, enter a clear example beside your source data, select the…
- Google Sheets Filter Not Filtering? Fix the Common CausesIf a Google Sheets filter is not filtering, check that the filter covers the full data range, that…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.