Get the Scroll Bar Back in Excel

In Excel, if the Scroll bar is hidden or you cannot get it on the Excel window, there are two quick ways to get it back. And in this tutorial, we are going to discuss it.

Show Scroll Bar(s) Back from the Excel Options

Use the below steps:

1. Go to the File Tab.
2. Open the Excel Options.
3. Click on the Advanced tab.
4. Scroll Down and tick mark both checkboxes.
5. Click Ok to save.

The moment you click OK, you get both scroll bars back.

Hiding or showing a scroll bar is a workbook-level setting. When you hide a scroll bar, Excel only changes the current (active) workbook.

Using a VBA Code to Show Scroll Bar

You can also use a VBA code to show a scroll bar in the Excel window.

Sub ScrollBarOn()
    With ActiveWindow
        .DisplayHorizontalScrollBar = True
        .DisplayVerticalScrollBar = True
    End With
End Sub

• Go to the Developer Tab.
• Open Visual Basic Editor.
• Insert a Module.
• Paste the code and then run it.

And if you want to hide it back, use the following code.

Sub ScrollBarOff()
    With ActiveWindow
        .DisplayHorizontalScrollBar = False
        .DisplayVerticalScrollBar = False
    End With
End Sub