Solved

How to control Mouse wheel better (scrolling gets "locked")

Posted on 2016-10-24
5
41 Views
Last Modified: 2016-11-22
When using the mouse wheel to scroll in Excel it gets "stuck"

Normal operation:  

1) I select cell  a14 which is in the middle of the left edge of spreadsheet.
2) I depress and tilt the wheel to the right to start scrolling,  A funky Icon appears that looks like this:
scrollright3)  While depressed, the mouse moves the arrowhead which changes the scroll direction from right scroll to up or down or left.  (the box stays static)
4) when I let go of the mouse scrolling stops.

When it gets stuck I can let go of the mouse completely, but the screen keeps scrolling until I strike the escape key on the keyboard.

I have a feeling that this is actually a "feature" that I am accidentally invoking.  I don't think it is a hardware problem like dirt or lint.

Can anybody explain the behavior ?

I am using a Dell Mouse that does not have a model number on it, but I see DP/N:0XN967 above the serial number.

The Control Panel shows it is HID Compliant, and the track Wheel has horizontal scrolling set to 1.

rberke
0
Comment
Question by:rberke
  • 3
  • 2
5 Comments
 
LVL 17

Accepted Solution

by:
Serena Hsi earned 500 total points
Comment Utility
The icon with the 4 cardinal points indicates that you are able to pan in those directions. It is activated when you:

Hold down the wheel button, and drag the pointer away from the origin mark  origin mark in any direction that you want to scroll. To speed up scrolling, move the pointer away from the origin mark. To slow down scrolling, move the pointer closer to the origin mark.

Plus, you can also configure Zoom by turning on this option under File / Options / Editing Options / check Zoom on roll with IntelliMouse

This link is for the other things you can do in Excel with your mouse:
https://support.office.com/en-us/article/Move-or-scroll-through-a-worksheet-06fc34b8-64bb-4d78-9b62-34656d700f82

Also, here is how you can assign a macro or functions to the buttons on your mouse:
https://support.microsoft.com/en-us/kb/258892
0
 
LVL 5

Author Comment

by:rberke
Comment Utility
As I suspected, there was a mouse feature that I did not understand. (And that is after using a mouse all day long for over 20 years !!! )

Thanks to you, I now realize that when I go to spin the wheel I sometimes clicked it accidentally.  Then just twitching the mouse started the automatic scroll.

I now know I can stop it by just clicking the mouse a second time.

--------  if anybody is interested in more details, than can read further -----------------

Your first link had a section on "Pan through a worksheet automatically" which helped me figure out what was happening.

#1 One type of scroll I often use is to spin wheel without clicking will scroll up or down. (No mouse movement)

#2 Another type of scroll if use is to  Hold the wheel down and use mouse movement to scroll vertically or horizontally. Wheel up stops the scroll.
 
#3 Was new to me.  Click Wheel down then up, then move the mouse to start automatic scroll. Letting go of mouse just continues the previous scroll.

I never knew about #3.  I doubt I will ever use that intentionally, but it does not seem weird anymore.

Thanks for your help.
0
 
LVL 5

Author Closing Comment

by:rberke
Comment Utility
Thanks
0
 
LVL 17

Expert Comment

by:Serena Hsi
Comment Utility
The mouse scrolling-by-itself nonsense has happened to me a lot on the Surface Pro 3.
0
 
LVL 5

Author Comment

by:rberke
Comment Utility
Serena:

Two months ago I replaced a dead mouse. I think my new mouse has a "lighter touch" for clicking.  because that is when this behavior started.  Since then I have been silently swearing every time the "scrolling-by-itself nonsense" occurred.

But, one persons "Nonsense" is another person's "critical feature".

Now that I fully understand how the wheel click works, I think it might be a very useful feature - just click to start, then move the mouse to control the scroll, then click to stop. Right now I don't like the feature much because the auto scroll seems "jerky" and either too slow or way to fast. But a few days of practice might change my mind.

Bob




the the first time I noticed . They both had mouse wheels, but I think the new one is more sensitive, so that a lighter touch is treated as a click.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

We recently endured a series of broadcast storms that caused our ISP to shut us down for brief periods of time. After going through a multitude of tests, we determined that the issue was related to Intel NIC drivers on some new HP desktop computers …
What do we know about Legacy Video Conferencing? - Full IT support needed! - Complicated systems at outrageous prices! - Intense training required! Highfive believes we need to embrace a new alternative.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now