If an Excel worksheet won’t scroll, first check whether Scroll Lock is on; then check for frozen panes or a disabled scrollbar. In Excel for Microsoft 365 on Windows, these quick checks solve many cases: press the Scroll Lock key, choose View > Freeze Panes > Unfreeze Panes, and make sure the workbook’s scrollbars are enabled under File > Options > Advanced.
Start by identifying what is stuck
“Won’t scroll” can describe several different problems. The mouse wheel might do nothing, the arrow keys might move the worksheet instead of the active cell, a scrollbar might be missing, or the sheet might stop at a particular row or column. The symptom is useful: a missing scrollbar points to a display setting, while a sheet that stops at a boundary may have restricted scrolling or hidden rows.
Try these checks before changing workbook settings:
- Click a cell in the worksheet, then try the mouse wheel and the arrow keys. This helps distinguish a worksheet issue from a window that does not have focus.
- Look at the status bar at the bottom of Excel for a Scroll Lock indicator. Its visibility can depend on your Excel setup.
- Check whether a scrollbar is missing, or whether it is present but does not move the sheet as expected.
- Try another worksheet in the same workbook. If only one sheet is affected, investigate that sheet’s panes, hidden rows, or scroll restrictions.
Save the workbook before troubleshooting. If a change does not help, you can close without saving or undo a reversible setting change.
Turn off Scroll Lock
Scroll Lock changes how the arrow keys behave in Excel. With it on, pressing an arrow key can scroll the worksheet while leaving the selected cell in place. With it off, the arrow keys normally move the active-cell selection. That difference often makes people think the sheet or selection is frozen.
On a Windows keyboard with a Scroll Lock or ScrLk key, press it once and test the arrow keys. Some laptop keyboards hide the key behind an Fn combination, and the combination varies by manufacturer. If you cannot find it, open the Windows Start menu, search for On-Screen Keyboard, open it, and select the ScrLk key if it is shown. Test the arrow keys again after switching it off.
Scroll Lock does not usually prevent mouse-wheel scrolling; it mainly changes keyboard navigation. So if the mouse wheel and scrollbars are also unresponsive, keep checking the other causes below. On a Mac, the keyboard may not have a standard Scroll Lock key. If an external keyboard includes one, its behavior depends on the keyboard and Excel setup; otherwise, focus on panes and scrolling settings rather than searching for a universal Mac shortcut.
Unfreeze panes or turn off a split
Frozen panes keep selected rows or columns visible while you move through the rest of a worksheet. This is useful for headings, but it can feel like scrolling is blocked if the wrong cells were selected when the panes were frozen. For example, frozen columns can make the left part of the sheet stay in place while the right part scrolls.
In Excel for Windows, choose View > Freeze Panes > Unfreeze Panes. If you want to freeze panes again later, 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. The Freeze Top Row and Freeze First Column commands are shortcuts for those specific layouts.
A split window is different from frozen panes: it divides the worksheet into independently scrollable areas. If a line across or down the sheet is making navigation confusing, choose View > Split to turn the split off. On current Excel for Mac versions, look for the corresponding Freeze Panes and Split commands on the View tab; labels or placement can vary slightly by version. Unfreezing panes does not delete worksheet data.
Restore a missing scrollbar
If the vertical or horizontal scrollbar has disappeared, Excel may have hidden it for that workbook. On Windows, open File > Options > Advanced. Under Display options for this workbook, select the correct workbook if the list is shown, then check Show horizontal scroll bar and Show vertical scroll bar as needed. Choose OK to apply the setting.
These controls affect whether the bars are displayed; they do not unlock a worksheet or remove frozen panes. The horizontal bar can also be squeezed out of sight when the workbook’s sheet-tab area takes up most of the bottom edge. Drag the divider between the sheet tabs and the scrollbar to make room if the bar is present but too small to use.
In Excel for Mac, scrollbar visibility can depend on both Excel’s view preferences and macOS settings. Check Excel’s Settings or Preferences under View if your version provides scrollbar options, and check the macOS appearance or scrollbar settings. The names and locations can vary between macOS releases. Excel for the web runs inside a browser, so also check that the pointer is over the worksheet and not a surrounding page or pane.
Look for hidden rows, columns, or grouped sections
A sheet can appear to stop scrolling when rows or columns are hidden, or when an outline group is collapsed. Hidden rows are skipped as you move through the visible cells, which can make a large gap in row numbers look like a navigation problem. A plus or minus outline control beside row or column headings indicates grouped sections that can be expanded or collapsed.
To reveal a hidden section, select the row or column headings on both sides of the gap, right-click the selection, and choose Unhide. For an outline, use the plus control to expand the group. If you suspect a filter instead, check whether filter arrows are active in the headings: filtering hides rows that do not meet the criteria, but it does not disable scrolling. Clear or adjust the filter if you need those rows displayed.
Excel worksheets have a fixed grid of 1,048,576 rows and 16,384 columns, ending at column XFD. Reaching the final row or column is a real boundary, not a scroll failure. If you expected data beyond that point, it is not part of the worksheet grid; check whether the data is in another sheet, file, or external source.
Check for a restricted scroll area or protection
Worksheet protection is often blamed for a scrolling problem, but protection usually controls editing rather than whether a user can move around the sheet. A protected sheet can still be navigated. If scrolling stops at the same row or column every time, a more likely explanation is a restricted scroll area or an unusual workbook configuration.
Excel’s VBA object model includes a worksheet ScrollArea property that can restrict which cells are selectable. A workbook macro or add-in may set this property, sometimes when the file opens. There is no ordinary worksheet button that most users need to change for this; ask the workbook’s owner whether a macro is intentionally limiting navigation, especially in a form or dashboard.
If you manage the workbook and use macros, check its trusted VBA code and workbook-open procedures rather than downloading a supposed “scroll fix.” Do not enable macros from an untrusted file just to test scrolling. If the sheet is protected, ask its owner for the password or an editable copy before changing protected content. Protection does not need to be removed simply to test a scrollbar.
Rule out input, window, and performance issues
Sometimes Excel is responding normally but the input device or window is the problem. Click a cell to give the worksheet focus, then try the scrollbar itself. If that works but the wheel does not, test the mouse in another application and check its driver or wheel settings. A touchpad gesture may also be configured for horizontal movement, zooming, or switching desktops rather than vertical scrolling.
If the worksheet scrolls but appears to jump unexpectedly, check the zoom level and whether you are using Page Layout or Page Break Preview. These views change how the sheet is presented, but they should not normally prevent movement through the grid. Switch back to View > Normal as a diagnostic step. Also close panes such as the Navigation pane if they are taking focus or reducing the visible worksheet area.
For a workbook that pauses or responds slowly, wait briefly and check whether Excel is calculating, refreshing an external connection, or handling a very large formatted range. That is different from a scroll lock: movement may resume when the task finishes. Save, close other demanding files, and reopen the workbook. If the problem affects every workbook, restart Excel and update Office through File > Account > Update Options > Update Now on Windows, where that option is available. On Mac, use Help > Check for Updates if updates are managed through Microsoft AutoUpdate.
A practical order for fixing the problem
Use this sequence to narrow down the cause without changing several settings at once:
- Click a worksheet cell and test the wheel, arrow keys, and visible scrollbar separately.
- If arrow keys scroll the sheet instead of moving the selection, turn off Scroll Lock.
- Choose View > Freeze Panes > Unfreeze Panes, then turn off View > Split if a split is active.
- Enable the missing horizontal or vertical scrollbar in the workbook’s display options.
- Expand outline groups and unhide any rows or columns that may be creating apparent gaps.
- If movement stops at a repeatable boundary, ask the workbook owner about VBA restrictions or a purpose-built interface.
- If all workbooks are affected, restart Excel and test the mouse or touchpad outside Excel.
Testing one change at a time matters. For example, if unfreezing panes fixes the issue, there is no reason to alter protection settings or enable macros. If only one workbook behaves differently, compare its view and sheet setup with a new blank workbook before making broader changes.
Frequently Asked Questions
Why do the arrow keys scroll the sheet instead of changing cells?
Scroll Lock is likely on. Turn it off with the ScrLk key or Windows On-Screen Keyboard. If Scroll Lock is off, check whether a different worksheet pane is active or whether the keyboard is being intercepted by another tool.
Why can I scroll down but not across in Excel?
The horizontal scrollbar may be hidden, frozen columns may be holding part of the sheet in place, or the window may be too narrow to show the bar. Enable the horizontal scrollbar in workbook display options and check View > Freeze Panes and View > Split.
Does protecting a worksheet stop scrolling?
Ordinary sheet protection mainly limits actions such as editing locked cells. It does not normally stop scrolling. A restricted scroll area, hidden sections, or frozen panes are better explanations when navigation is limited.
Why does the worksheet stop at a particular row?
Check for hidden or filtered rows, collapsed outline groups, and the worksheet’s final row. If scrolling always stops at the same earlier boundary, ask the workbook owner whether VBA has set a scroll area or whether the workbook is designed as a limited-entry form.
How do I get the scrollbar back in Excel?
On Windows, open File > Options > Advanced and enable the horizontal or vertical scrollbar under Display options for this workbook. On Mac, check Excel’s View preferences and macOS scrollbar settings, since the controls vary by version.
Related
- Data Validation Checks in Excel: Rules and Examples
- Data Validation Checklist for Excel: What to Check
- Conditional Formatting in Microsoft Project: What Works
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- XLOOKUP and VLOOKUP Not Working? Fix Common ErrorsIf XLOOKUP or VLOOKUP is not working, first check that the lookup value and lookup column contain the…
- Excel Cell List Drop-Down: Create and Fix OneTo create an Excel cell list drop-down in Microsoft 365 for Windows, select the cell, choose Data >…
- Excel Not Typing in Cell? Fix the Common CausesIf Excel will not let you type in a cell, first select the cell and try entering text…
- Ctrl+L Excel Shortcut: Create a Table and Fix IssuesIn Excel for Microsoft 365 on Windows, Ctrl+L opens the Create Table dialog for turning a selected data…
- COUNTIF With a Cell Reference Not Working? FixesIf COUNTIF is not using your cell reference, check that the reference is not inside quotation marks: with…
- VLOOKUP Not Working? Common Excel Causes and FixesVLOOKUP usually fails because the lookup value and the first column of the search range do not match…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.