Excel - My Mouse scroll doesn't work with excel 2007

Asked By Hel on 19-Jun-08 11:11 PM
Hi, my Mouse scroll does not work with excel 2007 but it works for all the
other application, can anyone help me? Thanks




rewb replied on 20-Jun-08 08:55 PM
I don't know if this is the same issue that I have with 2007, but if
it is, it is quite annoying.

Scrolling (with the mouse's middle wheel) works for me if I am in an
Excel document but not editing a formula.  If however I start a
formula and type e.g. "=3DH14+" and I then want to scroll down to row
254, say, to add H254 to the formula, I cannot do this with the scroll
wheel.  Instead I have to click on the scroll bar to the right to go
down (or simply type H254, but unfortunately my memory isn't good
enough to remember exactly which row all my formulae are on).

There does appear to be a way around this, but it's not ideal.  If you
have 'Allow editing directly in cells' enabled, the mouse scroll will
work, even when editing a formula.  To change this setting, go to
Excel options (via the multi-coloured Office symbol in the top left
hand corner of the screen), and select Advanced.  However, I do not
want this feature enabled, as I much prefer to edit my formulae in the
formula bar, and dislike the way that a long formula will make it
impossible to see the contents of the adjacent cells if 'editing
directly in cells' is enabled.  Furthermore, there are other useful
features with not having this enabled (such as being able to double
click on the cell to go to where it is pointing - albeit CTRL+[ does
the same job).

Not sure if this helps, or if it's the same problem you have.  Try
changing this setting and see if it fixes it for you.  If anyone has
any comments on the issues I'm having, I'd also like to hear them.
I'm sure 2003 allowed me both to not allow editing directly in cells
but also scroll when editing formulae.
Jim Rech replied on 20-Jun-08 11:39 AM
The reason the sheet doesn't scroll with the mouse wheel when edit directly
in cells is not selected is that the formula bar itself scrolls with the
mouse wheel instead.  As you know, the formula bar has become multiline in
Excel 2007 so (with long cell entries) MS opted to have the scrolling take
place there as that's where the focus is.  You and I may agree that that was
the wrong design decision but so it is.

I find that edit directly in cells works well for me most of the time and,
when it doesn't, I click up in the formula bar and continue editing there.

--
Jim

I don't know if this is the same issue that I have with 2007, but if
it is, it is quite annoying.

Scrolling (with the mouse's middle wheel) works for me if I am in an
Excel document but not editing a formula.  If however I start a
formula and type e.g. "=H14+" and I then want to scroll down to row
254, say, to add H254 to the formula, I cannot do this with the scroll
wheel.  Instead I have to click on the scroll bar to the right to go
down (or simply type H254, but unfortunately my memory isn't good
enough to remember exactly which row all my formulae are on).

There does appear to be a way around this, but it's not ideal.  If you
have 'Allow editing directly in cells' enabled, the mouse scroll will
work, even when editing a formula.  To change this setting, go to
Excel options (via the multi-coloured Office symbol in the top left
hand corner of the screen), and select Advanced.  However, I do not
want this feature enabled, as I much prefer to edit my formulae in the
formula bar, and dislike the way that a long formula will make it
impossible to see the contents of the adjacent cells if 'editing
directly in cells' is enabled.  Furthermore, there are other useful
features with not having this enabled (such as being able to double
click on the cell to go to where it is pointing - albeit CTRL+[ does
the same job).

Not sure if this helps, or if it's the same problem you have.  Try
changing this setting and see if it fixes it for you.  If anyone has
any comments on the issues I'm having, I'd also like to hear them.
I'm sure 2003 allowed me both to not allow editing directly in cells
but also scroll when editing formulae.
nynorsk replied on 30-Jul-08 02:40 PM
Hello,  I have the same problem as below.  I read the responses but they did
not help the problem.  The mouse does not scroll in Office 2007 no matter
where it is located.  But the mouse scroll works everywhere else, including
the old version of microsoft, inetrnet explorer and every other application
on my computer.  So, if anyone can help with this problem it would be much
appreciated.

thanks!!
RobofM replied on 30-Jul-08 03:06 PM
Goto settings > mouse in the control panel and change the setting from
universal scroll to the other option which for me was office 97. I still
can't use my mouse stick (pressure stick instead of a wheel) to scroll
horizontal but at least it works vertical now.
nynorsk replied on 30-Jul-08 03:08 PM
Thank you!!  That did it!!!  My mouse now works.
MouseUser123 replied on 15-Aug-08 10:18 AM
When I pull up the Mouse menu from the control panel, I don't have any option
to change scroll settings.  Can you clarify if the 'settings > mouse' you
reference below is a menu from within Excel 2007 or if it is from the default
Start button menu?
daemz replied on 25-Nov-08 06:38 AM
RobofMN you are my hero, The Excel scrolling thing has been driving me nuts
and it is now fixed. Thank you, Thank you Thank you
Deepak Jain replied on 12-Dec-08 12:46 AM
Thanks a lot dear, it worked well.
C replied on 05-Jan-09 10:53 PM
Hi,

I am using Vista and I cannot seem to find the place to change my scroll
setting. Does anyone know how to go abt doing the change? Thanks!
Matt Bliss replied on 08-Jan-09 03:48 PM
My question has to do with checking formulas within cells.  If I click in the formula bar (that has a formula already entered), Excel will put colored boxes around the cells that correspond to the colored cell references in the formula bar.  In Excel 2003, I could use the mouse scroll wheel to see the location of these referenced cells (if beyond the current view).  In Excel 2007, I can't scroll like this with the wheel, I have to click on the scroll bar.



Enabling the 'Allow editing directly in cells' option doesn't seem to make a difference in this case.  Any suggestions on how to enable the mouse wheel for this purpose?  Any VBA that could fix this?
Fred Korangy replied on 09-Sep-09 11:39 PM
You are required to be a member to post replies.  After logging in or becoming a member, you will be redirected back to this page.
Lesley Winfield replied on 14-Sep-09 12:56 PM
Thank you for the comment about the settings with my mouse in Control Panel. I was having the same issue as posted above and that seemed to work for me! My issue started after downloading windows upda