Scroll Wheel Doesn't Work when Editing

by Allen Wyatt
(last updated December 24, 2014)

34

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

MORE FROM ALLEN

Protecting Worksheets from Deletion

If you share a workbook with others in your office, you will probably want to make sure that some of the worksheets don't get ...

Discover More

Saving Find and Replace Operations

Want to repeat the same Find and Replace operation over and over again? Here are a couple of ways you can improve your ...

Discover More

Looking Backward through a Data Table

Sometimes you need to look backward, through the information above your formula, to find the data you need. This can be done ...

Discover More

Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!

More ExcelTips (ribbon)

Uncovering and Removing Links

Excel allows you to reference data in other workbooks by establishing links to that data. If you later want to get rid of ...

Discover More

Understanding AutoComplete

Entering data in a worksheet can be time consuming. One of the tools that Excel provides to make entry easier is ...

Discover More

Swapping Two Cells

If you need to swap the contents of two cells in your worksheet, Excel provides a number of ways you can approach the task. ...

Discover More
Subscribe

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

View most recent newsletter.

Comments

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 8Mpixels. 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 6 - 4?

2017-05-03 00:04:58

Rajan

Excellent....


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

demeke

Thank you for your support


2017-01-19 08:33:51

Nicolas

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


2016-11-27 02:51:19

balaji

Very very useful.... thanks lot


2016-11-08 15:23:14

Estefania Leon

Iw worked perfectly. Thx


2016-09-07 09:46:05

Ron

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


2016-09-07 09:34:38

Ron

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

KIRTI

PERFECT. THX A LOT


2016-08-23 09:34:58

bob

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

Felperriv

Great !!!!

Everything got fixed in a snap.

Thanks a lot for the tip.


2016-06-13 11:37:54

TYever

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

Jon

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


2016-06-01 05:42:58

vibhishan

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

donnie

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

Aymen

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

Asad

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


2015-06-03 13:42:51

Phil

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


2015-02-25 16:55:02

Francois

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

Thomas

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

anonymous

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


2014-12-24 09:55:02

Charley

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

John

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

John

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


2014-09-16 20:43:43

Paul

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

ReshRam

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

Maciek

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

Thanuja

This dint work for me.


2013-01-09 16:07:26

Nik

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

Jeff

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.


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
Subscribe

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.