As a regular Excel user, it is common to use scrolling while working with a big dataset. The scroll bar helps us to do this job perfectly. The vertical scroll bar mainly focuses on scroll up and scroll down purposes, But there are some cases when the vertical scroll bar is not working on your Excel. This is a very frustrating problem to have. You can face major problems if your vertical scroll bar doesn’t work properly. This article will focus on the reason and possible solution for the vertical scroll bar not working properly.
Download Practice Workbook
Download the practice workbook
10 Possible Solutions for Vertical Scroll Bar Not Working in Excel
Before going to any solution, you need to understand the problem clearly. While working with a big dataset, it is a must to use scrolling to go through the data. But sometimes, the vertical scroll bar is working in Excel. That means you can’t go up and down by scrolling which is very irritating in most cases.
We have found ten different and effective solutions to solve this issue. Any of them can solve your problem effectively.
Solution 1: Enable Vertical Scroll bar
One of the main reasons for the vertical scroll bar not working in Excel is because of the uncheck of the vertical scroll bar in the Excel options advanced command. To enable the vertical scroll bar, you need to follow the following steps.
Steps
- First, go to the File tab in the ribbon.
- Next, in the File tab, select the More command.
- Then, select Options from the More command.
- An Excel Options dialog box will appear.
- Next, select the Advanced option.
- Then, scroll down and find out Show vertical scroll bar option.
- If it is in uncheck condition, check on it.
- Finally, click on OK.
- As a result of this, you will see the vertical scroll bar on the right side of your dataset.
Read More: [Solved!] Scroll Bar Not Working in Excel (5 Easy Fixes)
Solution 2: Turn Off Scroll Lock
Secondly, another important reason for the vertical scroll bar not working in Excel is because of the scroll lock. If the scroll lock turns on, it will stop scrolling from cell to cell vertically and horizontally in both ways. To turn off the scroll lock, you need to follow the following steps carefully.
Steps
- First, open a new or existing worksheet.
- At the bottom of the worksheet, right-click on it to open the Status bar.
- From the Status bar, search the scroll lock option.
- See whether the scroll lock is on or off which is shown next to the scroll lock,
- If the scroll lock is on then use your physical keyboard and press the Scroll Lock button.
- Next, you can turn the scroll lock off by using the On-Screen keyboard.
- Go to the windows search option.
- From there, search On-Screen Keyboard.
- Click on the On-Screen Keyboard.
- It will appear like our physical keyboard.
- In the On-Screen Keyboard, uncheck Scrl K which is the actual scroll lock in the On-Screen Keyboard.
- It will eventually disable the scroll lock.
Solution 3: Unfreeze Panes
If your dataset is in freeze condition, you can’t use vertical scrolling in Excel. Because freeze panes will restrict any kind of scrolling. To use vertical scrolling in Excel, you need to unfreeze the panes. Follow the following steps carefully.
Steps
- First, go to the View tab in the ribbon. ‘
- Then, select Freeze Panes from the Window group.
- Next, from the Freeze Panes drop-down, select Unfreeze Panes.
It will unlock all rows and columns to scroll through the entire worksheet. More importantly, it will help to work the vertical scrolling in Excel again.
Read More: How to Adjust Scroll Bar in Excel (5 Effective Methods)
Solution 4: Disable Zoom on Roll with IntelliMouse Feature
You may face a vertical scrolling problem in your Excel because of checking on the Zoom on Roll with IntelliMouse option. To uncheck this, you need to follow the following steps.
Steps
- First, go to the File tab in the ribbon
- Next, in the File tab, select the More command.
- Then, select Options from the More command.
- An Excel Options dialog box will appear.
- Next, select the Advanced option.
- Now, in the Editing Options, uncheck Zoom on roll with IntelliMouse.
- Finally, click on OK.
As a result of this, you may fix the vertical scroll bar not working in the Excel issue.
Solution 5: Turn Off Automatically Hide Scroll Bar in Windows
You can fix the vertical scroll bar not working problem by turning off Automatically hide scroll bars in Windows. This can solve your vertical scroll bar issue effectively. Please follow the steps to turn off Automatically hide scroll bars in Windows.
Steps
- First, go to the Start menu of your computer.
- Next, select Settings.
- From the Settings option, select Ease of Access.
- Then, select the Display option.
- Under the Simplify and personalize Windows group, turn off Automatically hide scroll bars in Windows.
As a result of this, we will see your vertical scroll bar working properly.
Read More: [Fixed!] Excel Horizontal Scroll Bar Not Working (8 Possible Solutions)
Solution 6: Scroll Up and Down Through Context Menu
We can simply right-click on the vertical scroll bar to scroll up and down. If your vertical scroll is not working in Excel, you can use this method also. To do this, just right-click on the vertical scroll bar, and a context menu will appear. From there, select scroll up and scroll down to scroll vertically,
Solution 7: Release Shift Key from Stuck
Due to carelessness, sometime the Shift key may be stuck in. If the Shift key is stuck, the vertical scroll bar will not work in Excel. To remove this issue, just simply release the Shift key from being stuck. Then, you will see the vertical scrolling working perfectly.
Solution 8: Utilize Keyboard Shortcut to Scroll Vertically
If your vertical scroll bar is not working in Excel, you can utilize the keyboard shortcut to scroll vertically. You can just use the Up Arrow and Down Arrow on your keyboard. You can use the combination of Ctrl+up arrow or Ctrl+down arrow. But the main difference between them is the combination will take at the top or at the bottom of your dataset.
Solution 9: Re-Open Excel Application
Another basic solution is to close the Excel application and re-open it. This is a very simple procedure. Sometimes, when you work on your worksheet, due to some carelessness you may face the vertical scroll bar not working issue. To eliminate this problem, just the Excel application without saving it. This will undo all the new work you have done on your worksheet and also undo the changes you made in your unconscious mind. Then, open the Excel application again.
Solution 10: Re-Install Microsoft Office
If the above solution can’t give you proper solutions, you need to uninstall your Microsoft office and reinstall it. It will give you a fresh platform. To uninstall your Microsoft Office, please follow the steps carefully.
Steps
- First, go to the Windows Search Engine.
- Then, write Control Panel in the search box.
- Next, click on the Control Panel.
- The Control Panel dialog box will appear.
- From the Programs option, select Uninstall a program.
- Then, The Programs and Features dialog box will appear.
- Next, scroll down and find the Microsoft 365-en-us
- After that, click on it and then Uninstall it.
- It will take some time to uninstall the application.
- Then re-install it after some time. Hopefully, it will solve your problem.
Conclusion
We have shown ten effective solutions to solve the vertical scroll bar not working in Excel issue. All of them are really useful to use for solving your problems. We want to cover every possible solution through which you can easily solve the vertical scrollbar not working issue in Excel. I think you enjoy the whole article and find it really informative. If you have any questions, feel free to ask in the comment box, and don’t forget to visit our ExcelDemy page.
