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.
Program Successfully in Excel! This guide will provide you with all the information you need to automate any task in Excel and save time and effort. Learn how to extend Excel's functionality with VBA to create solutions not possible with the standard features. Includes latest information for Excel 2024 and Microsoft 365. Check out Mastering Excel VBA Programming today!
Add-ins for Excel, such as the Analysis ToolPak, are stored in files on your hard drive that can be deleted. If you ...
Discover MoreClick on a cell and you expect the single cell to be selected. If you instead get a group of cells, it can be frustrating ...
Discover MoreNeed to clear out a large amount of information saved on the Clipboard? All you need to do is to replace it with a small ...
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 © 2025 Sharon Parq Associates, Inc.
Comments