Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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

Posted on 2016-10-24
5
82 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 18

Accepted Solution

by:
Serena Hsi earned 500 total points
ID: 41858130
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
ID: 41860690
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
ID: 41860691
Thanks
0
 
LVL 18

Expert Comment

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

Author Comment

by:rberke
ID: 41862450
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This article outlines why you need to choose a backup solution that protects your entire environment – including your VMware ESXi and Microsoft Hyper-V virtualization hosts – not just your virtual machines.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

839 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