We occasionally need to scroll through your dataset while working with massive Microsoft Excel. You can do that in Excel by using the scroll bar. However, occasionally you could notice that the vertical scroll bar is moving but the sheet is not functioning in your Excel document. There can be a few different explanations for it. Below, we’ll go over them and attempt to offer some solutions. This article will demonstrate 2 suitable solutions if the Excel scroll bar moves but the sheet does not.
Excel Scroll Bar Moves but Sheet Does Not: 2 Suitable Solutions
In this article, you will learn how to solve the problem if the scroll bar moves but the sheet does not by utilizing Freeze Panes and applying the VBA code. Here, we will apply the Freeze Panes command first to demonstrate that if we move the scroll bar but the sheet does not move, Then, we will solve this problem by giving two suitable solutions below. Let’s suppose we have a sample data set.
1. Utilizing Freeze Panes Command for Moving Sheets Along with Scroll Bar
You can freeze your columns and/or rows using the Freeze Panes option so that they won’t move when you scroll down or across to see the rest of your page. Here, you will learn how to solve the problem if the scroll bar moves but the sheet does not work.
Steps:
- Here, we will select the 12th row from where the upper portion of the sheet will not move if the scroll bar moves.
- Firstly, go to the View tab.
- Secondly, choose the Freeze Panes command.
- Thirdly, click on the Freeze Panes option.
- Here, you will see that in the 11th and 189th rows because of moving the scroll bar, the upper part of the sheet does not move.
- Again, go to the View tab.
- After that, select the Freeze Panes command.
- Then, click on the Unfreeze Panes option.
- Finally, you will find a solution where you can move the scroll bar and the sheet moves as well at a time.
2. Applying VBA Code to Move Sheets While Moving Scroll Bar
VBA is a programming language that may be used for a variety of tasks, and different types of users can use it for those tasks. Using the Alt + F11 keyboard shortcut, you can launch the VBA editor. In the last section, we will generate a VBA code that makes it very easy to solve if the scroll bar moves but the sheet does not work.
Steps:
- Firstly, we will open the Developer tab.
- Then, we will select the Visual Basic command.
- Here, you will see that in the 11th and 189th rows because of moving the scroll bar, the upper part of the sheet does not move.
- Here, the Visual Basic window will open.
- After that, from the Insert option, we will choose the new Module to write a VBA code.
- Now, paste the following VBA code into the Module.
- Besides, to run the program, click the “Run” button or press F5.
Sub ScrollBar_Moves_but_sheet_NotWorking()
'Command to Unfreeze Panes
ActiveWindow.FreezePanes = False
End Sub
- So, you will finally discover a technique that enables simultaneous scrolling of the sheet and the scroll bar.
Download Practice Workbook
You may download the following Excel workbook for better understanding and practice it by yourself.
Conclusion
In this article, we’ve covered 2 Suitable Solutions for Excel scroll bar moves but the sheet does not. We sincerely hope you enjoyed and learned a lot from this article. Additionally, if you want to read more articles on Excel, you may visit our website, Exceldemy. If you have any questions, comments, or recommendations, kindly leave them in the comment section below.
