A scroll bar is an essential ingredient in Microsoft Excel. Excel sheets have two sorts of scrolling, vertical scrolling and horizontal scrolling. For vertical scrolling, you should use both your mouse scroll wheel or the vertical scroll bar. Nevertheless, for horizontal scrolling, you want to use solely the scroll bar. What if the scroll bar is missing in Microsoft Excel? How are you able to scroll horizontally in such a case? On this article, I’ll present you some strategies to restore the missing scroll bar in Microsoft Excel.
Repair Scroll bar is missing in Excel
There could be a few explanation why the scroll bar is missing in Microsoft Excel, like incorrect Excel settings. Listed here are some solutions that may enable you restore the missing scroll bar in Microsoft Excel:
- Allow the scroll bar in Microsoft Excel Settings
- Verify if the scroll bar is minimized
- Restore Workplace
I’ve defined all these fixes in element beneath. Earlier than you proceed, I recommend you resize the Excel window and see what occurs.
How to get again Excel Scroll Bar
1] Allow the scroll bar in Microsoft Excel Settings
The commonest reason for the missing scroll bar is it is hidden or disabled. Verify this in Excel settings. The next directions will information you on this:
- Open Microsoft Excel.
- Open the spreadsheet doc in which the scroll bar is missing.
- Go to File > Choices.
- Choose the Superior class from the left facet.
- Scroll down the best pane till you see the Show choices for this workbook part.
- Ensure that the next two checkboxes are chosen:
- Present horizontal scroll bar
- Present vertical scroll bar
If the above-mentioned two choices usually are not chosen, choose them, and click on OK to save the modifications.
2] Verify if the scroll bar is minimized
It is additionally doable that another person has minimized the horizontal scroll bar in Excel. This will occur when you have a shared laptop. Nevertheless, the scroll bar is also minimized by you by mistake.
Open the Excel spreadsheet doc in which the scroll bar is missing. If the horizontal scroll bar is missing regardless of being enabled in Excel Settings, you will note three vertical dots on the underside proper facet. Hover your mouse cursor over these dots.
As you hover your mouse cursor over these three dots, your cursor will change right into a double-sided arrow icon. Now, press and maintain the left mouse click on, and drag it to the left. The horizontal scroll bar will seem after that.
Learn: How do you unlock grayed-out menus in Excel?
3] Restore Workplace
The above two fixes ought to repair the issue of missing the scroll bar in Excel. Nevertheless, if the problem persists, I recommend you restore Microsoft Workplace. Repairing Workplace fixes issues attributable to corrupt Workplace information.
That’s it. I hope this helps.
Why is my scroll bar not working in Excel?
The Scroll Lock may be enabled if the scroll bar is not working in Excel. In case your keyboard doesn’t have an indicator for the Scroll Lock key, you may press it as soon as after which verify if the scroll is working in Excel. Another excuse for this situation is the Frozen Panes. Go to View > Freeze Panes after which choose the Unfreeze Panes possibility.
Why do scroll bars disappear in Excel?
The Scroll bars disappear in Excel if turned off in Excel Settings or minimized by mistake. Verify this in Excel settings and allow them if they’re disabled. Additionally, verify if another person has minimized it (for those who use a shared laptop).
Learn subsequent: This worth doesn’t match the information validation restrictions outlined for this cell.
