Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

[Solved]: Excel Scroll Bar Moves but Sheet Does Not (2 Solutions)

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.


Download Practice Workbook

You may download the following Excel workbook for better understanding and practice it by yourself.


2 Suitable Solutions If Excel Scroll Bar Moves but Sheet Does Not

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.

Suitable Solutions If Excel Scroll Bar Moves but Sheet Does Not


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.

Utilizing Freeze Panes  if Excel Scroll Bar moves but Sheet Does Not

  • 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.

Read More: [Fixed!] Excel Scroll Bar Too Long (5 Solutions)


Similar Readings


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.

Applying VBA Code if Excel Scroll Bar moves but Sheet Does Not

  • 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.
VBA CODES
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.

Read More: [Fixed!] Excel Scrolling Too Many Rows (2 Easy Solutions)


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.


Related Articles

Tags:

Bishawajit Chakraborty

Bishawajit Chakraborty

I'm Bishawajit Chakraborty. Hello. I graduated from Rajshahi University of Engineering & Technology (RUET) with a degree in Mechanical Engineering. I'm working with ExcelDemy as a Content Developer for Excel & VBA. You can visit our website, Exceldemy if you'd like to read my published articles on MS Excel and VBA.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo