This has been driving me mad for years. I don't know if it's from Excel, Windows, or the mouse itself (Sharkoon Fireglider)... but it only happens in Excel.
If the mouse is moved to the right of the workbook the mouse wheel switches from vertical scroll to horizontal - very easy to accidentally trigger especially with frozen columns.
An overlay appears indicating the partition between vertical and horizontal scrolling, and a wheel icon when the mouse is in 'horizontal territory'.
I only want to scroll vertically!
Please help
1 Answer
A partial possible solution is to limit the scrolable area. To do so, on the Developer tab, click on properties then on SCrollableArea, enter the range. From now on when you try to go beyond the set limit, you will be taken back to area you defined.
However, this only work for a worksheet, and you will have to set it for every single worksheet (which might be inconvenient). Or you can use a macro to set it when you open workbooks.
Edit: From this article also explaining the process above, there is a code of macro to accomplish setting up the scrollable area for a workbook. You need to add a Module and add the following code to it.
Sub SetAllScrollAreas()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets ws.ScrollArea = ws.UsedRange.Address
Next ws
End Sub
Private Sub Workbook_Open() SetAllScrollAreas
End SubAs an aside note, To stop Showing the horizontal scroll bar:
Open Excel Options (File -> Options), go to Advanced, then "Display options for this workbook". Uncheck "Show horizontal scroll bar".
