+ Reply to Thread
Results 1 to 8 of 8

Scroll does not work in spreadsheet

  1. #1
    Forum Contributor
    Join Date
    02-14-2004
    Posts
    131

    Scroll does not work in spreadsheet

    When using the scroll wheel on my mouse the worksheet does not move. I've check the unfreeze panes function and it is not set to freeze. Filters are turned off as well. Anyone got any ideas?

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Scroll does not work in spreadsheet

    Which version of Excel are you using?
    If you mean that the mouse wheel does not scroll the sheet while building a formula, that is new behavior in Excel 2010 (and maybe Excel 2007, I can't remember). In prior versions, you could scroll the worksheet with the mouse wheel while building a formula.
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Forum Contributor
    Join Date
    02-14-2004
    Posts
    131

    Re: Scroll does not work in spreadsheet

    I'm using Excel 2007. When I move the mouse wheel the spreadsheet does not move up and down with the movement of the wheel.

  4. #4
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Scroll does not work in spreadsheet

    you can change from scroll on roll to zoom in advanced options, do that and see if it zooms or not
    if not it's probably the mouse settings
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  5. #5
    Registered User
    Join Date
    04-20-2011
    Location
    Aarhus, Denmark
    MS-Off Ver
    Excel 2013
    Posts
    54

    Re: Scroll does not work in spreadsheet

    Hi mate,

    You probably just pressed the "SCROLL LOCK" button to activate it. When you do that then you cannot use your mouse to scroll in Excel. Please check if that solved your query.

  6. #6
    Registered User
    Join Date
    09-06-2011
    Location
    Bentonville
    MS-Off Ver
    Excel 2007
    Posts
    4

    Solved: Re: Scroll does not work in spreadsheet

    I've used the scroll on my mouse for years. This morning it does not work. I've read forum after forum and either I do not have the same options or the strategies do not work. I've gone through control panel but I have very few selections and "universal" or other wheel options are not present. I've checked the scroll to zoom, the zooming worked so I know my mouse is fine. I unchecked the zoom and no scrolling. this is driving me crazy. I spend about 75% of my day in excel working on large spread sheets/reports. Are there any other ideas? Throw them all my way I will try everything until this is fixed!

    Solved by right clicking on bottom status menu in Excel and deselecting Scroll Lock. (could not fix by keyboard)
    Last edited by mdgajes; 12-16-2011 at 11:47 AM.

  7. #7
    Registered User
    Join Date
    01-16-2012
    Location
    Irvine, CA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Scroll does not work in spreadsheet

    I just installed Office 2007 and had this same thing. The scroll wheel wouldn't navigate me vertically through a spreadsheet. I was surprised, since I've used Excel for many years and the mouse wheel always did this. I'm not interested in zooming. Hit Help and was directed to this thread. I'm on Windows 7, and previously had Office 2000 installed.

    I had to go to the Control Panel, Mouse, Wheel, click option button: "Use Microsoft Office 97 Scrolling Emulation Only". And it now works!

    Scroll Lock on the keyboard changes whether arrow keys traverse through the cells or slide the vert / horiz scrollbars of the worksheet window. The "right click status bar" does bring up a Scroll Lock checkbox - but to the right it says "Yes" or "No" (which is sensitive to the Scroll Lock toggle from the keyboard). Looks like the checkbox overrides it in some way - but it does not appear to be associated with vertical scrolling with the mouse wheel - at least from what I could tell. Maybe if my Control Panel mouse setting was the other option "Enable Universal Scrolling" - but I couldn't get that to work. Had to use that Office 97 thing.

  8. #8
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Scroll does not work in spreadsheet

    Welcome to the forum.

    Please take a few minutes to read the forum rules, and then start your own thread.

    Thanks.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1