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. Restore missing scroll bars.
You might be asking “How to fix the screen won’t scroll in Excel?”
For some reason, Excel randomly freezes the panes on these worksheets from time to time. So, when I click on a tab and the screen won’t scroll, the solution is to click on View, select Freeze Panes, and select Unfreeze Panes. Now you’ll be able to scroll in Excel again, like magic.
If you have a Windows computer, you can also use the Windows on screen keyboard. Press your Windows key on your keyboard, then type in on-screen keyboard and hit enter. That should launch the on-screen keyboard applet. Click on the scroll lock key to toggle off that option, then close the app to go back to Excel.
Click Options to open the window in the image directly below. Click the Advanced tab on that window. Then select the Show vertical scroll bar checkbox. Select the Show horizontal scroll bar option if Excel doesn’t display that scroll bar. Click the OK button to exit. Is the Shift key stuck?
No, even if I have just one file open, it still won’t scroll. I click on various cells just be sure (One cell at a time)., and change tabs. Close a file, open a new one., and same thing. I can scroll down using the bar on the side of the screen and using up/down keys.
Can You scroll down using the arrow keys on the keyboard?
Sometimes this happens if you have another Excel spreadsheet open and it has a cell selected. In that case your options are limited to editing that cell.