Scroll Wheel Doesn't Work when Editing

by Allen Wyatt
(last updated December 24, 2014)


Sarah noted that when she is typing a formula or editing an existing one, the scroll wheel on her mouse doesn't allow her to scroll through the worksheet in order to select cells. Instead, she has to use the scroll bar on the right-hand side of the worksheet. This is really annoying, as Sarah finds it easier to use the mouse's scroll wheel. She wonders if there is some setting that she is not aware of that might correct this.

There is only a single setting which controls the use of the mouse wheel. Follow these steps:

  1. Display the Excel Options dialog box. (In Excel 2007 click the Office button and then click Excel Options. In Excel 2010 display the File tab of the ribbon and then click Options.)
  2. At the left side of the dialog box, click Advanced. (See Figure 1.)
  3. Figure 1. The Advanced options of the Excel Options dialog box.

  4. In the Editing Options section, clear the check box entitled Zoom on Roll with Intellimouse.
  5. Click OK.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (11838) applies to Microsoft Excel 2007 and 2010.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...


Removing All Comments

Need to get rid of all the comments in your document? You can do so by using the regular Find and Replace feature of Word.

Discover More

The Line that Won't Go Away

Have you ever had a line appear on your document that you can't seem to get rid of? It could be due to a built-in ...

Discover More

Using Call to Run VBA Macros

An elegant way to run macros from within macros is to use the Call statement. In order to use it, you need to provide a ...

Discover More

Excel Smarts for Beginners! Featuring the friendly and trusted For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. Check out Excel 2013 For Dummies today!

More ExcelTips (ribbon)

Alt+Enter Stopped Working Correctly

What do you do if a keypress you know worked correctly before all of a sudden stops working as you expect? This tip ...

Discover More

Copying to Very Large Ranges

Using the mouse to select a large cell range can be frustratingly slow. If you want to make copying to a large range of ...

Discover More

Trimming Off All Spaces

The easy way to get rid of spaces at the beginning or end of a cell's contents is to use the TRIM function. ...

Discover More

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.


If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is seven minus 2?

2017-05-03 00:04:58



resolved my 5 months excel facing problem

2017-04-02 01:57:49

Ajith Kumar

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?

2017-01-27 06:49:23


Thank you for your support

2017-01-19 08:33:51


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

2016-11-27 02:51:19


Very very useful.... thanks lot

2016-11-08 15:23:14

Estefania Leon

Iw worked perfectly. Thx

2016-09-07 09:46:05


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

2016-09-07 09:34:38


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

2016-09-02 04:25:24



2016-08-23 09:34:58


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.

2016-07-08 16:19:04


Great !!!!

Everything got fixed in a snap.

Thanks a lot for the tip.

2016-06-13 11:37:54


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.

2016-06-06 14:50:32


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

2016-06-01 05:42:58


Great thanks for help

2016-05-25 13:26:23

LeAnn V

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

2016-03-31 15:41:43


checking the edit directly in the cell fixed it for sure

2015-12-29 19:24:11

Steve D.

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

2015-10-29 03:25:39


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).

2015-08-10 10:28:18

Bill Swidal

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.

2015-08-05 02:31:19


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

2015-06-03 13:42:51



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

2015-02-25 16:55:02


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.

2015-01-19 06:34:45


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.

2015-01-06 07:35:54


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

2014-12-24 09:55:02


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 . . .

2014-11-20 14:56:32


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?

2014-11-20 01:59:50


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

2014-09-16 20:43:43


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.

2013-07-04 14:13:59


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

2013-04-19 05:33:06

mr T

Change The Mouse..

try this 0_o'

2013-02-08 10:52:17


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.

2013-02-06 04:17:30


This dint work for me.

2013-01-09 16:07:26


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.

2012-12-10 14:15:57


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 ( 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.

This Site

Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.

Newest Tips

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.