In this Article we will learn how to fix middle mouse button not working issue in Excel.
Now this is an external issue not related to excel functions and sometimes we feel how can it behave differently when using excel files on different computers.
We have sorted out some of the reasons which could cause this problem and the solutions for the same.
Protected Sheet and Workbook
Sometimes the sheets are protected and we don’t have them working like we generally do with unprotected sheets, Please unprotect the sheet and workbook using the Review>Protect/Unprotect sheet /workbook.
Sometimes the user has created the freeze option not in a proper way and the height of the rows is not adjusted properly and we are unable to scroll properly. We can check the same by unfreezing the panes as follows:
- In most cases, users can’t scroll down Excel spreadsheets because there are frozen panes within them. To unfreeze panes in Excel, select the View tab.
- Click the Freeze Panes button.
- Then select the Unfreeze panes option. Thereafter, try scrolling down the spreadsheet.
Uncheck the Zoom on roll with IntelliMouse option
You will see Zoom on roll with IntelliMouse option:
Please uncheck this option and save the file and please check the problem must be solved.
Unhide the columns
Such situation happens. It is possible you hidden all columns to the end. Try to unhinde them to get your middle mouse button working back.
Restore horizontal scroll bar
One of the reasons your scroll doesn't work is that there is no horizontal scroll bar. You may not see it at first glance as it is usually not paid attention to. Scrollbars are enabled by default.
To restore the horizontal scroll bar, select the appropriate option in the Excel menu. Go to the ribbon and click File> Options> Advanced. Select the show horizontall scroll bar option.
Disable the scroll lock
Another possibility that the mouse wheel doesn't work is scroll lock. You may have forgotten this key on your keyboard. The scroll lock key may prevent the window from scrolling.
Turn off scroll lock on your keyboard. In many keyboard models, the scroll lock is indicated by an additional light. Make sure the scroll lock key is turned off to be able to scroll the worksheet in Excel.