Afia Kona
If you want to adjust Scroll Bar in Excel, this article is for you. Here, we will demonstrate to you 5 effective methods to do the task effortlessly.
Download Practice Workbook
5 Methods to Adjust Scroll Bar in Excel
The following dataset contains the Date, Product Name, and Price columns. We can see both the horizontal Scroll Bar and the vertical Scroll Bar are very tiny. Therefore, if we drag the Scroll Bar up and down or left and right the cell moves really fast. As a result, it creates problems.
To solve this problem, we describe 5 methods to adjust Scroll Bar in Excel. Here, we used Excel 365. You can use any available Excel version.
Method-1: Using Go To Special Feature to Adjust Scroll Bar in Excel
The following picture shows a tiny horizontal Scroll Bar. Therefore, it is clear that there is some data toward the left of the Excel sheet. We will find out the last cell by using the Go To Special feature, and after that, we will adjust Scroll Bar in Excel.
Steps:
- First, we will go to the Home tab > select the Editing option > select Find & Select > select Go To Special.
A Go To Special dialog box will appear.
- Afterward, we will mark the Last cell > click OK.
Here, we will see the last cell is XFC3.
Now, we have to delete the entire area from our dataset to the last cell.
- To do so, first, we will select column XFC.
- After that, we will hold and drag the mouse toward left > we will type CTRL+SHIFT+Left Arrow keys.
Next, we will see that all the cells have been selected. However, we want to unselect the dataset.
- Afterward, we will click on column A, hold on to the CTRL+SHIFT keys and we will drag toward the right.
Now, we can see that our dataset gets unselected, and we can see all the cells from column F have been selected.
- After that, we will release the CTRL+SHIFT keys.
- Then, we will right-click on the selected cells > select Delete from the Context Menu.
- Next, we have to save the file by clicking on the Save button or pressing CTRL+S.
Finally, when we will open our Excel file, we will see that the horizontal Scroll Bar has become bigger and more manageable.
Read More: [Fixed!] Excel Horizontal Scroll Bar Not Working (8 Possible Solutions)
Method-2: Applying Advanced Excel Option to Hide Scroll Bar
For Hiding horizontal and vertical Scroll Bar, will use the Advanced Excel Option. Therefore, we will get rid of the tiny Scroll Bar.
Steps:
- First, we will go to the File tab.
- Then, we will select Options.
An Excel Options dialog box will appear.
- Afterward, we will select the Advanced option.
- After that, from the Display options from this workbook we will unmark Show horizontal scroll bar and Show vertical scroll bar boxes > click OK.
Now, when we return to our worksheet, we will see no Scroll Bar.
Read More: [Fixed!] Vertical Scroll Bar Not Working in Excel (10 Possible Solutions)
Method-3: Employing Keyboard Shortcut to Adjust Scroll Bar in Excel
In the following picture, we can see both the horizontal Scroll Bar and the vertical Scroll Bar are very tiny
Here, we will employ the keyboard shortcut to adjust Scroll Bar in Excel.
Steps:
- First, we will click on cell E1 > we will type CTRL+SHIFT+Right Arrow+Down Arrow keys.
Next, we will see that all the cells right and down of cell E1 will get selected.
- Afterward, we will go to the Home tab > select the Editing option > select Clear > select Clear All.
This will clear up the values that are to the right and down of cell E1, and it will make the horizontal Scroll Bar large.
- After that, we will click on cell A16, and we will type CTRL+SHIFT+Right Arrow+Down Arrow keys.
Next, we will see that all the cells right and down of cell A16 will get selected.
- Afterward, we will go to the Home tab > select the Editing option > from Clear > select Clear All.
This will clear up the values that are to the right and down of cell A16, and it will make the vertical Scroll Bar large.
- Next, we have to save the file by clicking on the Save button or pressing CTRL+S.
Finally, when we will open our Excel file, we will see that both the Scroll Bars have become bigger and more manageable.
Read More: [Solved!] Scroll Bar Not Working in Excel (5 Easy Fixes)
Method-4: Identifying Comments/Notes
In the following picture, we can see that the vertical Scroll Bar is tiny. This is because there might be hidden comments/notes in this Excel file. Highlighting the comments/note and deleting them will adjust Scroll Bar in Excel.
Steps:
- First, we will go to the File tab.
- After that, we will select Options.
An Excel Options dialog box will appear.
- We will select Advanced > we will mark indicators and notes, and comments on hover > click OK.
- Next, we will return to our Excel sheet, we will drag down the vertical Scroll Bar.
We will see that there is a Note in cell B1048574 cell.
- After that, we will right-click on cell B1048574 > select Delete Note from the Context Menu.
- Next, we have to save the file by clicking on the Save button or pressing CTRL+S.
Finally, when we will open our Excel file, we will see that the vertical Scroll Bar has become bigger and more manageable.
Method-5: Excel VBA to Adjust Scroll Bar in Excel
We can see from the following picture that both the horizontal and the vertical Scroll Bars are tiny. We will use the VBA Code to solve this problem. This is a quick way to adjust Scroll Bar in Excel.
Steps:
- First, we will go to the Developer tab >> select Visual Basic. If you do not have the Developer tab, press ALT+F11.
A VBA application window will appear.
- After that, we will go to the View tab > select Immediate Window.
- Afterward, in the Immediate Window, we will type the following code.
ActiveSheet.UsedRange.Select- After that press ENTER.
Now, when we return to our worksheet, we will see that the dataset gets selected and both the horizontal and vertical Scroll Bars become bigger.
Conclusion
Here, we tried to show you 5 methods to adjust Scroll Bar in Excel. Thank you for reading this article, we hope this was helpful. If you have any queries or suggestions, please let us know in the comment section. Please visit our website ExcelDemy to explore more.
