Written by Allen Wyatt (last updated September 24, 2022)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, 2021, and Excel in Microsoft 365
Dave has a workbook that has a dozen worksheets in it. When working with ten of the worksheets he can use the scroll wheel on the mouse to scroll up or down. When working with the other two worksheets the scroll wheel will not scroll, however. Dave wonders what would cause this difference in behavior.
The most common cause of this issue is that the problem worksheet has frozen panes in it. When freezing panes horizontally, the top pane is literally "frozen" and cannot be scrolled. If the pane is large enough, it is possible to not even realize that the worksheet has a frozen pane.
The solution is to display the offending worksheet and, on the View tab of the ribbon, click the Freeze Panes tool. The tool acts like a drop-down list, displaying a few options. If one of those options is Unfreeze Panes, then click that option and the problem should be solved.
If there are no frozen panes on the worksheet, the only other possibility is that there is a macro that runs whenever the worksheet is activated. That macro may contain a command that limits the scrolling area or changes the settings that control the behavior of the mouse wheel. The only way to solve this potential cause is to take a look at your macro code and see if any of the statements exist to affect the scrolling area or mouse configuration.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (12985) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, 2021, and Excel in Microsoft 365.
Best-Selling VBA Tutorial for Beginners Take your Excel knowledge to the next level. With a little background in VBA programming, you can go well beyond basic spreadsheets and functions. Use macros to reduce errors, save time, and integrate with other Microsoft applications. Fully updated for the latest version of Office 365. Check out Microsoft 365 Excel VBA Programming For Dummies today!
In order to make working with a workbook comfortable, you often need to set both a window size and a zoom level for the ...
Discover MoreA common task when editing a worksheet is to insert rows in your existing data. This tip looks at ways you can accomplish ...
Discover MoreIt can be frustrating if you try to jump to the last cell in a worksheet, only to find out that you are taken to some ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2022-09-24 11:26:29
J. Woolley
My Excel Toolbox includes the following dynamic array function to list all panes of the active window in four columns (Pane, ScrollColumn, ScrollRow, VisibleRange):
=ListPanes()
The following dynamic array function will list all properties of the active window (including freeze, split, and scroll information):
=ListWNProperties([SkipIgnored],[SkipHeader])
The following dynamic array function will list all properties of the active worksheet (including ScrollArea):
=ListWSProperties([SkipIgnored],[SkipHeader])
The following dynamic array function will list all application properties (including RollZoom):
=ListAppProperties([SkipIgnored],[SkipHeader])
In older versions of Excel you can use these dynamic array functions with the SpillArray function described in UseSpillArray.pdf.
The following formulas can also be used in older versions of Excel:
=VLOOKUP("ScrollArea",ListWSProperties(),2)
Cells outside the scroll area cannot be selected.
=VLOOKUP("RollZoom",ListAppProperties(),2)
When RollZoom is True, the scroll wheel will zoom (or scroll if Ctrl is pressed).
When RollZoom is False, the scroll wheel will scroll (or zoom if Ctrl is pressed).
See https://sites.google.com/view/MyExcelToolbox/
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2026 Sharon Parq Associates, Inc.
Comments