Scroll Wheel Doesn't Work when Editing

@ TWIMC
When holding down the [Ctrl] key while using the mouse wheel, the effect will be the opposite of your setting of "Zoom on roll with IntelliMouse"

Setting of the "Zoom on roll with IntelliMouse":
 - checked the mouse wheel will zoom, but scroll while holding the Ctrl key down
 - unchecked the mouse wheel will scroll, but zoom while holding down the Ctrl key

Thank you

Bob - THANK YOU THANK YOU THANK YOU!!!! I wasted almost an hour trying to fix my scrolling issue and NOTHING was working SURE ENOUGH IT WAS THE MOUSE ITSELF. What a stupid "feature". Many thanks.

"i went thru all of the blogs on this issue and it turned out that the button on the top of the mouse was the fix. we tried selecting and unselecting the scroll lock option on the bottom nav bar in excel and going to control panel/mouse/wheel but found no options there. what finally worked was hitting the button we have on the top of the logitech mouse. it also worked by clicking the scroll bar on a dell wireless mouse.

SOLUTION: If you wish to scroll up/down the worksheet with your mouse's scroll wheel when editing a formula, you need to be editing IN THE CELL ITSELF and not in the formula bar.

Good luck!

if you still want to "Zoom on roll with IntelliMouse", hold the Ctrl key and then roll.

This can happen when Freeze Pane is set while filters are active, once filters are cleared, excel is still set to freeze far below the Title row.

Check to see if Freeze Pane was set while filters were in active.
Clear Filters under Data Tab
Clear Freeze Panes under View Tab
Put cursor were freeze should begin - Reset Freeze
Then reapply filters.

HI Joachim,

I was having the same issue - went and "forced" an update (file - account - updates)
It ran through the process and I am up and scrolling again!

Hope it works for you :)

Alas, this solution does not work for me.

Enabling "Zoom on roll with Intellimouse" zooms the entire screen in or out. It doesn't scroll through the spreadsheet.

My problem: the scrolling wheel works fine when I'm not editing any cell.
However it doesn't work any more when editing (after pressing F2, or after editing directly in cell).
It used to work fine, before. I used to start typing something like "=sum(..." or just "=...." and then start using the scroll wheel.

Scroll lock is off.
Edit directly in cell = on.
Excel = 2016.
Zoom on roll with Intellimouse = off (did not solve the issue)

Excellent....


resolved my 5 months excel facing problem

I have a related annoying issue for which I have been trying to find a solution for many months. I am using my touch pad for 2 finger scroll on my laptop (Acer S7) running Windows 10. The strange thin is that my 2 finger scroll doesn't work in excel. Actually what is is even more strange is that the scroll doesn't work only when the pointer is in the workbook area. Move the pointer to the ribbon area the 2 finger scroll works fine. Also in some files the scroll works fine even in the workbook area also. But most excel files it doesn't. Any idea what is going on?

Thank you for your support

The comment from bob 23 Aug 2016, 09:34 worked for me.

Very very useful.... thanks lot

Iw worked perfectly. Thx

just
1. left click inside the cell you want to edit
2. left click the formula bar
3.left click inside the cell you want to edit again and then it is possible to use the scroll wheel

The solution in simply. right-click inside the cell that that you want to edit and then you can use the scroll wheel.

PERFECT. THX A LOT

i went thru all of the blogs on this issue and it turned out that the button on the top of the mouse was the fix. we tried selecting and unselecting the scroll lock option on the bottom nav bar in excel and going to control panel/mouse/wheel but found no options there. what finally worked was hitting the button we have on the top of the logitech mouse. it also worked by clicking the scroll bar on a dell wireless mouse.

Great !!!!

Everything got fixed in a snap.

Thanks a lot for the tip.

This didn't work for me, but the comment above about freezing and then unfreezing (mine wasn't frozen, but I clicked freeze, then unfreeze), worked for me.

FYI, another cause might be the View->Freeze Panes setting. Try Unfreezing.

Great thanks for help

Mr. T, THANK YOU! Typing 0_o in a cell worked for me.

checking the edit directly in the cell fixed it for sure

Thank you for this tip. It was helpful and prevented me from losing my mind entirely.

It is not working with the pad of my laptop (Dell).
I am not allowing direct editing in the cell. When I clic f2, I am not able to scroll using the pad (2 fingers).

This is messed up, but my scroll wheel was not working for either Excel NOR IE. Everywhere else it was working. Taking a tip from Maciek, I clicked down on the wheel within an Excel cell to get the navigation arrows to appear, moved the screen a little and clicked the arrows off. Suddenly the wheel worked in both Excel and IE.

Very helpful. The option was already unchecked however I checked and unchecked again and problem is solved now.

All,

As indicated above for latter versions of excel i.e. after 2003. After disabling zoom and allowing direct cell editing in options. Instead of single clicking in the cell as was the case previously. Now you have to first DOUBLE-CLICK the cell in these newer excel versions. You can double click again to get out of edit or hit enter. I'm using excel 2013 and this definitely works.

Best Regards

Perfect, thx.
I had an issue with my Microsoft 6000 wireless mouse. It would only zoom with the wheel, unless I held in the Ctrl key. I actually wanted this feature reversed. The answer was found at this site. Thx again.

Yes it is really a problem in newest office and the solution mentioned above not works.
But you can simply double click in formulas cell (or press F2) and then mouse scroll works.

You need to tick 'allow editing directly in cell' in advanced options.

Having never used MS mice, I did not know one could scroll; I hold the right button down on my LT mouse and use the trackball . . .

Part solution (Excel 2013) is to "unfreeze" panes in the VIEW tab ribbon...

Microsoft please note that you have been aware of this problem for several updates of Excel - when the blazes are you actually going to get around to permanent and proper solutions to your software?...
If I buy a new car and it develops a fault I have every right to have the problem solved on demand and free of charge... why the f*ck should Microsoft consider themselves exempt from such similar situations?

Typical of MS - they update that which everyone is used to which screws it up!

Like others, this suggested cure did not work for me - I am using a new HP laptop with Windows 8.1 and Excel 2013. Out of frustration, I took my old Microsoft wireless mouse (which has a scroll) and plugged the USB stick into my laptop with Excel open. Windows 8.1 recognized it as a new device and automatically installed the driver, which took about 15 seconds. The scroll feature on my old MS mouse worked in Excel! I had my new mouse still turned on with its USB stick still in, and so simply moved my hand from the old MS mouse to my new mouse, and the scroll worked on it as well. I unplugged the old MS mouse USB stick - my new mouse scroll continued to work and has continued to work ever since. I have no idea why this fixed it, but if you have a different mouse with a scroll, give it a try.

Same problem for me. This function is highly required, as it was in Microsoft excel 2003!

Change The Mouse..

try this 0_o'

The same problem. The only possible solutions - press/click the mouse scroll wheel and navigate by moving the mouse. MS says, that from exlcel 2007 up, the scroll wheel only allows to navigate in the formula bar. Why so? I do not know, as after f2 you can navigate in formula bar usingthe cursor arrows.

This dint work for me.

The solution you suggested only works if the option "Allow editing directly in cells" is ticked.
For those like me who prefer to deselect this option, the only solution I have found (in Excel 2010) that allows me to scroll while editing the formula is to start editing by clicking the "fx" button on the left of the formula bar.

This is not the right answer; you still can't use the scroll wheel while editing the formula. For the people looking for the answer, the best workaround I've found so far (http://www.youtube.com/watch?v=ISPRQr4D_m0) is to edit the formula from the cell by clicking on the cell that has the formula want to edit, then type F2. It's not the same as the old Excel 2003 behavior, but close.