Some user present a weird issue where ca n’t scroll in Microsoft Excel . This can impact the canvas or even the complete workbook . Some reasons behind you not being able to scroll in Excel include dynamic ringlet lock , frozen Lucy in the sky with diamonds , misconfigured scroll background , and step in attention deficit disorder - ons . Try these fixes to purpose the locked scrolling error in Microsoft Excel .
Table of Contents
1. Check If You Can Scroll Elsewhere
Firstly , you must see if the ringlet problem occurs in the Excel app only or if is it a system - wide issue . understate Microsoft Excel and openFile Exploreror aweb web browser app . unfold a site and adjudicate to scroll with the mouse rack . If you’re able to scroll everywhere else except Microsoft Excel , then try the next method .
2. Terminate and Restart Microsoft Excel
Microsoft Excelcan meet a glitch and cease working by rights . So , terminate the app and restart it . Here ’s how :
1.Press theCtrl + Shift + Esckeys at once to open theTask Manager .
2.Find Microsoft Excel in the list and right - sink in on it . Select theEnd Taskoption .
3.Press theWindowskey , typeExcel , and pressEnterto plunge the app .
4.Open any file and delay if you’re able to scroll now .
3. Inspect the Shift Key
If you press the Shift key and then seek scrolling in Excel , it wo n’t work . So , end pressing the shift key , if you are doing it accidentally . Also , check the switch key fruit to see if it is n’t stuck .
4. Turn Off the Scroll Lock
After checking the Shift key , verify if the Scroll Lock is participating or not . Some keyboards do not have an indicator to mean if the key is participating or not . So , press the Scroll Lock key on your keyboard to disenable it . or else , you may also display the whorl lock condition in Excel . Here ’s how :
1.launch the file in Excel .
2.Navigate to the bottom palm and right - select it . press theScroll Lockoption .
Now , you will see the roll lock condition in the bottom decoration whenever it is alive . you could use it as an index to disable it via the keyboard .
5. Unfreeze Panes in the View Settings
Frozen Zen can foreclose you from scroll in Excel . If that is the casing , you must Unfreeze Panes in the app . Here ’s how to do it :
1.Go to the top bar in Excel and come home on theViewtab .
2.tap theFreeze Panesoption to flourish the part . Then select theUnfreeze Panes .
3.Now , seek to scroll using the shiner and confirm whether it turn .
6. Check the Scroll Bar Status
Excel has both horizontal and vertical scroll bars and if you do n’t see them in the app or they do n’t work as mean , you must fine-tune its preferences . Here ’s how :
1.Go to the top bar and press theFilebutton .
2.Click onOptionsin the left sidebar at the bottom .
3.Now , press theAdvancedoption .
4.Scroll down and locate theDisplay choice for this workbook : section .
5.tap theShow horizontal scroll bar checkbox to enable it . Then , snap on theShow perpendicular scroll barcheck box to enable it as well .
6.Now , press theOKbutton to utilise the change .
7. Tweak Zoom Settings
If you have incidentally enabled an IntelliMouse setting in Excel , it will zoom the file instead of scroll . So , you must invalid the setting in Excel options . Here ’s how :
2.Click onOptions .
4.Locate theEditing optionssection .
5.select theZoom on roll with IntelliMousecheckbox to uncheck it . Then , select theOKbutton .
6.shut the options window .
8. Change Mouse Wheel Properties
Many users recover a workaround where alter the mouse wheel properties helped them to scroll one screen at a clip in Excel . Here ’s how to do it :
1.Press theWindows key + Rto exposed theRun dialog corner . Typecontrol main.cpl,,3 in the text box and pressEnter .
2.select theOne screen door at a timeoption .
3.Now , tap theApplybutton and then tap theOKbutton .
4.see if you may scroll now .
9. Reopen Excel File Without Add-ons
Oftentimes a VBA , macros , or anExcel add - oncan make problems with some files . So , you must plunge Excel in secure mode and then launch the single file while in effect disabling all of these elements . Here ’s how :
1.Completely close Excel using the Task Manager .
2.Press theWindows key + Rto open theRun dialog box . Typeexcel /safein the text boxful and pressEnter .
3.Excel will launch in good mode now . shop and start the Indian file you were facing an outcome with and confirm whether the scrolling problem persist or not .
10. Repair the File
If the Excel file or workbook is corrupt , you’re able to try furbish up it . Here ’s how :
1.Launch Excel and select theOpenoption .
2.Browse your PC for the file and sink in on it to select it . Then tap thearrowicon next to theOpenbutton and select theOpen and repairoption .
3.select theRepairbutton .
await for the file repair to complete . It will automatically afford in a new windowpane .
11. Update Microsoft Office
An superannuated and cracked facility ofMicrosoft Officecan also cause issues with one or more of the apps . So , you must manually update the app . Here ’s how :
1.Open any Microsoft Office app ( Excel , Word , or any other ) . get through on theAccountoption .
2.select theUpdate optionsicon . Then clack on theUpdate Nowoption .
The utility will check for updates and set up the late one .
12. Repair Microsoft Office
If update Microsoft Office did n’t fix the issuance or you are already using an updated physique , you must touch on the current facility . Here ’s how :
1.Press theWindowskey , typeappwiz.cpl , and pressEnter .
2.Find Microsoft Office in the listing and mightily - tap it . Select theChangeoption .
3.press theRepairbutton to perform a flying repair and fix common issues with the app .
4 . Closethe Control Panel and relaunch Excel to see if the job occurs again .
13. Reinstall Microsoft Office
The last repair is to reinstall Microsoft Office on your PC . It will remove the cracked installing and corrupt single file and then install a fresh written matter of the app . Here ’s how :
2.Find Microsoft Office in the list and mightily - tap it . Select theUninstalloption .
4.Redownload and set up Microsoft Office on your personal computer . Check and see if the event is mend or not .
Scroll Freely in Excel
We go for you are capable to scroll in Microsoft Excel now . Meanwhile , you may also use the arrow keys on your keyboard to move from one prison cell to another . It may not be as fast as using a mouse wheel but get the occupation done as you will be efficaciously scrolling up and down the sheet .
Microsoft OneNote Icons and Symbols Meaning – App/Desktop
50 Years of Microsoft: 11 Times Microsoft Fumbled and Missed…
How to Transfer Windows 11 to a New Drive/SSD (Step-by-Step)
Microsoft Office is Now Free on Desktop – But With…
How to Install Windows 11 on PC With Unsupported Hardware
Windows 10’s End is Near: What Are Your Options?
Windows 11 Camera Not Working? Here’s How to Fix It
Windows 11 “Resume” Feature: Seamlessly Switch Devices
Windows 11 Installation Has Failed? Easy Fixes to Try
Windows 11’s Multi-App Camera Support: How to Enable and Use…
